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/lawik/electric-sam...
github.com/lawik/electric-sid...
I've had a lot of fun with it as evidenced by the four livestreams:
czcams.com/users/liveuGNgAiLj0SM
czcams.com/users/livey71uOUPXioA (the best one, globally distributed SQLite on Fly.io)
czcams.com/users/liveLOR_ReuAfWU
czcams.com/users/live-mCYURMoHro
You can read more Electric SQL below:
Electric SQL site: electric-sql.com/
Demos: electric-sql.com/demos/
Docs: electric-sql.com/docs/overvie...
Discord community: / discord
Source code on GitHub: github.com/electric-sql

[@pkop4]

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

[@underjord]

More on that.. soon?

[@dadisuperman3472]

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

[@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!

[@seanknowles9985]

Finally!

[@timothyshiu2263]

electric-sql is awesome! what is the performance for e-commerce large volume of web app and native app write/read?

[@underjord]

The performance will be local SQLite as far as the user is concerned.

[@VanderleiRobertoMoretto]

Very good

[@ThermalCubes]

Love the hoodie ;)

[@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

[@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 :)

[@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.

[@VideoPir]

We need more open source shills. This was great.

[@underjord]

Thanks man :)

[@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.