Creating an API using Go and sqlc

• Squirrel

  52 6,505 2.8 Go

  Fluent SQL generation for golang

  

use some lib that facilitates SQL generation, like Squirrel

• post-sqlc

  2 13 10.0 Go

  Code used in a post about sqlc.dev

db.go - contains the interfaces, structs, and constructors

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• go-sqlmock

  19 5,817 5.4 Go

  Sql mock driver for golang to test database interactions

  

For that, I used the lib go-sqlmock. So, for example, the following snippet is part of the person/service_test.go file:

• sqlc

  169 10,837 9.7 Go

  Generate type-safe code from SQL

  

I will present in this post a project that fits in the last category: sqlc.

• sqlx

  70 15,333 0.0 Go

  general purpose extensions to golang's database/sql

Implement the Repository interface by writing the queries in code, perhaps using some solution like Squirrel or sqlx.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project