Live data from Hacker News

Electric (Postgres sync engine) beta release

electric-sql.com

61–70 of 72 posts

Re: Electric (Postgres sync engine) beta release

#61
post #55

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…

We have a good solution in mind. Check back in a few months!

Re: Electric (Postgres sync engine) beta release

#62
post #51
post #38

Earlier 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.

Mine is simple but relies on a few cheap tricks (like generating uuids in the frontend and manually linking relationships in an order where replaying on the db is going to work). Happy to walk you through it if you want to message me.

Re: Electric (Postgres sync engine) beta release

#64
post #26

Earlier 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.

Oh this is very cool as well. Thank you for sharing. I hadn't heard of LiveStore.

Re: Electric (Postgres sync engine) beta release

#65
post #31

Eagerly 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

I've heard about this one as well. I'm not sure why it seems to have less "hype" than Zero or ElectricSQL. I'm going to play with it this weekend. Thanks for sharing.

Re: Electric (Postgres sync engine) beta release

#66
post #54

Eagerly 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

Another one I have to play with. Thanks for sharing.

Re: Electric (Postgres sync engine) beta release

#67
post #43

Is 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?

In theory Retool would be this, but it's clunky for the interface designer - namely, it assumes you might have different custom read and write paths, so it makes you jump through hoops in setting up a Cell Change Handler linked to a Query that writes to the database. See: https://community.retool.com/t/auto-save-table/16044

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

#68
post #24

Eagerly 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).

Any thoughts on Flutter support? I believe that existed in the previous version of Electric.

Re: Electric (Postgres sync engine) beta release

#69
post #8

I may be misunderstanding, but does this boil down to essentially a partial read replica?

It's closer to Firebase on Postgres, in my opinion.

Isn't that just Supabase? I don't think Electric has much to do with PaaS like Firebase or Supabase.

Re: Electric (Postgres sync engine) beta release

#70
post #50
post #45

Earlier 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...

Ok, so PGLite is used in the Firebase Data Connect's emulator: a test utility, not even the client library.

It's a bit disingenuous to lump it in the same sentence and try to mislead user that Google's adopting Electric.

Post reply on HN