News for hackers. Stuff that matters.
Re:File Attachments: Databases can now store files and images by brazzy on Wednesday August 30, 2023 @04:45PM (#37328837)
Most of what you wrote there is simply not true for modern DBMS, specifically PostgreSQL has a mechanism called TOAST (https://www.enterprisedb.com/postgres-tutorials/postgresql-t...) that does exactly what you claim "they aren't probably interested in doing" and completely eliminates any performance penalty of large objects in a table when they are not used.
Re:File Attachments: Databases can now store files and images by crabbone on Thursday August 31, 2023 @09:14AM (#37336665)
sigh... lol, an "expert".

PostgreSQL just like most RDBMS uses filesystem as a backend. It cannot be faster than the filesystem it uses to store its data. At best, you may be able to configure it to use more caching, and then it will be "faster" when you have enough memory for caching...

Re:File Attachments: Databases can now store files and images by brazzy on Thursday August 31, 2023 @02:03PM (#37341302)
What does that have to do with my comment? I didn't say say that an RDBMS is faster than a filesystem, just that your statements about them "seeing serious drops in performance when it comes to indexing, filtering, searching etc." are clearly wrong.

It seems very clear that it is you who knows some vaguely relevant bit of trivia, but actually have no clue about the subject in general, and try to make up for that in arrogance. Which is, honestly, pretty embarrassing.