Open-sourcing SQX, a way to build flexible database models in Go

• goqu

  23 2,232 5.6 Go

  SQL builder and query library for golang

• sqlc

  169 10,950 9.6 Go

  Generate type-safe code from SQL

  

This does look like it's a little bit better than a lot of the other options in the Go ecosystem for database access, but this introduction misses something important: what SQL dialects does this support? It appears to be partly a wrapper around Squirrel. Squirrel is not new (and apparently also not maintained?) but I actually have no idea which and how much of each SQL dialect Squirrel supports.

Every time I see SQL and Go stuff, I feel literally obligated to introduce people to sqlc. That said, sqlc only has good support for PostgreSQL, and you'd have to generate code for each dialect... so that's something worth considering. (I still find it to be one of my favorite SQL tools, even with its issues.)

https://sqlc.dev/

• 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.

  

• jet

  26 2,025 8.1 Go

  Type safe SQL builder with code generation and automatic query result data mapping

We are really happy using jet. It lets you write type safe SQL and can read the results into structs- including joins into slice fields.

https://github.com/go-jet/jet

• xo

  16 3,563 6.4 Go

  Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)

  

i like xo's approach https://github.com/xo/xo but it is as is. I would love if something similar comes along that is used by db practititoners that is actively used and supported.

• ent

  145 14,930 8.1 Go

  An entity framework for Go

  

• 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