Category Cluster

Databases & Storage

Showing 2 articles in this category

RSS Feed

Database performance benchmarks and indexing strategies covering PostgreSQL, SQLite, Realm, MMKV, and high-throughput write workloads.

PostgreSQL Indexing Under Fire: B-Tree, BRIN, and Partial Indexes for 20M+ Rows

PostgreSQL Indexing Under Fire: B-Tree, BRIN, and Partial Indexes for 20M+ Rows

Optimize PostgreSQL for high-write workloads. How replacing B-Trees with BRIN and partial indexes saved 18 GB RAM and quadrupled ingestion throughput.

3 min read
#postgresql #databases #backend #performance
Mobile Storage Showdown: Benchmarking SQLite, Realm, MMKV, and Room with 100,000 Records

Mobile Storage Showdown: Benchmarking SQLite, Realm, MMKV, and Room with 100,000 Records

Benchmark 100,000 real records across SQLite, Room, Realm, and MMKV on iPhone and Android. Raw speed, memory footprints, and architectural trade-offs.

4 min read
#mobile #sqlite #performance #databases #flutter