Live data from Hacker News

Lobste.rs is now running on SQLite

lobste.rs

101–110 of 209 posts

Re: Lobste.rs is now running on SQLite

#101
post #11
post #9

No intention to antagonize but... why not postgre? Even my side projects run on postgresql with no overhead at all

Where are you hosting postgres

if they have only one server, then on that server. If they have a load-balanced front end and central database, then on the database.

Re: Lobste.rs is now running on SQLite

#103

It'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…

Not sure if this is SQLite or driver/Rails issues? We use it for sites and systems with a lot more (but similar) traffic and have no issues; we did write the drivers we use ourselves (for Node) as we got into much issues with the popular/existing ones.

Re: Lobste.rs is now running on SQLite

#104
Pretty cool. I do default to SQLite these days simply because I can just put it on the host, set up a PVC to it, and run the app in Kube pointing at a persistent SQLite. Absent some other need (it's a fork of psql- or mysql-based software) I prefer using it for simplicity.

I do have to say that I've found lobste.rs generally a pretty slow site to render and navigate and I wonder whether that's the Rails backend, or underpowered hardware, or lack of caching. It's more feature-ful than a HN or Reddit though with much lower usage so I wonder what it is.

Re: Lobste.rs is now running on SQLite

#105
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.

I think we need to remove dystopian and elitist from the dictionary because at this point you can't breathe without being accused of it.

Deciding who is in or out is the fundamental basis of any community, that's freedom of association. That's what defines a community. A place anyone can enter is a train station bathroom and that's what the logical terminus of the open internet seems to be.

Re: Lobste.rs is now running on SQLite

#107

It'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…

I jsut had this happen - it was my first visit to the site and probably my second page load. Tried opening the About page and it was completely blank. Thought it was odd & reloaded, which rendered correctly.

Re: Lobste.rs is now running on SQLite

#108
post #10

Earlier quoted context omitted.

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

The SV attitude isn't there but there's active assholes who wield their moderation weirdly. I deactivated my account before deactivations were added to the logs and I don't remember what made me quit. I've largely avoided Lobsters since. I joined their IRC channel last week and it's been rather chill. I do like the invite-only nature of the site though, keeps quality high...while making some folks tyrannical.

Every such "club" inevitably attracts a specific sort that badly want to join just for the sense of exclusivity and a chance to virtue-signal their member status. It's same thing with some hard-to-get-into torrent trackers — once in, people become poster-children for Stockholm syndrome and the mods really get off on their perceived power. It's also the same with expensive new sport car models that manufacturers sell to collectors.

My intuition says it's to do with Status Signaling theory .

Re: Lobste.rs is now running on SQLite

#109
post #62

Earlier quoted context omitted.

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

I think we need to remove dystopian and elitist from the dictionary because at this point you can't breathe without being accused of it. Deciding who is in or out is the fundamental basis of any community, that's freedom of association. That's what defines a community. A place anyone can enter is a train station bathroom and that's what the logical terminus of the open internet seems to be.

I think scopes/criteria/boundaries on communities are fine, I disagree that invite-only (as one implementation of community boundaries) is the future of online communities.

Although the statement "invite-only only is the future of online communities" isn't super well defined (what does it mean to "be the future"?), so I think the comments are debating past each other.

Re: Lobste.rs is now running on SQLite

#110

Earlier quoted context omitted.

I wish lobste.rs would be a tiny bit easier to get access to. Some of my blog posts have been discussed there and every time I try to get access, I can’t get past their IRC stuff. As in: I just don’t understand how IRC works…

You should overlay a banner on your blog when they send you an HTTP Referer explaining their nonsense. Maybe then they'll get the message. Then again, maybe they like the ability to critique your posts without you being able to rebut their opinions. It's an effective tactic in online echo chambers.

From their about page: "If you wrote a link that was posted, please reach out in chat, we'd love to have you join the community."
Post reply on HN