What does PGlite offer over SQlite?

[imxade]

Both can run in the browser and seem to have similar limitations in terms of concurrency, so what are the major differences?

Edit: I'm not very experienced with postgres

Ans: Live query & sync

[natalie-o-perret]

@imxade ooc, can you persist a PGLite DB to a file like SQLite can?

[jadejr]

Both can run in the browser and seem to have similar limitations in terms of concurrency, so what are the major differences?

Edit: I'm not very experienced with postgres

Ans: Live query & sync

Those are not the reasons for me.

I prefer postgres because:

• Transactional DDL
• Stricter types (in sqlite everything is effective a string)
• Vast array of extensions
• More advanced queries
• Because I already run it on the server, so I'm more familiar with it