2 ms·
PostgreSQL is an order of magnitude more complex and extensible than SQLite. Any comparison is basic at best.
by paulddraper 3y ago
PostgreSQL is an order of magnitude more complex and extensible than SQLite.
Any comparison is basic at best.
- x0x0 3y agoI suspect it may be closer to 2 orders of magnitude than 1. eg look at the pg docs re: at least 5 different types of indices are implemented https://www.postgresql.org/docs/current/indexes.html https://www.postgresql.org/docs/current/indexes.html Everything is like that. (I'm not bashing sqlite, it's great software, but it has a tiny fraction of the product footprint that pg has.)
- paulddraper 3y ago*6 different index types. And that's just core, not even including built-in extensions like bloom.