dbhub.io icon indicating copy to clipboard operation
dbhub.io copied to clipboard

Published 20 hours ago • verified publisher icon sqlitebrowser

Import of CSV files for DB upload

Open justinclift opened this issue 7 years ago • 2 comments

@danfowler had an interesting idea. When a person uploads a database file, the server side should also accept and import CSV files.

This probably wouldn't be hard to do (eg detect CSV format, convert to SQLite, import that). We may be able to extend it to other files types as well.

justinclift avatar Apr 19 '17 05:04 justinclift

Note to self, when doing the import it would be useful to detect the date type of columns. Something like this would be useful as a first implementation approach:

    https://github.com/sqlitebrowser/sqlitebrowser/issues/1003#issuecomment-298949792

justinclift avatar May 21 '17 00:05 justinclift

The Go SQLite library we use has a LoadCSV() function, specifically for importing CSV files.

It's fairly basic, but would probably be a reasonable starting point.

justinclift avatar Apr 27 '23 09:04 justinclift