Syncing SQLite and Postgres?

Thanks to Electric SQL for sponsoring this showcase.
Being able to sync between local SQLite databases and cloud or bare metal Postgres is an exciting prospect and Electric SQL has a plan for doing that.
Supporting local-first applications without losing access to tried and true SQL-based relational databases is just super practical to me.
My code that the examples are done with is open and available. Use it as you like:
github.com/law...
github.com/law...
I've had a lot of fun with it as evidenced by the four livestreams:
th-cam.com/users/li...
th-cam.com/users/li... (the best one, globally distributed SQLite on Fly.io)
th-cam.com/users/li...
th-cam.com/users/li...
You can read more Electric SQL below:
Electric SQL site: electric-sql.com/
Demos: electric-sql.c...
Docs: electric-sql.c...
Discord community: / discord
Source code on GitHub: github.com/ele...

[@dadisuperman3472]

I implemented something similar to what you are explaining, but in different design.
It works as a charm.

[@pkop4]

Love the vibe man, very cool. Looking forward to the Elixir story with this tool

[@underjord]

More on that.. soon?

[@VanderleiRobertoMoretto]

Very good

[@softwebsystems5499]

Great work. Can one have several offline SQLite dbs each syncing with a unique PostgreSQL schema?

[@underjord]

Electric SQL are making all sorts of interesting updates. Check their site and ask on their discord. Not sure and they will give better answers.

[@softwebsystems5499]

Thanks@@underjord . Will do as you have adviced

[@VideoPir]

We need more open source shills. This was great.

[@underjord]

Thanks man :)

[@ThermalCubes]

Love the hoodie ;)

[@souravmohanty1579]

Bro Your explanation is very good but it will be better with some visuals and diagrams. It's sometime difficult to understand and process the words for a clear visual in mind. Visual explanations will be more informative and anyone can easily acquire that. Thank you👍

[@underjord]

Yup. I haven't pinned down a good workflow for that type of visual.

[@definty]

this is like CouchDB and PouchDB but Elixilised!!!!

[@tom9380]

"Electrify the audience"

[@XyndraNerd]

Please talk a bit louder

[@underjord]

I think my voice was on the mend from some plague at this point. But I'll consider it.

[@seanknowles9985]

Finally!

[@seanknowles9985]

Can we get a tutorial for a bare-bones setup with deployment on railway and connection to express and React app, that would help most people understand all the steps necessary to get up and running.

[@underjord]

I think you would have most luck by talking to the Electric SQL folks on their discord :)

[@zero3juan]

Thanks so much for the showcase. This is very exciting for all the reasons you mentioned in the end and I'm excited to explore its application in my own app, servicing construction management in areas with spotty connections. 👍

[@underjord]

Glad to hear it resonates!

[@bashiryousufy1]

Would this work on flutter with nodejs server?

[@underjord]

I expect so. I know there is work on a Dart client which would help the Flutter case. Don't know the status of it. I recommend asking on the Discord.