SQL, PostgreSQL, database design, data storage
Discover
ποΈ Data & Databases
Postgres, schema migrations, psql, relational database
storage engine, query optimizer, MVCC, database internals
vector DB, embeddings, RAG, semantic search
data pipelines, ETL, Apache Spark, data lakehouse
sqlite, embedded database, single-file DB, sqlite3
charts, dashboards, plotting, Matplotlib, Tableau
data analysis, machine learning, statistics, visualization
query planner, cost-based optimizer, join ordering, execution plan, SQL optimizer
LSM tree, B-tree storage, RocksDB, storage engine internals
knowledge graph, linked data, ontology, entity relationships
duckdb, embedded analytics, duckdb spatial, OLAP
log-structured merge, compaction, SSTables, RocksDB
search ranking, BM25, dense retrieval, semantic search
Storage Engines, Query Optimization, B-Trees, WAL, Buffer Management
Database Queries, Data Warehousing, PostgreSQL, Analytics
HNSW, Approximate Nearest Neighbor, Similarity Search, FAISS
clickhouse, columnar database, OLAP, real-time analytics
replication lag, log replication, change data capture, CDC, replica
query planning, execution engine, vectorized execution, DataFusion