dio icon indicating copy to clipboard operation
dio copied to clipboard

Idea: Retrieve individual tables from a database

Open justinclift opened this issue 6 years ago • 0 comments

Today's updates for dio added support for modern DBHub.io, rather than the initial concept version.

The current pull command retrieves a database. eg:

$ dio pull 2.5mbv3.sqlite
Database '2.5mbv3.sqlite' downloaded.  Size: 2,666,496 bytes

It could be useful to have it allow for retrieving of individual tables too. Not sure what format though (CSV? JSON? single table SQLite file?). Having CSV as the default due to it's widespread use, but allowing others --format json might be the way to go.

$ dio pull 2.5mbv3.sqlite uniques
Database: '2.5mbv3.sqlite', table 'uniques' downloaded as '2.5mbv3-uniques.csv'.
Size: 100,000 bytes

justinclift avatar Feb 17 '19 07:02 justinclift