Live data from Hacker News

Lobste.rs is now running on SQLite

lobste.rs

121–130 of 209 posts

Re: Lobste.rs is now running on SQLite

#121
post #97

Earlier quoted context omitted.

Lobste.rs is very anti-AI. They force any LLM topic to be tagged with “vibecoding” even when the majority of LLM posts are not about vibecoding. AI posts are usually the most commented on. Linus Torvalds’ comments saying that LLMs are actually useful is still on the front page, tagged as vibecoding, and has a lot of comments from people mostly disagreeing with him. Lobste.rs is more of a monoculture than Hacker News.…

I originally went to lobste.rs because I wanted to avoid repetitive discussion and get more technical stuff. In time, though, lobste.rs got fairly boring since it's always the same stuff over and over again. I found an alternative means[0] of filtering out boring things here on HN and it's enjoyable to use again. 0: deleting comments of people who aren't interesting from my view and highlighting ones who often say th…

> In time, though, lobste.rs got fairly boring since it's always the same stuff over and over again.

There are some interesting comments there from some people who don’t spend time on other sites, but your assessment is similar to mine

My comment about being anti-AI above may not have been clear. They actually talk about AI a lot and AI threads attract a high amount of activity. The difference is that insightful or honest comments don’t have much of a chance because there’s a clear popular opinion on the site and any information that doesn’t fit isn’t welcome.

The giant soupy mess of opinions on HN can be tiresome, but it’s nice to get a wider range. HN is its own little bubble but at least there’s some diversity of experiences to be found.

Re: Lobste.rs is now running on SQLite

#123
post #3

Wait, 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.

I don't think SQLite is particularly optimized for modern hardware. It's just crazy efficient with a regression test suite many projects wish they could have.

Re: Lobste.rs is now running on SQLite

#124

Software “engineering”. Thank goodness bridges aren’t built with this level of rigor. In any case I will take an invite if one has one because the community is solid.

Give your email or send me a message (abetusk@mechaelephant.com) so I can send the invite.

Re: Lobste.rs is now running on SQLite

#125
post #62

Earlier quoted context omitted.

Invitation-only is the future of online communities. Lobsters still has a pulse because you need to know someone to get in and it’s a bad look if you invite annoying people.

> Invitation-only is the future of online communities. This feels antithetical/dystopian/elitist compared to what online communities are, for me. I think it's ok for some communities to be like this, but I don't think it's the future of online communities.

Isn't this how alot of discord works? maybe the communities are leniant with inviting but it still happens. A group chat is basically invite only too and that's pretty popular for communication.

Re: Lobste.rs is now running on SQLite

#126
post #10
post #2

Oh 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).

Hi. Could you send me an invite? Email in my profile :)

Re: Lobste.rs is now running on SQLite

#127
post #48

Earlier quoted context omitted.

I didn't realize that re-timestamped comments . That's a pretty unexpected behavior, if true. I wouldn't like if that happened to a comment I left - a lot can happen in a week.

Every time it happens there's a sub-thread asking about the weird timestamps and dang replies to it saying changing the timestamps is done so that there won't be a sub-thread about the weird timestamps.

I'm pretty sure this comment chain is in every popular 2nd chance pool post though anyway

Re: Lobste.rs is now running on SQLite

#128
post #44

Earlier quoted context omitted.

Lobste.rs is very anti-AI. They force any LLM topic to be tagged with “vibecoding” even when the majority of LLM posts are not about vibecoding. AI posts are usually the most commented on. Linus Torvalds’ comments saying that LLMs are actually useful is still on the front page, tagged as vibecoding, and has a lot of comments from people mostly disagreeing with him. Lobste.rs is more of a monoculture than Hacker News.…

It's a lot smaller of a community than HN, so it will naturally have a smaller range of opinions merely due to the fact that it has a lot fewer users. That said, I don't believe it's as much of a hivemind as you've portrayed. I've seen dissenting opinions voiced there which weren't downvoted (or at least not noticeably), while the same opinion in a similar thread here on HN would be downvoted and flagged. So I don't…

Hi. Could you send me an invite? Email in my profile :)

Re: Lobste.rs is now running on SQLite

#130
They use WAL in SQLite. If I continuously perform reads/writes so that they overlap with no gaps, I can make their VM go down because SQLite will not have time to initiate a checkpoint to trim the WAL file. SQLite waits for a time window without any active reads/writes before starting a WAL checkpoint. If there isn't one, the WAL will grow indefinitely, eating up all the disk space on the VM.

It's in SQLite's documentation, and almost no one switching to Sqlite seems to be aware of it because no one discusses it in blog posts like these. I guess most projects switching to SQLite have very low traffic and no malicious users (yet)

Post reply on HN