4 ms·
I tried this with sqlite and the apsw python library. A quick example is at https://github.com/johnteslade/pysqliteosquery https://github.com/johnteslade/pysql
by johnteslade 12y ago
I tried this with sqlite and the apsw python library. A quick example is at https://github.com/johnteslade/pysqliteosquery https://github.com/johnteslade/pysqliteosquery
The interface is not quite as nice as Multicorn's but certainly nicer than the C/C++ SQLlite interface. But you could probably create a wrapper around apsw so it looked similar to Multicorn.
- Erwin 12y agoFYI, you can use ":memory:" as the sqlite data source, instead of having to conditionally drop the tables (unless you actually do want to store some persistent data on disk).
- johnteslade 12y agoGood spot. The in memory table also runs 3 times quicker.