jet
goqu
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.
jet
-
Open-sourcing SQX, a way to build flexible database models in Go
We are really happy using jet. It lets you write type safe SQL and can read the results into structs- including joins into slice fields.
-
The "preferred" way of mapping SQL results in Golang is honestly, subjectively, awful, how to deal with this
Check go-jet https://github.com/go-jet/jet
- Comparing database/sql, GORM, sqlx, and sqlc
-
goscanql - conveniently reading joined SQL data into structs
https://github.com/go-jet/jet does a similar thing.
-
Does Go, has something similar to Laravel eloquent (ORM) ?
Try go-jet, it generates the models based on the schema, provides typed column names.
-
Any mid sized / big open source code base in golang that makes use of SQL DBs?
I have tried doing that, but was unable to get it to work. I posted about it in a discussion here: https://github.com/go-jet/jet/discussions/215
-
Automatic CRUD code generetor?
Jet might be what you're looking for - https://github.com/go-jet/jet
- How to Work with SQL Databases in Go
-
ORM or no ORM (and which ones)?
Use sql builder https://github.com/go-jet/jet.
- GitHub - go-jet/jet: Type safe SQL builder with code generation and automatic query result data mapping
goqu
-
newbie here looking for a framework
For SQL, I'd probably go with goqu http://doug-martin.github.io/goqu/
- Open-sourcing SQX, a way to build flexible database models in Go
-
Best sqlc alternative for dynamic queries?
I use goqu (https://github.com/doug-martin/goqu)
-
ORM or no ORM (and which ones)?
SQL Builders (think squirrel or goqu)
-
Golang Postgres Schema Builder?
I've been looking for a package that allows me to build Postgres DDL statements in Golang. I'm currently using Goqu (https://github.com/doug-martin/goqu) for building statements and it works great, however it does not have support for building schemas. Basic things like creating tables, creating indexes. A great one in JavaScript can be found here: (https://knexjs.org/guide/schema-builder.html#essentials) I have been unable to find anything in Go, does anyone know of any packages like this?
-
GET method to get records from SQL database
Then use something like https://github.com/doug-martin/goqu to build the SQL.
-
ORM in Golang?
Try this
- Best SQL builder.
-
ORM vs SQL Builder in Go
We've been using goqu and it's super nice! although there are a ton of other query builders that could better fit your use-case.
-
escaping text in Go
If the statement is too dynamic to use query parameters I'd ideally use a dynamic query builder rather than concatenating strings. Goqu is a lib like that but I haven't yet used it personally https://github.com/doug-martin/goqu
What are some alternatives?
sqlc - Generate type-safe code from SQL
Squirrel - Fluent SQL generation for golang
SQLBoiler - Generate a Go ORM tailored to your database schema.
pgx - PostgreSQL driver and toolkit for Go
migrate - Database migrations. CLI and Golang library.
go-queryset - 100% type-safe ORM for Go (Golang) with code generation and MySQL, PostgreSQL, Sqlite3, SQL Server support. GORM under the hood.
chproxy - Open-Source ClickHouse http proxy and load balancer
pgcapture - A scalable Netflix DBLog implementation for PostgreSQL
sqrl - Fluent SQL generation for golang
tidb - TiDB is an open-source, cloud-native, distributed, MySQL-Compatible database for elastic scale and real-time analytics. Try AI-powered Chat2Query free at : https://tidbcloud.com/free-trial
sqlx - general purpose extensions to golang's database/sql