3 ms·
The 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
by shubhamjain 3y ago
The 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.