PowerSync + MikroORM?

[KazimirPodolski]

MikroORM - arguably the most well-developed, stable and alive ORM for Node/Typescript - just released a new version where they decoupled from direct dependency on Node (but still uses some features in runtime via dynamic import).

As a full-stack dev currently utilizing PowerSync, I constantly notice how front-end part of my app is very naive about working with Sqlite / SQL in general (even with Kysely / Drizzle). I believe front-end could use many of back-end ORM goodies being available for years (decades?).

However, since I remember PowerSync using Sqlite in it's own way without classic tables schema, it might be non-trivial to implement a driver for MikroORM?

Maybe raw Sqlite tables can eable easy enough integration?

[stevensJourney]

Since they're using Kysely now under the hood, we could maybe theoretically use our PowerSync+Kysely integration as one of the drivers.

I haven't looked at the entire ORM functionality, but as a quick test. I worked with Codex to try and get a test setup for this working. For interest sake, this was what I tested so far mikro-orm/mikro-orm@master...stevensJourney:poc-mikro-orm:test-powersync.

The above is in a very rough state (I've only done minimal testing), but perhaps someone could have some fun playing around with it.

[stevensJourney]

An update: I managed to flesh this out a bit more. I built a small demo app which uses MikroORM in a PowerSync Web+React environment.

https://github.com/powersync-community/mikro-orm-poc