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

1. sqlx

   1 71 16,517 3.3 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.

2. SaaSHub

   www.saashub.com featured

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

   

3. sqlc

   2 178 13,999 9.0 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.

4. sqlf

   3 5 127 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

5. go-sqlite

   4 12 825 7.3 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.

6. Dapper

   5 54 17,671 7.1 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.

7. bun

   6 18 3,943 9.2 Go

   SQL-first Golang ORM (by uptrace)

   

   Though, i've would give a try to bun

8. xo

   7 17 3,757 6.1 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.

9. Squirrel

   8 53 7,107 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.

10. sqly

    9 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