pysqlite3

I have an open issue for that here: https://github.com/simonw/datasette-lite/issues/28 My initial hunch is that this will be really difficult - probably require a fork of something like https://github.com/coleifer/pysqlite3 then compiled for WebAssembly. I'm confident it's feasible, but I don't have the skills to figure it out myself.

In the meantime you can use this to get a more modern SQLite in Python without having to replace SQLite yourself: https://github.com/coleifer/pysqlite3 On Linux you can use "pip install pysqlite3-binary" to get a compiled built version of it.

I've been using pysqlite3 which is a drop-in replacement compiled against a more recent version. pysqlite3-binary even gives you a (Linux-only) pre-compiled wheel. https://github.com/coleifer/pysqlite3

Regarding SQLite's performance, some things I've found very useful: Use WAL mode (writers don't block readers): PRAGMA journal_mode = 'WAL' Use memory as temporary storage: PRAGMA temp_store = 2 Faster synchronization that still keeps the data safe: PRAGMA synchronous = 1 Increase cache size (in this case to 64MB), the default is 2MB PRAGMA cache_size = -64000 Lastly, use a modern version of SQLite. Many default installations come with versions from a few years ago. In Python for example, you can use pysqlite3[0] to get the latest SQLite without worrying about compiling it (and it also comes with excellent compilation defaults). [0] https://github.com/coleifer/pysqlite3

For Python folks interested in using these features, you might be interested in this post [0] which describes how to compile the latest SQLite and the python sqlite3 driver. I've got a fork of the standard lib sqlite3 driver that includes support for user-defined window functions in Python as well which may interest you. [0] http://charlesleifer.com/blog/compiling-sqlite-for-use-with-... [1] https://github.com/coleifer/pysqlite3

You can use https://github.com/coleifer/pysqlite3 It even supports user-defined window functions using the new sqlite apis.