Tag Collection

#databases

Showing 3 articles in this topic

RSS Feed
Building Rock-Solid Offline-First Mobile Apps: CRDTs, Replicache, and Last-Write-Wins

Building Rock-Solid Offline-First Mobile Apps: CRDTs, Replicache, and Last-Write-Wins

Build resilient offline-first mobile apps. Practical strategies for optimistic UI mutations, delta syncing, and CRDT conflict resolution in unstable networks.

4 min read
#mobile #offline-first #architecture #databases
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