Paperless-ngx is an extensive document management system. 3.0.0 has just been released.
It seems from a user/admin perspective that a lot of obsolete stuff under the hood got removed and they did some performance stuff, but it’s also full of AI features. There’s too many changes to read them all though, I wonder if there’s a blogpost or something somewhere summarizing the main changes.
Personally I’ll stay with 2.X for some days at least to see what people say about the new version. I’m not interested to have AI parse my documents, the alrogirthmic auto tagging etc works quite well.
I disagree with your broad statement that SQL in general isn’t tricky to make more performant if you know what you’re doing. Worked with DBAs who have decades of experience who have gotten great help in streamlining queries and schemas from AI tools in the last couple of years.