thruflo

11 ms·

61.
by thruflo 3y ago
Hey, thank you :) We currently use IndexedDB for the virtual filesystem underneath the wa-sqlite [1] WASM SQLite driver in the browser. But yup, that means a ~1.1MB WASM download. We'll definitely stay with SQLite in the client. One of
62.
by thruflo 3y ago
Hey, James here, one of the co-founders of Electric. Both projects are doing active-active CRDT-based sync. Our focus is on sync via Postgres and on compatibility with existing Postgres-backed applications. So you can drop Electric onto an
63.
by thruflo 3y ago
https://www.fabfile.org
64.
by thruflo 3y ago
ElectricSQL | Senior Frontend Engineer (up-to €100k) & Local-first Software Developer (up-to €50k) | Full-Time | REMOTE in Europe At https://electric-sql.com we're building an open source platform for local-first softwa
65.
by thruflo 3y ago
We (ElectricSQL) have some work underway on a Rust/WASM port of our core client component, that’s designed to open up more language support. This is a community contributed Dart/Flutter client https://github.com/Sk
66.
by thruflo 3y ago
Thanks! We’ve just opened up a call for design partners[0] if you (or any teams out there) might be interested in collaborating with us :) [0] https://next.electric-sql.com
67.
by thruflo 3y ago
You can if you acquire a distributed lock in advance, as per https://electric-sql.com/blog/2022/05/03/introducing-rich-cr...
68.
by thruflo 3y ago
This is a list of research papers on CRDTs, published on the main open source reference site about CRDTs, curated by Martin Kleppmann, Annette Bieniusa and Marc Shapiro. That’s about as canonical as you can get. The papers obviously referen
69.
by thruflo 4y ago
It’s totally valid and acceptable. If equity is part of your comp, you’re investing your time in exchange for equity in the company. The first document any investor would ask for is the cap table. Beyond the % it also helps you evaluate whe
70.
by thruflo 4y ago
Migrations are a really hard problem for local-first, because (as the article says): a. clients can be running old code that can’t handle the new schema b. clients can write data locally using an old schema that you want to merge into the n
71.
by thruflo 4y ago
Yes, exactly. There are no absolutes but normally fundraising is hard and you need to get 99 ticks out of 100. So starting with `x`s built in makes it tough. There’s definitely good people in academia and industry who could be great founder
72.
by thruflo 4y ago
It’s very hard to align venture building with investability. The more equity the venture builder takes, the less attractive the business. If the venture builder may need to be washed out, it puts early investors at risk of being washed out
73.
by thruflo 4y ago
You can have transactional causal consistency with an AP system. Combined with CRDTs it’s very powerful. You also have mixed (“just right”) consistency systems and techniques to introduce and optimise the use of runtime coordination where n
74.
by thruflo 4y ago
Hey, link for the curious: https://electric-sql.com Hybrid serverless <> local-first is the future. Neon in the client would be so cool.
75.
by thruflo 4y ago
Erlang is a great language and runtime to build distributed systems in but it doesn’t provide primitives to resolve concurrent overlapping updates. Hence projects like https://www.antidotedb.eu (CRDT database in Erlang)
76.
by thruflo 4y ago
From the article, this appears to be an implementation of Making CRDTs Byzantine Fault Tolerant [0] in Rust [1]. [0]: https://martin.kleppmann.com/papers/bft-crdt-papoc22.pdf [1]: https://github.com/jac
77.
by thruflo 4y ago
Yup, open source ( https://github.com/electric-sql ) + managed replication-as-service. Some of our service code (eg: infra, control plane) is proprietary. Download size depends on the driver (we support different SQLite drive
78.
by thruflo 4y ago
Hey, yup, definitely. It should be very similar to the Cordova integration. You can also follow the generic driver integration instructions [0]. Basically need to implement an adapter interface and compose the various utilities. Happy to he
79.
by thruflo 4y ago
Yup, it’s a very rigorous system developed over ~10 years with solid testing, benchmarking and formal proofs. However it has some known issues, such as behaviour under high load and not currently handling node failure within a DC. It’s not
80.
by thruflo 4y ago
Very cool! Would love to swap ideas if you're up for a chat :)
81.
by thruflo 4y ago
> What I really want to see next is an eventually consistent sync system between browser and server We’ve made one: https://electric-sql.com Active-active SQLite to Postgres with transactional causal+ consistency based on CRD
82.
by thruflo 4y ago
Interesting — so basically an overhead until it’s fully native? I was reading the Chrome initiative as a pathway to native. Would that mean it can’t be WASM?
83.
by thruflo 4y ago
The Google Chrome team is working with the SQLite team to standardise a WASM based SQLite in the browser to replace WebSQL. https://developer.chrome.com/blog/deprecating-web-sql/ https://twitter.com&#x2
84.
by thruflo 4y ago
I just want to recommend https://overcomingms.org/recovery-program/diet My wife has relapsing remitting MS and manages it very effectively with this diet. It’s not easy — cutting out lots of fats - but doing so has a r
85.
by thruflo 4y ago
Looks great, congrats on shipping :)
86.
by thruflo 4y ago
Yes, I’ve done this with LiveView and Tauri and it works. At the time, the barrier to my investigations was LiveView interop with component frameworks. Even Ionic Vue was tricky to get the re-rendering right. Having a native framework ontop
87.
by thruflo 4y ago
Ditto is the real deal and the best CRDT database out there atm. There are expressive CRDT libraries like Yjs and Automerge but these don’t give you persistence. There are mature databases out there that include CRDTs, like Redis and Postgr
88.
by thruflo 4y ago
This is really cool. It takes a hard domain — multiplayer — and makes it much more accessible. I think the docs link is a great intro: https://docs.hathora.dev
89.
by thruflo 4y ago
I’ve founded companies in the UK, US and EU. I’d recommend the UK. The cost of a limited company is £12. It’s formed in a day. Use https://www.ukpostbox.com if you need an address. The legal system is well known and entrepreneur
90.
by thruflo 4y ago
Also how does the WAL page based replication maintain consistency / handle concurrent updates?

More ›