#database

Practical SQL query tuning guide covering execution order, indexing, keyset pagination, prepared statements, CTEs, and a MariaDB slow-pagination case study.

Comparison of MySQL storage engines (MyISAM, InnoDB, MEMORY) and a deep dive into InnoDB pages, rows, row-size limits, and off-page storage formats.

Introduction to graph databases that store data as nodes and edges, with notes on Neo4j, Dgraph, JanusGraph, and TigerGraph.

Survey of NoSQL storage models (document, key-value, wide-column, graph) with representative databases such as Redis, RocksDB, Cassandra, and MongoDB.

Short overview of relational SQL databases including PostgreSQL, MySQL, TiDB, and ClickHouse, with their typical strengths and use cases.

Explains vector databases built to store, manage, and search embeddings via similarity search, and lists their main applications.

GitHub thay endpoint liệt kê stargazers bằng endpoint trả tối đa 30 tuần đếm sao theo ngày, lọc dải created_at trước khi group; bài học chính là response nhỏ hơn không có nghĩa query rẻ hơn.

Tools and approaches for database access in microservices, covering reverse proxies, load balancers, MySQL clustering, and data synchronization.

Summary of how full-text search works (inverted index, stop words, stemming, relevance ranking) and its support in MySQL.

Compares three relational models for storing tree data (adjacency list, closure table, nested set) and their query and update trade-offs.

Explains database sharding across servers versus table partitioning within one database, including goals, drawbacks, and partition types.

Explains why a database connection is an expensive OS process, how connection pools work, and how to size a pool using Little's Law, Kingman's formula, and the process-to-core ratio.

Guide to MongoDB, the document-oriented NoSQL database, covering its data model, CRUD operations, indexing, aggregation, replication, sharding, and best practices.

Guide to MySQL, the popular open-source RDBMS, covering storage engines, data types, CRUD, indexing, views, procedures, triggers, replication, and best practices.

PGX (pgrundev/pgx, AGPL-3.0) is a Rust runtime that serves hundreds to thousands of isolated Postgres databases from one process by keeping a single Postgres 18.6-compatible engine, minting databases on connect and branching them with ZFS copy-on-write — built for CI, previews and agent sandboxes, explicitly not production.

Guide to PostgreSQL, the extensible open-source RDBMS, covering data types, JSON/JSONB, arrays, full-text search, index types, window functions, CTEs, and best practices.

Overview of Apache Pinot, the distributed real-time OLAP database, its indexing optimizations, and how Uber used it to solve job counting at scale.

Curated list of tools for working with databases, including Docker Compose setups, query builders, LLM-powered query generators, and online SQL playgrounds.

Community discussion on storing document edit history using versioned diffs with periodic full snapshots, plus comparisons to persistent segment trees, ropes, and git blobs.