Re:SQLite or PostgreSQL? It's Complicated
by avinassh on Tuesday June 28, 2022 @12:04PM
(#31909472)
hmm in that case I would probably pick Postgres because despite the added network call, it is still faster than an embedded DB.
[ Parent
| on HN ]
As I understand it the actual low-level database interface may be a shared library mechanism in either case. At least, for a local database I'm pretty sure that's a function of the connection type. You're still dlopen()-ing an ODBC library and the underlying glue between that and the rest of the userspace DB engine parts can be implemented in many ways. If there's a socket involved it would probably be AF_UNIX