upper.io/db VS SQLBoiler

upper.io is a viable alternative to GORM. Just a suggestion.

this is the reason why I chose upper/db over pgx/sqlc for my current cockroachdb side project

while upper/db is not as type safe, with proper testing infrastructure, it's the closest to django due to its simplicity/composability/query building support

i'm also excited to see how upper/db grows after generics land in Go later this year

https://github.com/upper/db

https://upper.io/

So far, I've enjoyed using https://github.com/upper/db for raw query building.

https://github.com/volatiletech/sqlboiler cause is nice to have type safety, or sqlc, I use sqlx most of the time

Other people maintain https://github.com/volatiletech/sqlboiler which is pretty good, though I wish it were a bit more flexible, but it may be a little faster to get started with.

I have been using sqlboiler. In my honest opinion it is the best ORM. You can see benchmark here https://github.com/volatiletech/sqlboiler

It seems you forgot sqlboiler [1] which is something like "write SQL schema, parse SQL schema, generate Go structs and functions to query the schema". Not quite like generating activerecords, I think.

[1]: https://github.com/volatiletech/sqlboiler

I was expecting the article to contain a note about SQLBoiler (https://github.com/volatiletech/sqlboiler) and why they didn't use it, but there is no. So I was expecting SQLBoiler to be heavily mentioned in the comments, but it's not the case.

I you want to see a (slightly heated) debate about `sqlc` versus SQLBoiler with their respective creators: https://www.reddit.com/r/golang/comments/e9bvrt/sqlc_compile...

Note that SQLBoiler does not seem to be compatible with `pgx`.

You might want to have a look into SQLBoiler. https://github.com/volatiletech/sqlboiler

Consider SQL Boiler because it can integrate directly with an existing database.

Depending on your preferences, sqlboiler uses the DB as source of truth for generating structs and has nice querying features

DB Management: https://github.com/volatiletech/sqlboiler -- this follows a data first model, aka your database schema will create go code, not the django way where Py code updates the DB. https://github.com/amacneil/dbmate -- I use it to manage my DB schema.