I work with a lot of CSV files, and for some reason I rarely load them into Postgres or use Python script. I still try very hard to use Excel.
There is some degree of convenience that GUI offers over command-line, though some people still prefer command line.
I'm already using and enjoying this tool alot . I use to do this in DBeaver ( also a great tool ) , but I have to manually specify the types in a JDBC string to get all the goodies of SQL this so far has been much nicer.
I have already made this a daily tool thanks!
Yes! we use Sqlite under the hood with modified C extensions, so it can be as fast as it can be. (Just try not to touch JS code for this)
However, I have recently learned that SIMD is even faster than C, but I haven't explored it yet.