thruflo

7 ms·

31.
by thruflo 2y ago
Hey, Electric co-founder here. Yup, our reactivity is quite simple at the moment, as described, and works quite well because SQLite is so fast. There are other projects doing more sophisticated reactivity algorithms, like Riffle/LiveSt
32.
by thruflo 3y ago
ElectricSQL | Remote - EU | Full-time | https://electric-sql.com ElectricSQL is an open source platform for building local-first software. We’re a small technical team hiring for a: - Product Advocate / Engineer - Sta
33.
by thruflo 3y ago
Yup, this is based on work by Neon. Also the Neon model allows you to sync in a database on demand, whilst scaling to zero when you’re not using it.
34.
by thruflo 3y ago
The previous PG WASM projects from Crunchy and Snaplet have run Postgres in a VM and required a large 32MB download. This is pure WASM, no VM, 3.7MB download. Plus it has persistent storage.
35.
by thruflo 3y ago
This event is the 1 year anniversary of the https://lofi.software meet-ups. It's great Discord community to join if you're interested in local-first software development.
36.
by thruflo 3y ago
This looks really well done. Feels like a Hashicorp product -- does one thing well, abstracts across cloud providers and provides a tight DX. Kudos!
37.
How to do secure transactions with a local-first software architecture(electric-sql.com)
2 points by thruflo 3y ago|0 comments
38.
by thruflo 3y ago
This page lists current limitations https://electric-sql.com/docs/reference/roadmap The key features for us on this are: 1. permissions https://electric-sql.com/docs/usage/data-modelling&
39.
by thruflo 3y ago
I think this is very smart. Instead of a big ML ops stack, do your model stuff where your data is. For us, the fact it supports Postgres and SQLite out of the box is awesome. It means we can run a model on the server to generate embeddings,
40.
by thruflo 3y ago
Yup, this is correct. We have had some requests / discussions around adding hooks to the sync service that will support custom logic on the write path (as per https://github.com/electric-sql/electric/discussio
41.
by thruflo 3y ago
Hey, James here from Electric. Congratulations to the PowerSync team :) As a sibling comment says, PowerSync actually wrote up a comparison here https://www.powersync.com/blog/electricsql-vs-powersync Aside from Electr
42.
by thruflo 3y ago
One of the great things about the Elixir ecosystem is that, in so many cases, the libraries you’re using make the appropriate use of supervision trees so you don’t have to. Obviously it depends on what you’re building and you can craft your
43.
by thruflo 3y ago
Both these assumptions are incorrect. We maintain consistency and integrity across shape boundaries.
44.
by thruflo 3y ago
Yup, it's not the most sophisticated of cost calculator, obviously there's a wide variation in cost savings from reducing query and compute load and the reduction is app specific. edit: we based some of the calculator variables on
45.
by thruflo 3y ago
Interesting, I don’t know enough about MobX to be sure but yes, you can use the notifier to subscribe to data change notifications and query to get the changed rows. We’d definitely be interested in chatting through the reactivity model you
46.
by thruflo 3y ago
Potentially, but not for a while at least. Technically it’s possible to support different backend databases. But we want to focus on getting Postgres right first.
47.
by thruflo 3y ago
Fixed!
48.
by thruflo 3y ago
Hmm, yes, seems like we might need to bust a cache key there :)
49.
by thruflo 3y ago
Hey, yup, a big part of the new release is a proper system for dynamic partial replication, as per https://electric-sql.com/docs/usage/data-access/shapes
50.
by thruflo 3y ago
Hey, cool and yup, that's exactly the kind of setup we aim to support and we have drivers for both Expo and React Native. Re: RLS, not quite, you'll need to port your rules to our DDLX syntax https://electric-sql.com&#x
51.
by thruflo 3y ago
Hey, thanks :) and yup, lots of complexity and engineering. We're lucky because we're building on a lot of research and previous work. The model is Transactional Causal+ Consistency (TCC+). This has been formally proven to be the
52.
by thruflo 3y ago
We cover this a bit in the architecture page: https://electric-sql.com/docs/reference/architecture Basically Electric is horizontally scalable. You can run multiple Electric sync services on top of Postgres and t
53.
by thruflo 3y ago
Hey, very cool :) We don't recommend production use right now. There's a roadmap page here https://electric-sql.com/docs/reference/roadmap -- we particularly need to flesh out shapes, permissions and val
54.
by thruflo 3y ago
Hey, yup it's definitely a medium term objective. The team at SkillDevs are maintaining a Daft/Flutter client at https://github.com/SkillDevs/electric_dart Plus we have a thread to extract the core client-sid
55.
by thruflo 3y ago
Hey, This is the exact pattern we target :) Drop Electric onto an existing Postgres data model and use the Shape-based sync to manage dynamic partial replication of subsets of data between central Postgres and local SQLites: https:/&#
56.
by thruflo 3y ago
Hey, thanks :) We have a Discord if you fancy chatting at more length! https://discord.electric-sql.com Re: CRDTs and intuition, yup, there's trade offs. We are working hard to deliver a solid model to code against. So we h
57.
by thruflo 3y ago
Thanks :) and yup, definitely, we were digging into the typed-sql repo just the other day.
58.
by thruflo 3y ago
Yup, this is what's addressed by write permissions. You can express who can set salaries and column level rules to validate input values. When it comes to concurrency problems like not spending money twice, the plan is https:/&#x
59.
by thruflo 3y ago
With wa-sqlite in IndexedDB mode we're main thread. In OPFS mode it's a worker thread. With the mobile drivers you go over a native bridge. With Electron / Tauri it's the same as the browser. You're running in Chrom
60.
by thruflo 3y ago
Hey, You can see our database rules spec here: https://electric-sql.com/docs/api/ddlx We haven't implemented it all yet but you can see the intention / direction. It's similar to RLS but adapted for

More ›