Lobste.rs is now running on SQLite

(lobste.rs)

81 points | by abetusk 3 days ago

11 comments

  • evanelias 36 minutes ago
    Some of the cited reasons for moving off MariaDB [1] seem misguided, in my opinion. Especially the part about "K1 are very enterprise-focused, so the database is likely to focus its work on features that are not relevant to us. There's increased risk they drop the free/open source version we use"

    K1 acquired the commercial entity behind MariaDB Enterprise, but that's separate from the non-profit MariaDB Foundation. And there's literally zero risk of the MariaDB server suddenly going closed-source; as a fork of MySQL (which is GPL), this is not even legally possible!

    [1] https://github.com/lobsters/lobsters/issues/539#issuecomment...

    • edoceo 29 minutes ago
      And even if it did go closed-souce, your existing install can run for ages because the vendor cannot force upgrade. One of my favorite features of FOSS.
  • homebrewer 46 minutes ago
    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 is usual bugs which crop up during major database migrations, and how much is caused by choice of SQLite.

    • srcreigh 24 minutes ago
      Pages (especially threads while logged in) taking seconds to load definitely happened to me pre SQLite migration.
  • tetris11 3 days ago
    Oh wow. Off-topic but quite refreshing to see a site not absolutely plastered in AI posts
    • grebc 44 minutes ago
      HN is increasingly bot central, I kind of assume 80% of the respondents are artificial.

      Lobsters still got a pulse, largely.

      • rickcarlino 3 minutes ago
        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.
    • gspr 43 minutes ago
      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).
      • dgellow 20 minutes ago
        Anyone willing to send me an invite?
      • christophilus 36 minutes ago
        Huh. I’ve largely avoided it, but that does sound pretty nice.
    • Aurornis 27 minutes ago
      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. If you get downvoted enough they stick a banner on the top of the page inviting you to delete your account. It has a nasty side effect of driving away good contributors who don’t align perfectly with the hive mind. It’s a site where you learn to keep your mouth shut if your input doesn’t agree with what the core users want to hear.

      • xtracto 1 minute ago
        I dont remember why I was kind of barred from lobsters , but I applaud all this behavior you mentioned. In the end, that's how normal clickes of friends/interest groups form (or formed 30 years ago in real life.)

        If you got into my group of death metal people, and suddenly started talking about Oasis... we would invite you to get out haha.

        Same with patriots.win . They may be a group of right wing biggots, but hey, they did their platform and are happy talking there.

      • dgellow 24 minutes ago
        I honestly don’t find any of this concerning
  • kenforthewin 28 minutes ago
    The site is performing poorly for me. For example, the login page took 9 seconds to load, same with the home page.
  • etbusch 11 minutes ago
    Would also love an invite if anyone has one.

    Apologies for the OT post!

  • cromka 3 days ago
    Wait, no edge cache, just one node with SQLite db?
    • packetlost 53 minutes ago
      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.
    • thomasdziedzic 2 days ago
      Caddy does cache a portion of the traffic, and what it can't cache makes its way to rails.
  • cromka 40 minutes ago
    Ironically, this post resurfaced on HN with my comment here shown as if made 15 minutes ago, which I in reality did last week?
    • stymaar 29 minutes ago
      Second chance pool, most likely.
  • cenazoic 15 minutes ago
    May I have an invite, if anyone has one to spare?
  • pstuart 36 minutes ago
    That doesn't seem unreasonable at all.

    Have a live, writable DB for updates, but serve a read only copy of the db.

    Anybody got an invite for it I could use? You can evaluate my history here to see if I'm worthy.

    • xgbi 26 minutes ago
      I do. Send me an email in my profile I'll send you the invite.
  • ethagnawl 44 minutes ago
    Off topic but, since we're here, could someone with a lobste.rs account invite me to join?

    UPDATE: Wish granted. Thanks, veqq!

    • veqq 33 minutes ago
      Invite sent
    • sgt 39 minutes ago
      What's lobster.rs, some kind of Temu HN? Or is it the real deal?
      • xgbi 24 minutes ago
        Way more technical, way smaller. HN is a lot more wide in terms of audience and subjects, Lobsters is mainly programming.

        I love it.

        • sgt 10 minutes ago
          I'll give it a shot.
      • written-beyond 36 minutes ago
        It's superior and invite only.
  • Kuyawa 43 minutes ago
    No intention to antagonize but... why not postgre? Even my side projects run on postgresql with no overhead at all
    • dewey 31 minutes ago
      It's also explained in the post shared:

      ---

      I've heard "why not PostgreSQL?" a few times this week. It was even our original plan in #539! Well, it was a pragmatic choice in two different ways:

      The person who volunteered to do the work used SQLite.

      I don't want to use solutions that are bigger and more complex than our likely needs. Postgresql is my default for projects, but it does have the added complexity of being a separate service to run, tune, and maintain.

    • gnulinux 31 minutes ago
      > run on postgresql with no overhead at all

      Citation needed. I love postgres as much as the next person, but it does have more overhead than Sqlite which is in an in-process db linked through compiled C code, it doesn't run as a separate server. Very significant difference that when you use Sqlite db, there is typically no db process other than your application logic, unless you implement the server yourself. If you don't want your application to have multiple processes (say, as a toy example) then it totally makes sense to prefer Sqlite just for this reason. Sqlite and postgres are different tools, they serve different purposes.

    • adenta 41 minutes ago
      Where are you hosting postgres
      • dewey 33 minutes ago
        On the same machine where they are currently storing the sqlite file maybe? It's not that hard to run. A sqlite backup cron is also not that much more work than a pg_dump cron.