Why isn’t there a decent file format for tabular data?

Re:Why isn’t there a decent file format for tabular data? by euroderf on Wednesday May 04, 2022 @10:46AM (#31261202)

All I'd want is a CLI tool that can dump an SQLite file so that it actually looks like a table (using "|", "-", "+", etc.), and maybe also accept grep-style filter specs (per specified column[s] of course).

[ Parent | on HN ]

Re:Why isn’t there a decent file format for tabular data? by tschan on Wednesday May 04, 2022 @11:51AM (#31262156)

This sounds like an interesting weekend project. Are you saying you can't find anything for this?

[ Parent | on HN ]

Re:Why isn’t there a decent file format for tabular data? by euroderf on Wednesday May 04, 2022 @12:40PM (#31262811)

There is catsql[1] but it barfs in my Python environment.

[1]https://github.com/paulfitz/catsql

[ Parent | on HN ]

Re:Why isn’t there a decent file format for tabular data? by aldonius on Thursday May 05, 2022 @05:46PM (#31278735)

you can get a long way with something like

$ echo "<sqlite3 commands / sql queries>" | sqlite3 FILE

[ Parent | on HN ]