leonim

8 ms·

1. 61.▲
   by leonim 6y ago

   My favorite terminal based client to explore SQLite databases and many other data formats is the TUI VisiData[1]. It has a spreadsheet-like interface and makes it very easy to explore a SQLite database in the terminal [1] https:/&#x2F
2. 62.▲
   by leonim 6y ago

   I'm not familiar with the library, but looking at the documentation, it looks like it provides a programmatic way to get information about the schema of a table just from the create statement, which seems useful if you want to do somet
3. 63.▲
   by leonim 6y ago

   If the terminal is your home, I would suggest looking at something already mentioned by someone else VisiData ( http://visidata.org ), it is great for exploring all sorts of data files like CSV, Excel, Sqlite3, etc in the termina
4. 64.▲
   by leonim 6y ago

   Yes, vd does a nice job on JSON data. To open nested data you can use the expand-col (keyboard shortcut "(") command, and the unfurl-col "zM" command. You can also use the pyobj-cell "z^Y" command to explore si
5. 65.▲
   by leonim 6y ago

   Totally agree. I think mlr is a wonderful CLI tool. It is very robust, and can handle/convert multiple tabular formats including csv, tsv, json, fixed-format, etc. It has a pretty decent text output formatting, with the --opprint fla
6. 66.▲
   by leonim 6y ago

   I recommend Jeremy Singer-Vine's tutorial for getting started: https://jsvine.github.io/intro-to-visidata/index.html The tutorial gives you a good taste of what it can do and how to use it.