3 ms·
I don't know postgresql but is it worse that sqlite? MS Access on the other hand is easy!
by account-5 3y ago
I don't know postgresql but is it worse that sqlite? MS Access on the other hand is easy!
- to11mtm 3y agoIIRC PostgreSQL is the preferred 'reference' for when features are added to SQLite. It's a different sort of beast than SQLite/Access. SQLite, Access, and FirebirdDB in 'local' mode are examples of 'file based databases' (Access of course is normally used via the application, but you can absolutely get to it in other ways.) Postgres, MySQL/MariaDB, Microsoft SQL Server (MSSQL), Oracle, and FirebirdDB in 'client/server' mode, involve having a dedicated server (or cluster of servers) that store the data and run the actual SQL logic. Hope that helps?
- account-5 3y agoHaha, probably should have worded my previous post better; karma taking a pounding due to that, I think. I meant in reference to Crosstab query, not the databases themselves.