PouchDB and SQLDown
summary
Claims that you can run the same local-db code in browser and Node by swapping LevelDB backends, showing SQLDown to use Postgres or WebSQL and PouchDB adapters for syncing, with Postgres still best for complex queries. Demonstrates that geohash with Hilbert curve handles adjacent tile ranges well but fails at nearest-neighbor, so an async R-tree is needed; a published, disk-backed async R-tree wrapped for LevelDB as level-tree is built and used for efficient spatial queries.
AI-written summary · about
chapters (4)
related talks
26mPouchDB and SQLDown
24mA Real Database Rethink, Introducing LevelDB and NodeJS
51mCouchDB, PouchDB and Offline-Tolerant Apps
24mThe Upsidedown Stack: React on the Server and Postgres in the Browser
49mOfflineFirst Apps with PouchDB and CouchDB
22mA Modular Database?
04h 15mTopical Edition on Databases - Track 2
01h 27mYugabyteDB YSQL Development