[FEATURE]: Support CapacitorJS SQLite

drizzle-team / drizzle-orm

Headless TypeScript ORM with a head. Runs on Node, Bun and Deno. Lives on the Edge and yes, it's a JavaScript ORM too 😅

https://orm.drizzle.team

Apache License 2.0

24.78k stars 656 forks source link

[FEATURE]: Support CapacitorJS SQLite #924

Open scr2em opened 1 year ago

scr2em commented 1 year ago

Describe what you want

https://github.com/capacitor-community/sqlite

it's a Capacitor community plugin for Native and Electron SQLite Databases.

It would be nice to support it. Thanks for taking this into consideration.

bluepuma77 commented 8 months ago

That would be a great addition! Can someone estimate the effort?

Will this only need some copy&paste from another adapter or will it require hours/days of work?

CaseoJKL commented 5 months ago

Yes please, We need drizzle with Ionic Capacitor. wrap the already existing https://github.com/capacitor-community/sqlite adapting the properties Drizzle expects.

It would be a great feature as more people are switching over to Drizzle.

mauroziux commented 4 months ago

How difficult would it be? I'm needing it

yshalsager commented 3 months ago

I'm interested in seeing this as well. I have checked typeorm PR that added capacitor support, and the changes seem relatively minimal.

richardliebmann commented 3 months ago

DMills03 commented 2 months ago

oliveryasuna commented 2 months ago

I have done this for Kysely. Does Drizzle ORM have a custom Driver API, similar to Kysely? Maybe I could take a stab at it.

@yshalsager Note that the TypeORM implementation doesn't support transactions well.

solmanter commented 2 weeks ago

oliveryasuna commented 4 days ago

@scr2em @bluepuma77 @CaseoJKL @mauroziux @yshalsager @richardliebmann @DMills03 @solmanter

I started an open-source project last night to fill the gap with drivers for various ORMs. I am starting with Drizzle. It is not production-ready. Contributions are welcome. https://github.com/oliveryasuna/capacitor-sqlite-drivers

CaseoJKL commented 3 days ago

@oliveryasuna Could you have a short meeting ? In that case feel free to contact me.