tfw appeasing the type checker is more work than writing the actual code.
Matt
2,972 posts
- I never thought cross-device sync and multiplayer could be sooooo easy. With CRDTs on SQLite I just declare which tables are synced and voila, my app is multiplayer. github.com/tantaman/Strut…
00:00 - One of the things I'm most excited for is partnering with the LibSQL folks to create a custom syntax for defining tables which are backed by CRDTs! LibSQL is truly getting SQLite ready for the coming decades -- github.com/libsql/libsql vlcn.io/cr-sqlite/cust…
- Found a hornets nest on tech twitter. Here's some TypeScript types from Prisma:
- Interested (or know someone interested) in databases? Conflict-free data types? p2p? Looking for help on github.com/vlcn-io/cr-sql… - ~130 companies signed up for the beta release - $16,000 in paid sponsorships over the last 6 months - 1.2k github stars - Front page HN 3x
- "Most databases were built when data was static and queries were dynamic. For applications, most queries are static and the data is dynamic" - @matthew_linkous I never thought about it this way before but this is spot on.
- CRDT extension successfully compiled and running in the new official SQLite WASM. Adios absurd-sql and sql.js
- Working on a post but I present a React table of 2 million rows, dynamically filtered in real time. tldr: the data structure backing the table is maintained via differential dataflow so we only need to process the single row that changed rather than the entire set when filtering
00:00 - A little talk on using SQLite as a Collaborative & Multiplayer Application File Format
- Replying to @tantamanquite worth it for the perfect auto-complete. Even prevents you from selecting ambiguous fields.
- I was blown away by @aboodman's talk and the Replicache model so I spent the last day experimenting with a variation on the idea: "Creating CRDTs without specialized knowledge" vlcn.io/articles/crdt-…
- A Gentle? Introduction to CRDTs vlcn.io/blog/gentle-in…
- This confluence of things: - Event sourcing - CRDTs & Causal Graphs - Incremental View Maintenance is going to unlock some stellar new infrastructure. 1. Event source your entire app. 2. Incrementally maintain app state as a view of events. 3. Rebase events for multiplayer.
- CRDTs -- design overview of conflict free sqlite