The ElectricSQL concept of 'shapes' is interesting. Right now, a shape is just a single table with some column filters and a where clause. The shape is defined on the fly in the query string. Electric does single table sync of those 'shapes' a lot like Supabase realtime. I work as part of the team building Ably LiveSync, a competitor in this space. Our postgres connector[0] works in the opposite way by taking rows fr…
Electric (Postgres sync engine) beta release
61–70 of 72 posts
Re: Electric (Postgres sync engine) beta release
#62Earlier quoted context omitted.
We hit on exactly the same pattern for our product and it works really well. We use Hasura as the read engine. That updates a graph of mobx objects that drive the ui. We apply updates directly to those objects so the ui updates immediately. The mutations are posted back to a Python api that applies them to the db. I’ve looked at Electric because we’ve had to recreate some of what they do to interface with Hasura. At…
Would love to read more about how you have mobx structured here. I have a similar graph of mobx objects for something I’m building but haven’t come up with an ergonomic sync story yet.
Re: Electric (Postgres sync engine) beta release
#63Re: Electric (Postgres sync engine) beta release
#64Earlier quoted context omitted.
Sorry should have mentioned that I need PGlite or SQLite support. I am very much looking forward to PGlite on Expo/RN!
As are we :) btw checkout LiveStore if you haven’t already: https://expo.dev/blog/local-first-application-development-wi... It’s not fully released yet but it is now open to GitHub sponsors and it’s very cool.
Re: Electric (Postgres sync engine) beta release
#65Eagerly awaiting the React Native compatible version. https://zerosync.dev/ is the main alternative I'm considering.
PowerSync ( https://www.powersync.com/ ) is also a great alternative, and my preferred choice. SDK's available for React Native, Flutter, JS, Swift, Kotlin etc
Re: Electric (Postgres sync engine) beta release
#66Eagerly awaiting the React Native compatible version. https://zerosync.dev/ is the main alternative I'm considering.
You should check out Triplit as well, we have React Native support[0] and the best Typescript integration by far 0. https://www.triplit.dev/docs/frameworks/react-native
Re: Electric (Postgres sync engine) beta release
#67Is there any software that let me make graphical user interface to a connected database, allows me to make data visualizations, all things automatic and interactive? Like a node editor or spreadsheet?
Airtable's interface builder is more reasonable in that it ensures that you're always looking at real-time data, and saves happen and propagate to all users whenever you change a character - but this requires that the canonical data live in Airtable. And setting up sync with external systems is clunky. I'm hopeful that people build better tools on top of Electric, because it's ridiculous that we live in 2024 and we don't have interfaces like this out of the box.
Re: Electric (Postgres sync engine) beta release
#68Eagerly awaiting the React Native compatible version. https://zerosync.dev/ is the main alternative I'm considering.
Electric works with Expo / RN now. PGlite is coming — we have a new WASI build that is the basis for native mobile support. (It’s working in dev, but still needs some more polishing and bindings).
Re: Electric (Postgres sync engine) beta release
#69Re: Electric (Postgres sync engine) beta release
#70Earlier quoted context omitted.
Yeah, I'm gonna need a citation on Google's usage of ElectricSQL, considering that the link points to Firebase Data Connect.
https://www.npmjs.com/package/firebase-tools?activeTab=depen...
It's a bit disingenuous to lump it in the same sentence and try to mislead user that Google's adopting Electric.