Community
Chat Logs
Thursday, October 15, 2026 (America/New_York)
- cheeser~wb
- javabotThank you, cheeser.
- dreamrealooo any changes?
- dreamrealI'm fixing search in nevet now :D
- dreamrealdamn stemming was unexpected
- dreamreal(I was passing through sanitized queries to postgres, and it stemmed when it should have but when I wasn't expecting it)
- cheesernah. just VPS maintenance requiring a reboot.
- cheeseri have a shit ton of changes on a branch that I need to merge. it's mostly UI/quarkus related but various lib upgrades here and there.
- dreamreal*nod* Are you still on the same VPS provider?
- cheeseronce i'm done with this morphia work, i'm going to go over the bot with claude and get some drastic clean up done. too many experiments, some unfinished, still lingering.
- cheeseryeah. same one.
- dreamreal*nod* I moved to a new provider and I'm on a dedicated server - the VPS we were using (I was on the same service javabot's on) overallocates like MAD, although that might depend on region
- dreamreallike, I was seeing 27 minute build times drop to 28s on the dedicated server: I expected SOME of that but not that much
- dreamreala 60x loss of performance is ... pretty severe, IMO
- dreamrealIt also cleared up a shedload of *mysql* errors - like, mysql was struggling on the server even though it had *resource* headroom, thanks to overallocation.
- dreamrealVery inexpensive service and worth every penny. :/
- cheeserwell, it *is* mysql...
- dreamrealWell, mysql should be able to handle five wordpress instances on relatively low-traffic sites.
- dreamrealThe overallocation was just too much, and I couldn't use it to build at all, even runtime... like, the early versions of nevet took five or six minutes to start
- dreamrealThat probably helped prevent litharge from wantiung to ban it due to join spam, but...
- dreamrealsorry, nevet was getting some inferred property updates
- ChronosThe lobste.rs website recently moved to SQLite and was able to cut their VPS requirements in more than half.
- dreamrealWhat the heck were they using before
- dreamrealand for WHAT
- ChronosI think it was either MariaDB or PostgreSQL, but I forget the details.
- dreamrealAnd they ... what
- dreamrealthat's crazy. What are they running the site on? That sounds like really bad design or really bad provisioning
- Chronoshttps://lobste.rs/s/oz7ebk/lobste_rs_migrates_from_mariadb_sqlite
- nevetlobste.rs migrates from MariaDB to SQLite
- javabotChronos's title: "lobste.rs migrates from MariaDB to SQLite | Lobsters"
- ChronosOops, that article is outdated. They had to revert after their first attempt, but later, they did successfully make the move. They have articles discussing all the details, including their VPS requirements.
- * dreamreal boggles
- dreamrealthis mostly makes me think whoever designed lobste.rs may have done a good thing in design but their awareness of actual architecture done got broke
- ChronosWell, the website uses Ruby, so I'd guess that hurts pretty bad, performance-wise, heh.
- dreamrealmy point stands
- Chronosdreamreal: My _guess_ is that it was originally designed using "best practices," which means it was probably extremely overly-complex, etc.
- ChronosBut that's just a guess. Modern technical people _do_ seem to love their _ridiculously_ overly complex solutions these days.
- dreamrealnevet would *die* on sqlite and badly
- Chronosdreamreal: What does nevet use? And why would it die on sqlite?
- dreamrealpostgres, and it's an orchestration engine
- dreamrealso lots of threaded access
- dreamreal(plus it uses postgres for some specific features: sqlite is slowly getting some of them but not others)
- dreamrealI could replace db search, I think, but the multithreaded db access is still a deathknell
- ChronosI think, though I'm not sure, lobste.rs is read-mostly and write-rarely.
- ChronosWhere "write-rarely" is quite subjective, of course, heh. But I feel like I remember them saying something like that it does 3 writes per second on average?
- ChronosDon't trust my memory. I'm old. ;)
- dreamrealI mean, that's a good situation for sqlite, sure
- dreamrealbut it's still gross, and seeing a massive jump in provisioning capability by GOING TO SQLITE says horrible things about your ability to database
- ChronosI believe it :)
- dreamrealeven with ruby you shoudln't see that kind of delta
- ChronosBuilding any substantial project on Ruby makes me question the technical people behind it, heh
- dreamrealHey, ruby is great for projects that look like they are ruby-shaped. It's just that not as many projects are ruby-shaped as people want to think.
- ParaI miss the *-on-Rails era.
- ParaNow we're just mostly off the rails.
- whaleythis is the second time I've seen sqllite referenced for something that's bearing some non-trivial load. It's like the dead rising from the grave. Human Sacrifice! Dogs and Cats living together! Mass Hysteria!
- whaleynext you are going to tell me it's ok to use Redis directly as a persistent data store
- dreamrealI can't see myself doing that at all.
- Para"I made this really neat programmable cache called Redis!" "Cool, I'm going to cluster it and store unicode data into it as well."
- julemand101Para: Time to make a FUSE driver on Linux so we can mount our new Redis storage and run our servers from it
- Parajulemand101: https://www.youtube.com/watch?v=cTPBGZcTRqo
- nevetYouTube: I Wrote A Filesystem to Beat Factorio. | DocJade
- dreamreal... can we run DOOM in redis
- julemand101Para: Can also recommend: https://www.youtube.com/watch?v=JcJSW7Rprio
- nevetYouTube: Harder Drive: Hard drives we didn't want or need | suckerpinch
- Para(spoiler: DocJade learned Rust and made a custom FUSE filesystem to run Factorio from diskettes)
- ParaWhat even are the the DOOM primitives.
- * Chronos throws any article with the word "Rust" in it in the bit bucket.
- ParaOh but it's Factorio so it's way way way better.
- ParaThe factory must grow.
- Tenchiare we talking about Rust the video game or Rust the programming language ?
- ParaThe better Rust. Which is the programming language.
- whaleythe lifetime of this conversation needs to go out of scope
- dreamrealThat's unsafe.
- sbalmosdon't go into a panic. it's just a trait of his personality