Hi! I'm the OP here. The performance gain is mainly from reading/writing files in C and/or by Sqlite (which is also C). Any other tool that use dynamic langua

Hi! I'm the OP here. The performance gain is mainly from reading/writing files in C and/or by Sqlite (which is also C). Any other tool that use dynamic languages like python will immediately takes minutes to handle any GB-sized file (initializing string is already slow). The main difference is essentially GUI vs command-line. Datasette is the closest but it seems to require command line (based on the usage page). I haven't tried it out yet, so I may be wrong here. OctoSQL looks very interesting. Initially, I was trying to use DuckDB but couldn't make it work on Windows. Sqlite's SQL dialect is somewhat lacking (hello WITH RECURSIVE). It is one of the gaps I would like to solve.