trdsql VS gsheet

Apparently, there were many who thought the same thing; Tools to execute SQL against CSV were trdsql, q, csvq, TextQL. They were highly functional, hoewver, had many options and no input completion. I found it just a little difficult to use.

Nice! Kinds of reminds me of trdsql

trdsql(https://github.com/noborus/trdsql) is a tool that executes SQL for files such as CSV, but it can also be used by connecting to MySQL. Therefore, SQL such as CREATE TABLE table AS SELECT * FROM csvfile.csv can also be executed.

trdsql can execute SQL against CSV, LTSV, JSON and TBLN, and the database can also use SQLite,PostgreSQL and MySQL.

trdsql can execute SQL against CSV, LTSV, JSON and TBLN, and the database can also use SQLite,PostgreSQL and MySQL.

Check out https://github.com/noborus/trdsql

The trdsql I made is feature-rich and fast (as a similar SQL tool).

I wrote a little cli[1] that is a bit easier than curl for getting data to and from google sheets as csv. I do think this sqlite extension would be even more convenient if it supported writing data with INSERT/UPDATE.

1: https://github.com/cristoper/gsheet

I maintain several Go programs that mostly just copy data from google sheets, process it, then upload it back to a google sheet. My current approach is to parse the sheets as CSV, then serialize it back as CSV (I'm the author of cristoper/gsheet), but the idea of parsing it directly to Go structs is interesting.