dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Init directly from a sqlite db

Open NightMachinery opened this issue 4 years ago • 4 comments

I know sqlite can be converted to csv, then imported, but having it be a direct import is easier.

NightMachinery avatar Mar 07 '21 07:03 NightMachinery

Making import from existing databases is something that we want to do, it's just not something we are working on at this current moment.

oscarbatori avatar Mar 07 '21 16:03 oscarbatori

Agree this is a great feature. In the meantime. Something like this should work if you have a running dolt sql-server.

https://pypi.org/project/sqlite3-to-mysql/

And something like this will convert your dump so you can pipe it into dolt sql like so dolt sql <:

https://github.com/tengla/sqlite3-to-mysql

timsehn avatar Mar 13 '21 17:03 timsehn

You can use something like https://github.com/cube2222/octosql.

Dialga avatar Jul 07 '23 15:07 Dialga

I'm interested in working on this issue. My initial intuition is that, all other things being equal, using a pure Go SQLite file parsing library would probably be the simplest approach. If so, how about https://github.com/alicebob/sqlittle? Or would anyone recommend a different Go library, or a different approach altogether?

senderista avatar Dec 23 '23 02:12 senderista