4 ms·
I’d love to see a good open-source sync solution between SQLite and PostgreSQL to get the best of both worlds, like what the Watcom/Sybase/SAP SQLanywhere offer
by fmajid 5y ago
I’d love to see a good open-source sync solution between SQLite and PostgreSQL to get the best of both worlds, like what the Watcom/Sybase/SAP SQLanywhere offered.
- dannyibunny 5y agoTotally agree, compatibility is really the key for any database product or any product. Minimizing the migration gap helps adoption.
- simonw 5y agoI have a tool that can do that in one direction - db-to-sqlite (built on top of SQLAlchemy) can create a SQLite database with a direct copy of the schema and data from a MySQL or PostgreSQL database. I've contemplated building it to work on the other direction too but I haven't needed it myself yet so I've not done the work. https://datasette.io/tools/db-to-sqlite https://datasette.io/tools/db-to-sqlite
- EnigmaCurry 5y agoawesome! https://pgloader.io/ https://pgloader.io/ can do it in the other direction.
- thunderbong 5y agoThere's a Ruby ORM called Sequel [0] (Github [1]) which provides a cli [2] to do just that across different databases. Example from the docs - sequel -C mysql://host1/database postgres://host2/database2 or for Postgres > SQLite sequel -C postgres://host2/database2 sqlite://database.sqlite and vice-versa sequel -C sqlite://database.sqlite postgres://host2/database2 [0]: https://sequel.jeremyevans.net https://sequel.jeremyevans.net [1]: https://github.com/jeremyevans/sequel https://github.com/jeremyevans/sequel [2]: https://sequel.jeremyevans.net/rdoc/files/doc/bin_sequel_rdoc.html#label-Copy+Databases https://sequel.jeremyevans.net/rdoc/files/doc/bin_sequel_rdo...