PouchDB and SQLDown

on YouTube ↗26m

" summary

Argues Postgres is best for complex JSON queries but shows a lighter stack for offline work: LevelDB + LevelUP and PouchDB for local storage and sync, and SQLDown lets LevelDOWN use SQL backends (SQLite/WebSQL/Postgres) so the same code runs in browser and node. Describes building a Hilbert-curve quadtree plugin and combining an R-tree with LevelDB as level-tree (R-tree + LevelDB) to store and sync large map tiles; it works but warns IndexedDB/WebSQL adapters hurt query performance.

AI-written summary · about

" chapters (4)

1. 0:00Start
2. 4:01Geo Hashes
3. 5:15Hilbert Curve
4. 17:22Offline Editor

" related talks

• 26mPouchDB and SQLDownCalvin Metcalf · JS.Geo 2015
• 51mCouchDB, PouchDB and Offline-Tolerant AppsLorna Jane Mitchell · Dutch PHP Conference 2017
• 24mA Real Database Rethink, Introducing LevelDB and NodeJSRod Vagg · NodeConf.eu 2013
• 24mThe Upsidedown Stack: React on the Server and Postgres in the BrowserDavid Gomes · React Miami 2025
• 33mSchemaless SQL The Best of Both WorldsWill Leinweber · RailsConf 2012
• 59mPostgreSQL's secret NoSQL superpowersAmanda Gilmore · PGConf Silicon Valley 2016
• 49mOfflineFirst Apps with PouchDB and CouchDBLorna Jane Mitchell · Front End North 2018
• 51mFront End DataJing Chen, Jake Archibald, Nolan Lawson, Matt MacPherson, David Fahlander, Glynn Bird · Edge Conference 2015