Are there any feature-gaps?

[astangelo]

This is a very cool project.

I was looking for maybe a list of unimplemented Postgres features, and I didn't see any. Are there any gaps yet identified?

[astangelo]

In particular, I'm wondering if there is full support of PGs roles. PG's row-level security policies is one of it's most useful (and most differentiating) features. Is this fully supported?

[thruflo]

One thing is that PGLite runs in single user mode. I'm wondering how this fits with RLS. Is there an authentication context and how might credentials be provided?

With Electric specifically, we're implementing similar row-level security using DDLX rules. We have some discussions coming up this week about the implementation path with DDLX and PGLite. It may be interesting to see what comes out of that.