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?
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.
Its a lemmy bug with the backend. The Database breaks down because of some queries and is stuck until a restart.
Do you have the link to the Github issue for that?
No as the admins have to identify the exact troublesome db query themselves.
deleted by creator
I dont know if there is any in Postgres
deleted by creator
@MrCenny@lemmy.world could this help?
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?
The thing is, it is not the amount available databases. Rather 1 query takes super long and it blocks everything
Its Rust and Postgres
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.