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 4 hours ago | parent [-]

The 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 4 hours ago | parent [-]

You think the main use for sqlite is running tests?

	▲	Fuzzwah 3 hours ago \| parent \| next [-]
		My 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.
	▲	trillic 3 hours ago \| parent \| prev [-]
		I 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.