search

upper / db

Data Access Layer (DAL) for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
https://upper.io/
MIT License
3.53k stars 234 forks source link

How to use modernc/sqlite driver #641

Open bbkane opened 2 years ago

bbkane commented 2 years ago

Hello - I'd like to use https://pkg.go.dev/modernc.org/sqlite for my SQLite driver (it's CGO free!). Is this possible, and if it's not currently possible, do you think it's a good idea / fairly easy for me to make a PR to add it?

xiam commented 2 years ago

Oh! CGO-free, that's good news. We've recently replaced the PostgreSQL driver, it was not that straightforward because PostgreSQL offers many different features and types (like JSON, ARRAY, etc). sqlite offers less features in comparison, so replacing the driver should be less complicated. This sounds useful, it would be a great idea and a valuable addition if you could create a PR for this.

mfridman commented 2 years ago

Fwiw we recently switched the sqlite driver in goose in favor of this modernc.org/sqlite library and it has been working nicely.

The folks maintaining it also are fairly active in Gophers slack #sqlite channel.