golang-database-library-orm-example VS bob

What I found is sqlx and sqlc are excellent for hand-rolled queries, but is poor for dynamic queries which a query builder library/orm might suite better. If there are many eager-loading table relationships, I found that orms tend to be much better. Of course these are entirely my personal opinion. I dove into more details on how each libraries and orms fares against those operations in the posts. It is also accompanied with reproducible repo at https://github.com/gmhafiz/golang-database-library-orm-example

I discussed approaches using different libraries and ORMs at https://www.gmhafiz.com/blog/golang-database-library-orm-example-dynamic-list/. Though I just realised the example for squirrel is missing. Check out the code examples though

I show scans for a many to many relationship between two tables. https://github.com/gmhafiz/golang-database-library-orm-example/blob/master/db/sqlc/manyToMany.go

I made repo that compares between different libraries and orms including sqlx, sqlc, sqlboiler, gorm, and ent https://github.com/gmhafiz/golang-database-library-orm-example

Use something that does codegen, like sqlc or Bob.

Also hout out to https://github.com/stephenafamo/bob

If you want to read the schema from the DB, use Bob. https://github.com/stephenafamo/bob

Generation for enums is done if you use Bob to generate your ORM.

Bob (https://github.com/stephenafamo/bob) generates models for a database schema, and for ease of use, I think it makes sense to be able to work with whatever format the schema is defined with.

Bob ORM for DB access

For an ORM recommendation, I'm heavily biased towards Bob (https://github.com/stephenafamo/bob) since I created it.

Website

Bob's GitHub Repository

I would definitely appreciate contributions to Bob: https://github.com/stephenafamo/bob