Compatibility with SQLc/SQLx?

[ekkohdev]

I know a GORM driver is provided but I was wondering if it is possible to use this with SQLc and/or SQLx? I'm most interested in SQLc.

I saw the PR that was raised for SQLc to move to this package when they wanted to drop CGO, but they had already moved to modernc.org/sqlite. I'd much prefer to use this instead, if possible.

Unless I'm misunderstanding how things work (fairly new to this). I had a similar issue with migration tooling, where the only supported options for non-CGO seem to be modernc.org/sqlite.

Do I need to just concentrate on DIY to sidestep the lack of support? Or even consider the path of least resistance and use modernc.org/sqlite?

Thanks for the great project!

[ncruces]

Yes, I'm reasonably sure it's possible to use this with SQLc/SQLx.

For SQLc in particular, the code generator uses modernc, but then your code can use whatever driver you want. The queries are pretty generic and standard database/sql is used, so everything should work.

SQLx AFAICT is a wrapper around database/sql, so it should also work fine.

Please report back if you're successful!

[ekkohdev]

Great. Thanks for the quick reply!
I've spent some time with SQLc and yeah, haven't hit any issues as yet. So far so good.

If I do run into anything driver related I'll open an issue.