3 ms·
Nice, I have a bunch of suggestions for you. Basically I recommend you to look at xmlstarlet sel (and find) as an example of converting complex languages into
by guard-of-terra 13y ago
Nice, I have a bunch of suggestions for you.
Basically I recommend you to look at xmlstarlet sel (and find) as an example of converting complex languages into command line.
Did you think of loading every sqlite file on boot (-load?)
How about textql -header -source data.csv -uniq id -tstmp created,updated -index created 'SELECT ...'? - i.e. changes to table structure from command line switches?
Conventions also won't hurt. I.e. my-data.csv turns to my_data table that is saved to my-data.sqlite3 without me mentioning so. -save should do that.
The idea is to create a re-entrant workspace in the current directory which becomes richer with every invocation.
Also, does CREATE TABLE ... SELECT ... FROM tbl work? Plus -save.
- dinedal 13y ago> Also, does CREATE TABLE ... SELECT ... FROM tbl work? Plus -save. Yes. You can even modify and append to existing sqlite datebases. I'd love for this to become, eventually, a general purpose tool for working on data from the CLI. I will look into xmlstarlet sel and find for sure. I like the -load tag idea too. There's lots of possibilities here.