-
I do streaming updates with Litestream: https://litestream.io/
I recently set it up after putting it off for a while and it took like 5 minutes. It was great. And the backups are currently costing me 0 cents per month on backblaze.
-
InfluxDB
Purpose built for real-time analytics at any scale. InfluxDB Platform is powered by columnar analytics, optimized for cost-efficient storage, and built with open data standards.
-
ExtPay
The JavaScript library for ExtensionPay.com — payments for your browser extensions, no server needed.
Whenever SQLite comes up, always have to link to this post about using SQLite in production: https://blog.wesleyac.com/posts/consider-sqlite :)
I'm running https://extensionpay.com off SQLite and a $5/month DigitalOcean box and it's serving around 3 million requests a month with absolutely no issues and seriously low CPU load. I'm kind of astonished, frankly.
-
Thanks for the detailed explanation, makes complete sense.
I suppose that means that for projects such as python-wasm [0] that are porting other language runtimes to WASM they will have to go the Asyncify route with all the overhead that entails?
From the looks of it they don't think asyncifying Python will be possible in the near to medium term [1].
0: https://github.com/ethanhs/python-wasm
1: https://github.com/ethanhs/python-wasm/issues/12
-
https://github.com/rqlite/rqlite provides a form of horizontal scaling for reads, but it's not a drop in replacement for SQLite.
https://github.com/rqlite/rqlite/blob/master/DOC/READ_ONLY_N...
(I'm the author of rqlite)
-
My application Datasette can serve this need: https://datasette.io/
Lots of live demos - two of my favourites are https://github-to-sqlite.dogsheep.net/ and https://global-power-plants.datasettes.com/
-
My application Datasette can serve this need: https://datasette.io/
Lots of live demos - two of my favourites are https://github-to-sqlite.dogsheep.net/ and https://global-power-plants.datasettes.com/
-
I actually think this is onto something that I'm finding in a different way. Instead of a massive database, what if we had a key-value store mapping keys to tiny databases.
This is, to some degree, what I'm building over at http://www.adama-lang.org/ without a full SQL engine. Each document has tables, and the tables can be indexed. I have yet to find a usecase (in my domain) which requires joins. HOWEVER, I've had a ton of fun building it and I'm getting ready to start making games.
I do believe it would be amazing to have a key-logger service where a reducer like sqlite/adama could come into collapse the log into a single file.
The closest I see is from the Boki paper ( https://www.cs.utexas.edu/~zjia/boki-sosp21.pdf ) which was presented at SOSP21.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives