Show HN: Simplql - Query csv, xls and json files with SQL

Re:Show HN: Simplql - Query csv, xls and json files with SQL by chanar on Friday January 15, 2021 @09:36AM (#25791388)

Thanks! Still, no simple solution to do it quickly. Using additional tools needs some sort of technical knowledge.

[ Parent | on HN ]

Re:Show HN: Simplql - Query csv, xls and json files with SQL by majkinetor on Friday January 15, 2021 @09:40AM (#25791448)

Sort of.

On Windows:

    choco install tad dbeaver postgresql

Tad and dbeaver usable ASAP. PostgreSql requires creating empty database and single table once, with json type column, then insert json each time.

On the more positive side, you have infinitely more capable features in those tools and standard SQL

However, for quick and dirty and ad hoc place, web tool looks like a way to go.

[ Parent | on HN ]

Re:Show HN: Simplql - Query csv, xls and json files with SQL by seektable on Saturday January 16, 2021 @04:33AM (#25801188)

For CSV/TSV files SeekTable can do various reporting (including pivots) really quickly, naturally just in a few clicks.

[ Parent | on HN ]