sqly
sqlf
Our great sponsors
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqly
-
What’s your preferred setup to work with SQL DB (without ORM) ?
That's what I'm trying to remove with sqly (Scully). But it's mostly a PoC at this moment.
-
sqly a simple database/sql helper for making queries code less repetitive
GitHub: https://github.com/dstpierre/sqly
sqlf
-
What’s your preferred setup to work with SQL DB (without ORM) ?
sqlf for building parameterized queries, yet to settle on a row-to-struct mapper, doing it manually for now
- What SQL library are you using?
-
Looking for some ORM/db access layer suggestions
We use https://github.com/keegancsmith/sqlf at work for building queries, its very enjoyable. It feels like using fmt.Sprintf but everything is properly parameterized
-
Do you think building SQL Queries like strings.Builder{}/fmt.Printf is practical and readable?
Oh. I meant this one https://github.com/keegancsmith/sqlf
-
What are your favorite packages to use?
https://github.com/keegancsmith/sqlf for building parameterized SQL queries
What are some alternatives?
Squirrel - Fluent SQL generation for golang
bun - SQL-first Golang ORM
xo - Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
pgx - PostgreSQL driver and toolkit for Go
sqlx - general purpose extensions to golang's database/sql
Gin - Gin is a HTTP web framework written in Go (Golang). It features a Martini-like API with much better performance -- up to 40 times faster. If you need smashing performance, get yourself some Gin.
sqlc - Generate type-safe code from SQL
Dapper - Dapper - a simple object mapper for .Net
godotenv - A Go port of Ruby's dotenv library (Loads environment variables from .env files)
go-sqlite - Low-level Go interface to SQLite 3
ginkgo - A Modern Testing Framework for Go