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

• sqlx

  71 15,527 3.6 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

  171 11,288 9.5 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 featured

  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 126 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 687 7.5 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

  45 17,205 8.3 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,203 7.7 Go

  SQL-first Golang ORM (by uptrace)

  

Though, i've would give a try to bun

• xo

  16 3,584 6.2 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.

• SaaSHub

  www.saashub.com featured

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

  

• Squirrel

  52 6,599 2.4 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 (by dstpierre)

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

Suggest a related project