Re:Building single-page-apps with PostgREST
by nileshtrivedi on Saturday January 29, 2022 @10:34PM
(#30133672)
"Reversible SQL" is such a great idea. PostgreSQL does have pub/sub semantics via LISTEN and NOTIFY. At some level, we should think about removing the centralized database completely, and let all of user's devices synchronize with each other somehow. Perhaps SQLite database files synchronized with syncthing? That would really be fantastic!
[ Parent
| on HN ]
Re:Building single-page-apps with PostgREST
by CuriouslyC on Sunday January 30, 2022 @12:11AM
(#30134249)
CouchDB has a javascript client called PouchDB that can do multi-"master" replication and streaming. I wouldn't use it as a primary database, but the syncing story is pretty much top notch.