bob
SQL query builder and ORM/Factory generator for Go with support for PostgreSQL, MySQL and SQLite (by stephenafamo)
golang-database-library-orm-example
Examples of using various popular database libraries and ORM in Go. (by gmhafiz)
bob | golang-database-library-orm-example | |
---|---|---|
32 | 4 | |
590 | 21 | |
- | - | |
8.9 | 0.0 | |
18 days ago | about 1 year ago | |
Go | Go | |
MIT License | - |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
bob
Posts with mentions or reviews of bob.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-05-23.
-
how to avoid writing dreadful SQL statements
Use something that does codegen, like sqlc or Bob.
-
Golang RESTAPI boilerplate repository
Also hout out to https://github.com/stephenafamo/bob
-
Go famous/standard frameworks and libraries ?
If you want to read the schema from the DB, use Bob. https://github.com/stephenafamo/bob
-
Synchronize / generate enums from a SQL table
Generation for enums is done if you use Bob to generate your ORM.
-
How do you define your database schema?
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.
-
Golang tech stack
Bob ORM for DB access
-
What framework to build heavy i/o rest api?
For an ORM recommendation, I'm heavily biased towards Bob (https://github.com/stephenafamo/bob) since I created it.
-
Bob v0.16.0: Generate from Atlas schema files
Website
-
Comparing Bob to other ORMs
Bob's GitHub Repository
-
I want to participate in a golang open source projects. Have any suggestions or recommendations?
I would definitely appreciate contributions to Bob: https://github.com/stephenafamo/bob
golang-database-library-orm-example
Posts with mentions or reviews of golang-database-library-orm-example.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-12-12.
-
Golang Database Library and Orm Examples
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
-
Dynamic sql code during runtime.
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
-
Scanning joined SQL rows into nested go struct
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
-
What kind of things have you ran with go:generate?
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
What are some alternatives?
When comparing bob and golang-database-library-orm-example you can also consider the following projects:
pgroll - PostgreSQL zero-downtime migrations made easy
optional - Optional is a library of optional Go types
go-ora - Pure go oracle client
ent - An entity framework for Go
graph - A library for creating generic graph data structures and modifying, analyzing, and visualizing them.
gorm-seeder - Gorm seeder package
uuid - A UUID package originally forked from github.com/satori/go.uuid
sqlc - Generate type-safe code from SQL
scan - Scan provides the ability to to scan sql rows directly to any defined structure.
jwt-auth-api - JWT Authentication Implementation in Golang
atlas - Manage your database schema as code
GORM - The fantastic ORM library for Golang, aims to be developer friendly
bob vs pgroll
golang-database-library-orm-example vs optional
bob vs go-ora
golang-database-library-orm-example vs ent
bob vs graph
golang-database-library-orm-example vs gorm-seeder
bob vs uuid
golang-database-library-orm-example vs sqlc
bob vs scan
golang-database-library-orm-example vs jwt-auth-api
bob vs atlas
golang-database-library-orm-example vs GORM