Re:SQLite or PostgreSQL? It's Complicated
by robonerd on Tuesday June 28, 2022 @02:52PM
(#31911542)
I read that as "dedicated server[process]" not "dedicated server[hardware]" While the latter would obviously imply the former, it's really the former that increases the complexity of managing whole affair. Desktop applications with a dependency on mysql/postgres running on the same machine are, in my experience without exception, a pain in the ass for users.
[ Parent
| on HN ]
Re:SQLite or PostgreSQL? It's Complicated
by ed25519FUUU on Wednesday June 29, 2022 @01:43AM
(#31916869)
Managing a publicly accessible DB and user certs to connect to it securely is like someone’s full time job at some companies.
Why should the database ever be publicly accessible? I've only ever seen databases being accessible by applications and maybe users (but those only for analytics databases), and have never experienced anyone working full time on certs and user access for a single database. There's usually a team for that, but they do that for the whole server fleet.