Md. Sany Ahmed sany2k8

Types of Analyzers

Analyzer	Description	Example Use
Standard	Default; breaks text by word boundaries, removes most punctuation, lowercases tokens.	English prose, general search
Simple	Splits on non-letter, lowercases.	Part numbers, technical terms
Whitespace	Splits on whitespace only, preserves case.	Code, serial numbers
Keyword	Does not split; treats entire text as a single token.	Exact match fields, IDs, tags

Feature	TF-IDF	BM25
Full Form	Term Frequency – Inverse Document Frequency	Best Matching 25
Default in Elasticsearch	❌ (before v5.0)	✅ (v5.0 and later)
Term Frequency Handling	Linear	Saturated (diminishing returns)
Document Length Normalization	Minimal	Tunable and robust
Tunable Parameters	No	Yes (`k1`, `b`)

Use Case	TF-IDF	BM25
Simple scoring model	✅	✅
Accurate relevance for modern search	❌	✅
Normalize for document length	❌	✅
Tune scoring behavior with parameters	❌	✅

📘 SQLAlchemy Relationship Types

This guide demonstrates the four common types of relationships in SQLAlchemy using realistic examples:

✅ One-to-One: User → UserProfile
✅ One-to-Many: Blog → BlogPost

📘 PostgreSQL Query Plan Examples

This document demonstrates various PostgreSQL query plan types, with sample datasets, queries, and EXPLAIN/EXPLAIN ANALYZE outputs.

✅ Step 1: Basic Table and Data

Quick Decision Tree

REST API? → FastAPI
Full web app? → Django
Learning/Prototyping? → Flask
Max performance? → Falcon
Real-time? → Sanic/FastAPI

Framework Comparison

Django

Document stores in PostgreSQL

Notes for software engineering meeting presentation

What

mid to late 2000s: appearance of Document stores / NoSQL databases such as Mongo, Couch
Relational DBs now have support for document data: JSON in MySQL, JSON and JSONB in PostgreSQL
Focus on JSONB in Postgres (most full featured)

PostgreSQL is Enough

Background and Cron Jobs

Commit Message Format

Each commit message consists of a header, a body and a footer. The header has a special format that includes a type, a scope and a subject:

<type>(<scope>): <subject>
<BLANK LINE>
<body>
<BLANK LINE>

	import phonenumbers
	from pydantic.validators import strict_str_validator

	class PhoneNumber(str):
	"""Phone Number Pydantic type, using google's phonenumbers"""

	@classmethod
	def __get_validators__(cls):
	yield strict_str_validator
	yield cls.validate