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?

[AntonOfTheWoods]

@natalie-o-perret a bit late but yes, you can both do a pg_dump and export the "filesystem" directly, so you can just "remount" the filesystem on another machine/environment. Not exactly like sqlite but functionally equivalent.

[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