SQL, PostgreSQL, database design, data storage
Discover
ποΈ Data & Databases
postgres, SQL, relational database, pg
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, SVG, graphs, interactive visualization, D3.js
data analysis, machine learning, statistics, visualization
query planner, query optimizer, execution plan, SQL optimizer
LSM tree, B-tree storage, RocksDB, storage engine internals
knowledge graph, linked data, ontology, entity relationships
DuckDB, embedded analytics, OLAP, in-process database
search ranking, BM25, dense retrieval, semantic search
LSM tree, log-structured merge, RocksDB, compaction, SSTables
Database Queries, Data Warehousing, PostgreSQL, Analytics
Storage Engines, Query Optimization, B-Trees, WAL, Buffer Management
HNSW, Approximate Nearest Neighbor, Similarity Search, FAISS
ClickHouse, columnar database, OLAP, analytics database
Apache Kafka, Apache Flink, real-time data, event streaming
replication lag, log replication, change data capture, CDC, replica