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

• sqlx

  27 14,313 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

  70 9,096 0.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.

• InfluxDB

  www.influxdata.com

  sponsored

  Collect and Analyze Billions of Data Points in Real Time. Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.

  

• sqlf

  0 111 0.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

  1 350 0.0 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

  16 16,506 7.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

  3 2,477 8.4 Go

  SQL-first Golang ORM (by uptrace)

  

  Though, i've would give a try to bun

• xo

  4 3,453 0.0 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.

• Mergify

  blog.mergify.com

  sponsored

  Updating dependencies is time-consuming.. Solutions like Dependabot or Renovate update but don't merge dependencies. You need to do it manually while it could be fully automated! Add a Merge Queue to your workflow and stop caring about PR management & merging. Try Mergify for free.

  

• Squirrel

  27 6,072 4.3 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

  0 6 2.7 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