What are the options for "serverless" PostgreSQL like these days? My definition of serverless here is that you don't have to spend any money at all if you're not getting any DB traffic, and cost then scales up as the traffic and storage you are using increases
Aurora PostgreSQL is the most obvious option, though it's not clear to me if you have to keep at least one instance running for it or if it fully "scales to zero" for projects that aren't receiving any traffic at all
Consensus in replies seems to be that this doesn't actually exist yet - scale-to-zero for a relational database server like PostgreSQL is evidently a whole lot harder than scale-to-zero for a stateless web application server as seen with things like Google Cloud Run
I'm also interested in PostgreSQL that starts cheap and magically scales - if I can spend $5/month on a database for a tiny project and spend more money if I need it to handle more data and traffic (without any interruption in service) that would be cool too
supabase.io/pricing isn't exactly scale-to-zero but they do offer a free 500MB PostgreSQL which is "Paused after 1 week inactivity" - not clear what unpausing looks like, and the next tier up from free is $25/month so not the pay-for-what-you-use I'm looking for
Most promising option looks to be Aurora Serverless v2, currently in preview - appears to scale to zero when not in use, but pricing hasn't been announced yet plus the preview at the moment is for MySQL compatible, the PostgreSQL compatible one will presumably come later
• • •
Missing some Tweet in this thread? You can try to
force a refresh
"Hosting SQLite databases on Github Pages" is absolutely brilliant: it adds a virtual filesystem to SQLite-compiled-to-WebAssembly in order to fetch pages from the database using HTTP range requests phiresky.github.io/blog/2021/host…
Check out this demo: I run the SQL query "select country_code, long_name from wdi_country order by rowid desc limit 100" and it fetches just 54.2KB of new data (across 49 small HTTP requests) to return 100 results - from a statically hosted database file that's 668.8MB!
Looks like the core magic here is only around 300 lines of (devastatingly clever) code github.com/phiresky/sql.j…
The feature I most want from Twitter is "view this user's tweets without showing their retweets"
Note that this isn't the same thing as turning off someone's retweets - I want to go to the profile of someone I don't even follow and see what they actually say, not just a stream of stuff they have retweeted
These days I'm so keen on having every commit link to an underlying issue thread that I'll sometimes write some code, then file an issue and close it with a commit a few seconds later
The real value here is having somewhere to continue the discussion around a change. I'll frequently add screenshots and links-to-documentation to an already closed issue. Also great to link to from release notes.
It almost becomes an out-of-band documentation and commentary thread - somewhere you can really dig into the reason for a change without fear of clogging up the code with comments that will inevitably become out-of-date in the future
github.com/bertrandmartel… by Bertrand Martel does all of the actual work, I just added a paper-thin wrapper around it that writes the resulting Pandas DataFrames out to a SQLite database