|17 days ago||16 days ago|
|MIT License||BSD 3-clause "New" or "Revised" 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.
Show HN: A Full-Stack Web Framework Written in Go
18 projects | news.ycombinator.com | 13 May 2022
Thanks for your comment and question @onionisfruit. Top-notch handle too!
>> What are your plans for models and persistence?
1. High-level, type-safe "ORM" that's generated from your database schema.
GUI to modify data in CloudSQL tables
1 project | reddit.com/r/googlecloud | 9 May 2022
Something like that? https://github.com/xo/xo
We Went All in on Sqlc/Pgx for Postgres and Go
31 projects | news.ycombinator.com | 8 Sep 2021
I'm a big fan of the database first code generator approach to talking to an SQL database, so much so that I wrote pggen (not to be confused with pggen, as far as I can tell a sqlc fork, which I just recently learned about).
I'm a really big partisan of this approach, but I think I'd like to play the devil's advocate here and lay out some of the weaknesses of both a database first approach in general and sqlc in particular.
All database first approaches struggle with SQL metaprogramming when compared with a query builder library or an ORM. For the most part, this isn't an issue. Just writing SQL and using parameters correctly can get you very far, but there are a few times when you really need it. In particular, faceted search and pagination are both most naturally expressed via runtime metaprogramming of the SQL queries that you want to execute.
Another drawback is poor support from the database for this kind of approach. I only really know how postgres does here, and I'm not sure how well other databases expose their queries. When writing one of these tools you have to resort to tricks like creating temporary views in order infer the argument and return types of a query. This is mostly opaque to the user, but results in weird stuff bubbling up to the API like the tool not being able to infer nullability of arguments and return values well and not being able to support stuff like RETURNING in statements. sqlc is pretty brilliant because it works around this by reimplementing the whole parser and type checker for postgres in go, which is awesome, but also a lot of work to maintain and potentially subtlety wrong.
A minor drawback is that you have to retrain your users to write `x = ANY($1)` instead of `x IN ?`. Most ORMs and query builders seem to lean on their metaprogramming abilities to auto-convert array arguments in the host language into tuples. This is terrible and makes it really annoying when you want to actually pass an array into a query with an ORM/query builder, but it's the convention that everyone is used to.
There are some other issues that most of these tools seem to get wrong, but are not impossible in principle to deal with for a database first code generator. The biggest one is correct handling of migrations. Most of these tools, sqlc included, spit out the straight line "obvious" go code that most people would write to scan some data out of a db. They make a struct, then pass each of the field into Scan by reference to get filled in. This works great until you have a query like `SELECT * FROM foos WHERE field = $1` and then run `ALTER TABLE foos ADD COLUMN new_field text`. Now the deployed server is broken and you need to redeploy really fast as soon as you've run migrations. opendoor/pggen handles this, but I'm not aware of other database first code generators that do (though I could definitely have missed one).31 projects | news.ycombinator.com | 8 Sep 2021
I've used https://github.com/xo/xo, extended it with some custom functions for templating, extended the templates themselves, and can now generate CRUD for anything in the database, functions for common select queries based on the indices that exist in the database, field filtering and scanning, updates for subsets of fields including some atomic operations, etc. The sky is the limit honestly. It has allowed me to start with something approximating a statically generated ORM and extend it with any features I want as time goes on. I also write .extra.go files along side the generated .xo.go files to extend the structs that are generated with custom logic and methods to convert data into response formats.
I like the approach of starting with the database schema and generating code to reflect that. I define my schema in sql files and handle database migrations using https://github.com/golang-migrate/migrate.
If you take this approach, you can mostly avoid exposing details about the SQL driver being used, and since the driver is mostly used by a few templates, swapping drivers doesn't take much effort.
sqlh - The SQL Helper
3 projects | reddit.com/r/golang | 3 Jun 2021
Here is an example of the MySQL Django tables generated by GORM https://github.com/xo/xo/tree/master/examples/django/mysql
Fighting boilerplate with code generation
3 projects | dev.to | 10 Apr 2021
10 projects | reddit.com/r/golang | 10 Apr 2021
GORM is a bad idea?
5 projects | reddit.com/r/golang | 10 May 2022
I used to use https://github.com/volatiletech/sqlboiler, but now I use https://github.com/ent/ent which has in my opinion surpassed it in a very short time by adding a ton of useful features and having a great documentation.
Golang backend with lots of raw SQL queries
5 projects | reddit.com/r/golang | 2 May 2022
I used https://github.com/volatiletech/sqlboiler. It's a database-first OEM generator. Comes with CRUD functions and helper with 0 config needed.
Sqlboiler - Generate a Go ORM tailored to your database schema.
1 project | reddit.com/r/github | 23 Apr 20221 project | reddit.com/r/github_trends | 23 Apr 2022
Looking for some ORM/db access layer suggestions
10 projects | reddit.com/r/golang | 20 Mar 2022
SQL Query Strategy for complex structs
9 projects | reddit.com/r/golang | 6 Mar 2022
didn’t know jet, any major difference with https://github.com/volatiletech/sqlboiler?
A good ORM for Golang?
4 projects | reddit.com/r/golang | 28 Feb 2022
I'm a maintainer of SQLBoiler (https://github.com/volatiletech/sqlboiler), and it is the best I've used (I've tried a number).
SQLBoiler v4.8.4: Generate a Go ORM tailored to your database schema
1 project | reddit.com/r/golang | 28 Jan 2022
Sql generator but for SQLite
4 projects | reddit.com/r/golang | 26 Dec 2021
Try sqlboiler. https://github.com/volatiletech/sqlboiler
Golang for backend
13 projects | reddit.com/r/golang | 1 Dec 2021
https://github.com/volatiletech/sqlboiler cause is nice to have type safety, or sqlc, I use sqlx most of the time
What are some alternatives?
GORM - The fantastic ORM library for Golang, aims to be developer friendly
ent - An entity framework for Go
sqlc - Generate type-safe code from SQL
sqlx - general purpose extensions to golang's database/sql
go-pg - Golang ORM with focus on PostgreSQL features and performance
upper.io/db - Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
FrameworkBenchmarks - Source for the TechEmpower Framework Benchmarks project
xorm - xorm是一个简单而强大的Go语言ORM库，通过它可以使数据库操作非常简便。本库是基于原版xorm的定制增强版本，为xorm提供类似ibatis的配置文件及动态SQL支持，支持AcitveRecord操作
reform - A better ORM for Go, based on non-empty interfaces and code generation.