pysqlite3
seamless
pysqlite3 | seamless | |
---|---|---|
3 | 1 | |
162 | 106 | |
- | - | |
5.4 | 2.3 | |
about 1 month ago | 9 months ago | |
C | Go | |
zlib License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
pysqlite3
-
Datasette Lite: a server-side Python web application running in a browser
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.
-
SQLite 3.38 Released
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 Built Litestream
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
seamless
-
I Built Litestream
You can do zero-downtime deploys on a single node with tools like seamless[1]. That works for Go but I'm sure there are other options for other languages. I'm not sure if/how you can do it with a containerized workload on a single node though. I haven't tried that.
[1] https://github.com/rs/seamless
What are some alternatives?
datasette-lite - Datasette running in your browser using WebAssembly and Pyodide
raze - Modular, light web framework for Crystal
litestream - Streaming replication for SQLite.
Hugo - The world’s fastest framework for building websites.
Bedrock - Rock solid distributed database specializing in active/active automatic failover and WAN replication
pyodide - Pyodide is a Python distribution for the browser and Node.js based on WebAssembly
go-sqlite3 - sqlite3 driver for go using database/sql
datastation - App to easily query, script, and visualize data from every database, file, and API.