For INSERT-heavy workloads in Go, you may want to switch database drivers. For PostgreSQL and SQLite, the popular drivers are 20-76% slower for this workload in my tests. Some driver developers have reported issues with database/sql as an interface. notes.eatonphil.com/2023-10-05-go-…

@eatonphil That is really interesting. Do you now plan to maintain github.com/eatonphil/gosq… on an ongoing basis? BTW, it does not seem possible to specify it as a package for github.com/sqlc-dev/sqlc to use, so unless and until that my first question may be a moot point, at least for me.

@mikeschinkel Since sqlc uses database/sql, that would also go on the list of: consider not using for insert heavy workloads. :)

@eatonphil @mikeschinkel Fortunately you can use sqlc today with jackc/pgx and avoid database/sql altogether. docs.sqlc.dev/en/latest/guid…

@sqlcdev @eatonphil Thanks for the comment @sqlc, but if I understand correctly `jack/pgx` is for Postgres and not Sqlite, correct? My current project uses Sqlite. I assume that @sqlc does not support github.com/bvinc/go-sqlit… or github.com/eatonphil/gosq…?

@mikeschinkel @eatonphil @sqlc You're correct that pgx is only for PostgreSQL databases. SQLite support in sqlc assumes you're using database/sql. Supporting alternative interfaces isn't impossible but would probably require effort from those projects' maintainers.

@sqlcdev @eatonphil @sqlc Thanks for the response. Any chance of providing interfaces that would allow individual developers to make connectors?

@mikeschinkel @eatonphil @sqlc We provide a codegen plugin interface, but it's a couple levels higher than the database driver. So to write your own plugin you'd need to re-implement or extract most of what we've done internally for Go codegen, which is unfortunate.

@mikeschinkel @eatonphil @sqlc That said, we are planning to extract and publish our internal Go codegen as a plugin similar to sqlc-gen-python and sqlc-gen-kotlin, which should make forking and modifying quite a bit easier. github.com/sqlc-dev/sqlc-… github.com/sqlc-dev/sqlc-…

@sqlcdev @eatonphil @sqlc Looking forward to it. BTW, discovered sqlc recently, and LOVE it. I have been doing SQL for over 2 decades but Go for only 1/4th that long, so it really scratches my itch.

@mikeschinkel @eatonphil @sqlc In case it's still relevant, we released sqlc-gen-go which is the sqlc internal Go codegen package extracted for use as an external plugin. Forking and modifying it to support alternative SQLite drivers should be easier than forking the entirety of sqlc. github.com/sqlc-dev/sqlc-…

@sqlcdev @eatonphil @sqlc Cool! Thank you for following up. I am in the midst of a different project, but will definitely circle back around when I go back that other project.