What’s your preferred setup to work with SQL DB (without ORM) ?

• sqlx

  70 15,333 0.0 Go

  general purpose extensions to golang's database/sql

I basically use the db/sql package/interface, but I use sqlx for its StructScan ability that will scan straight into my db struct rather than having to scan into the individual fields.

• sqlc

  169 10,709 9.7 Go

  Generate type-safe code from SQL

  

sqlc for Postgresql databases is really nice. MySQL also works but has more issues and currently they are working on SQLite support.

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

  

• sqlf

  5 125 3.0 Go

  sqlf generates parameterized SQL statements in Go, sprintf style

sqlf for building parameterized queries, yet to settle on a row-to-struct mapper, doing it manually for now

• go-sqlite

  12 665 7.6 Go

  Low-level Go interface to SQLite 3

I like and use https://github.com/zombiezen/go-sqlite for CGo-free SQLite. It avoids some of the problems database/sql has, discussed here: https://crawshaw.io/blog/go-and-sqlite.

• Dapper

  40 17,108 8.0 C#

  Dapper - a simple object mapper for .Net

  

sqlx has worked pretty well for me if you are looking for a fairly light wrapper. I wish there was an equivalent of the dapper library for C#/.NET.

• bun

  18 3,097 7.5 Go

  SQL-first Golang ORM (by uptrace)

  

Though, i've would give a try to bun

• xo

  16 3,559 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 use xo . Reason is i prefer designing schema first and creating golang scaffolding later. Xo takes schema and gives me basic create/update/delete operations by default and i can also generate gocode for any sql queries that i write.

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

  

• Squirrel

  52 6,490 2.8 Go

  Fluent SQL generation for golang

  

We have used squirrel (https://github.com/Masterminds/squirrel) for query building and sqlx as a database/sql wrapper quite extensively.

• sqly

  2 7 2.6 Go

  Simple database/sql helper library to execute queries

That's what I'm trying to remove with sqly (Scully). But it's mostly a PoC at this moment.

Suggest a related project