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

Real-world strategies for field technicians and spotty network connectivity. How we implemented optimistic local mutations, delta syncing, and conflict-free replicated data types.

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

Stop putting standard B-Trees on every column. How swapping to BRIN and partial expression indexes saved 18 GB of RAM and 4x’d ingestion throughput on a production cluster.

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

We benchmarked reads, writes, transactions, and binary serialization on physical iPhones and Pixel devices across 100,000 real-world entities. Here are the raw stats.

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