Lobste.rs is now running on SQLite
lobste.rs
Lobste.rs is now running on SQLite
1–10 of 209 posts
Re: Lobste.rs is now running on SQLite
#2Oh wow. Off-topic but quite refreshing to see a site not absolutely plastered in AI posts
Re: Lobste.rs is now running on SQLite
#3Wait, no edge cache, just one node with SQLite db?
Re: Lobste.rs is now running on SQLite
#4Wait, no edge cache, just one node with SQLite db?
Caddy does cache a portion of the traffic, and what it can't cache makes its way to rails.
Re: Lobste.rs is now running on SQLite
#5Wait, no edge cache, just one node with SQLite db?
For a relatively low-traffic site like Lobster's, yeah I'm not surprised they don't need anything crazy. SQLite is really efficient and modern hardware is really fast.
Re: Lobste.rs is now running on SQLite
#6It's been fairly unstable recently, pages sometimes render for several seconds which I've never seen under MariaDB. Used to be instantaneous, always.
Sometimes (maybe 5% or less) the request won't render at all, and you get a browser error page.
Today they ran into this bug, lost a bunch of voting data, and went into read-only mode for several hours:
https://github.com/rails/rails/pull/57128
I wonder how much of this is usual bugs which crop up during major database migrations, and how much is caused by choice of SQLite.
Re: Lobste.rs is now running on SQLite
#7[flagged]
Re: Lobste.rs is now running on SQLite
#8Oh wow. Off-topic but quite refreshing to see a site not absolutely plastered in AI posts
HN is increasingly bot central, I kind of assume 80% of the respondents are artificial.
Lobsters still got a pulse, largely.
Re: Lobste.rs is now running on SQLite
#9No intention to antagonize but... why not postgre? Even my side projects run on postgresql with no overhead at all
Re: Lobste.rs is now running on SQLite
#10Oh wow. Off-topic but quite refreshing to see a site not absolutely plastered in AI posts
It's a wonderful place. It feels like HN, but with the Silicon Valley attitude dialed way way way down, and with a much narrower scope (politics, economics and entrepreneurship are all off-topic, for example).