Go Tool: (exploring) sqlc (Part 1)

1. sqlx

   1 73 16,733 3.3 Go

   general purpose extensions to golang's database/sql

   

   This time it was related to speeding up our development (and testing!) workflow when using PostgreSQL as a persistent datastore. For context, we have been successfully using database/sql and jmoiron/sqlx, and both can get the work done but I'm always trying to find better tools to improve what we have. I've been doing this investigation for a few months already, and I did find some packages and tools, but because of the amount of options I haven't really had time to try them all. In the end what I'm looking for is tools/packages that:

2. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

3. pgx

   2 72 11,442 9.1 Go

   PostgreSQL driver and toolkit for Go

   

   jackc/pgx PostgreSQL driver and toolkit for Go

4. pq

   3 29 9,364 2.5 Go

   Pure Go Postgres driver for database/sql

   

   This driver has been on my radar for months already, I actually used it for the blog series Implementing Complex Pipelines in Go, the cool thing about pgx is that it also implements the interface types defined in database/sql so replacing what we have (which uses lib/pq) should be, in theory, not that difficult.

5. migrate

   4 77 16,224 7.2 Go

   Database migrations. CLI and Golang library.

   

   golang-migrate/migrate Database migrations. CLI and Golang library.

6. sqlc

   5 181 14,490 9.0 Go

   Generate type-safe code from SQL

   

   kyleconroy/sqlc Generate type safe Go from SQL

7. Squirrel

   6 53 7,231 2.4 Go

   Fluent SQL generation for golang

   

   Masterminds/squirrel Fluent SQL generation for golang

8. dockertest

   7 48 4,257 8.2 Go

   Write better integration tests! Dockertest helps you boot up ephermal docker images for your Go tests with minimal work.

   

   ory/dockertest Write better integration tests! Dockertest helps you boot up ephemeral docker images for your Go tests with minimal work

9. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

10. factory_bot

    8 31 7,959 7.1 Ruby

    A library for setting up Ruby objects as test data.

    

    I will continue exploring sqlc as well as the other tools/packages mentioned above, another thing I'm also investigating is something similar to factory_bot for speeding up the default values required when testing PostgreSQL-related methods.

Suggest a related project