2 ms·
Hello, can you please summarize the advantages of PGLite compared to SQLite? I've never used Postgres before, my work is mostly on the embedded domain using fi
by nunobrito 11mo ago
Hello, can you please summarize the advantages of PGLite compared to SQLite?
I've never used Postgres before, my work is mostly on the embedded domain using files and a lot of browser execution on the client side.
With SQLite there is simplicity attached to the databases, with PGLite I see a lot of interesting extensions to try out but what would the big difference when compared to SQLite?
- richbell 11mo agoThe main use case, in my opinion, is for tests/CI. SQLite has traditionally been used to quickly run tests, however, if your actual infra uses PostgreSQL then the value is limited.
- CyberDildonics 11mo agoYou think the main use for sqlite is running tests?
- trillic 11mo agoI think they meant sqlite is often used in CI/CD testing environments as an alternative to running a client/server database in these environments. For simple crud webapps, or frameworks that are db agnostic it works well.
- Fuzzwah 11mo agoMy read is that the person you're responding to thinks that pglite could be a better fit than sqlite for ci/cd, where currently sqlite is used. Not that testing is the main use of sqlite.