3 ms·
Day job (contract): Massive overhaul of an antibody workbench for drug discovery. Evenings: Building out a concept for a "YSQL" bringing CRDTs (Yjs) to SQLite
by samwillis 3y ago
Day job (contract): Massive overhaul of an antibody workbench for drug discovery.
Evenings: Building out a concept for a "YSQL" bringing CRDTs (Yjs) to SQLite and Postgres. CRDTs are great for real-time, but also awesome for offline async collaboration. Using the same CRDT for both front end data structures and backend database merging seems to me to be a good combination. The plan is to build out some simple primitives first, then layer a SQLite (WASM in browser) <-> Postgres sync system on top for local copying and modification of datasets.
Proof of concepts:
https://github.com/samwillis/yjs-sqlite-test https://github.com/samwillis/yjs-sqlite-test
https://github.com/samwillis/yjs-pg-test https://github.com/samwillis/yjs-pg-test