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