3 ms·
You can just import your CSV file to SQLite without any limits, e.g.: sqlite3 :memory: -cmd '.import -csv file.csv table'\ 'SELECT col, COUNT(*), AVG(t
by niutech 3y ago
You can just import your CSV file to SQLite without any limits, e.g.:
sqlite3 :memory: -cmd '.import -csv file.csv table'\
'SELECT col, COUNT(*), AVG(total) FROM table GROUP BY col'
More: https://www.sqlitetutorial.net/sqlite-import-csv/ https://www.sqlitetutorial.net/sqlite-import-csv/
- tarasyarema 3y agoIt is indeed an option, I guess the problem with this is that its static and and you need to re-create the tables each time. For someone more techie probably could work, as you could dump the data to sqlite and then query it. But if you want to have it dynamically and from sheets in real-time probably it would be harder to handle this way.
- shubhamjain 3y agoThe problem is you need to create a table with the correct data types first, which can be time-consuming. Additionally, using CLI can be a bit cumbersome to use, especially if it involves quering multiple tables, or using joins. I don't want to point to the infamous "dropbox" comment [1], but it's important to understand that many folks just want a friendly interface where they can put in a URL/file, and start querying. This is the exact reason I built TextQuery [2], which solves a similar problem as OP's. I just wanted a simple app where I could drop a CSV and start SQL querying it, without creating schemas or writing code/commands. [1]: https://news.ycombinator.com/item?id=8863 https://news.ycombinator.com/item?id=8863 [2]: https://textquery.app/ https://textquery.app/
- niutech 3y agoIn the link I posted there is a GUI way of importing CSV files by using the open source SQLiteStudio: https://sqlitestudio.pl https://sqlitestudio.pl. Your TextQuery also looks nice, although it's a pity it isn't open source.
- deleted 3y ago[deleted]