Comment on Is the daily down time of lemmy.world because of attacks, system instability, or some kind of resource issue?

Rooki@lemmy.world ⁨10⁩ ⁨months⁩ ago

• madcaesar@lemmy.world ⁨10⁩ ⁨months⁩ ago

  I know scaling DBs can be tricky, but I also know there are bootstrap solutions that go pretty high up before needing custom work.

  I don’t know enough about the lemmy infrastructure, but did they build some custom thing scratch framework or did they start with something stable and tested?

  source

  • Rooki@lemmy.world ⁨10⁩ ⁨months⁩ ago

    The thing is, it is not the amount available databases. Rather 1 query takes super long and it blocks everything

    source
  • 31337@sh.itjust.works ⁨10⁩ ⁨months⁩ ago

    Lemmy uses the Diesel ORM. Lemmy uses a large collection of Rust libraries, so I guess you could say they rolled their own framework. I’ve never encountered a framework that I believe could handle non-trivial high-traffic web applications. I worked on a project that used Django for years. By the time we were done, we bypassed almost all of Django’s functionality to get it to scale with our data and users.

    source
  • MrPoopyButthole@lemmy.world ⁨10⁩ ⁨months⁩ ago

    Its Rust and Postgres

    source
• MrPoopyButthole@lemmy.world ⁨10⁩ ⁨months⁩ ago

  Do you have the link to the Github issue for that?

  source

  • Rooki@lemmy.world ⁨10⁩ ⁨months⁩ ago

    No as the admins have to identify the exact troublesome db query themselves.

    source

    • neuromancer@lemmy.world ⁨10⁩ ⁨months⁩ ago

      [deleted]

      source

      • Rooki@lemmy.world ⁨10⁩ ⁨months⁩ ago

        I dont know if there is any in Postgres

        source

        • -> View More Comments