sqlf
bun
sqlf | bun | |
---|---|---|
5 | 18 | |
126 | 3,149 | |
- | 7.7% | |
3.0 | 7.9 | |
9 months ago | 8 days ago | |
Go | Go | |
MIT License | BSD 2-clause "Simplified" License |
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.
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
bun
-
ORM or no ORM (and which ones)?
This way: https://github.com/uptrace/bun, I prefer in all cases with PostgreSQL
- When creating an API (or even a website) what's the best practice of initializing a database connection and using it across the application where it's necessary?
-
Best packages?
https://github.com/uptrace/bun For SQL building.
-
Which ORM framework are you using with golang, and why?
I use Bun by Uptrace - https://github.com/uptrace/bun
-
What’s your preferred setup to work with SQL DB (without ORM) ?
Though, i've would give a try to bun
-
What SQL library are you using?
Bun would be my choice, it spans a nice gap between full ORM and query builder - https://github.com/uptrace/bun
- Bun – SQL-first Golang ORM for PostgreSQL, MySQL, mssql, and SQLite
-
Bun: SQL-first Golang ORM
To get started, see the documentation and run examples.
-
SQL Query Strategy for complex structs
bun and go-pg both seem to work fairly well for these kind of purposes.
- Bun v1.1 SQL client adds supports for MSSQL
What are some alternatives?
pgx - PostgreSQL driver and toolkit for Go
GORM - The fantastic ORM library for Golang, aims to be developer friendly
ginkgo - A Modern Testing Framework for Go
ent - An entity framework for Go
godotenv - A Go port of Ruby's dotenv library (Loads environment variables from .env files)
go-pg - Golang ORM with focus on PostgreSQL features and performance
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
sqlx - general purpose extensions to golang's database/sql
prisma-client-go - Prisma Client Go is an auto-generated and fully type-safe database client
Squirrel - Fluent SQL generation for golang