In the Go language world, Beego ORM, GORM, SQLX, GORP, XORM are the Go database frameworks with the most stars in Github that I know. These are the old database frameworks in the Go language world.

Beego ORM is beego’s own ORM framework library, and the number of stars is counted according to The number of Stars of Beego (beego also has a database framework beedB before beego, because Xie Da did not maintain this database in 2014, so it did not appear in my statistical list).

SQLX and XORM are the author’s favorite and most used Go database framework libraries in actual development. SQLX supports SQL template and mybatis SQL configuration. SQLX supports SQL template and mybatis SQL configuration. SQLX supports SQL template and mybatis SQL configuration. The second SQLT library enables SQLX to support primary and secondary data sources, read and write separation;

Xorm also has a custom enhanced version of Xormplus/XORm, which enables XORM to support SQL templates and SQL configuration like Mybatis, supports dynamic SQL, supports nested transactions, and supports transaction propagation mechanism similar to Spring in Java. And like XORM, it has built-in support for SQL Builder.

Finally, there is another interesting Go database framework library, Argen, which uses annotation method in the specific implementation, which is relatively rare in Go language development library. For the author, it is a library worth reading source code and learning, and it gives Go language another way of thinking.

In actual development, the author often chooses database framework library in SQLX, XORM and XORmplus/XORM based on business complexity and DATABASE SQL complexity. Most of the time, the author prefers XORmplus/XORM. If you also have a good Go language database framework recommendation, may wish to leave a message in the message area, we exchange and share.

The following is a list of Go language database frameworks that I have compiled. Some of the source code is very compact and concise (although there are not many stars, BUT I still list them), which is very suitable for learning to read and help yourself to improve the design and implementation of the Go language library.

Above database framework, a lot of libraries also use SQL Builder as a database framework auxiliary library, the following also introduces some OF my KNOWN SQL Builder development library.

Golang SQL Builder Benchmark compares the performance of some SQL Build libraries

Benchmarks

Go test bench =. – benchmem | t on the column – 2.6 GHz i5 Macbook Pro:

BenchmarkDbrSelectSimple 500000 2610 ns/op 864 B/op 14 allocs/op BenchmarkDbrSelectConditional 500000 3808 ns/op 1031 B/op 19 allocs/op BenchmarkDbrSelectComplex 200000 11585 ns/op 3323 B/op 53 allocs/op BenchmarkDbrSelectSubquery 200000 10025 ns/op 2851 B/op 40 allocs/op BenchmarkDbrInsert 500000 3717 ns/op 1136 B/op 19 allocs/op BenchmarkDbrUpdateSetColumns 300000 4106 ns/op 1038 B/op 24 allocs/op BenchmarkDbrUpdateSetMap 300000 5396 ns/op 1388 B/op 26 allocs/op BenchmarkDbrDelete 1000000 2150 ns/op 482 B/op 13 allocs/op BenchmarkGoquSelectSimple 100000 15180 ns/op 3282 B/op 46 allocs/op BenchmarkGoquSelectConditional 100000 19655 ns/op 4258 B/op 61 allocs/op BenchmarkGoquSelectComplex 30000 50628 ns/op 11414 B/op 215 allocs/op BenchmarkSqrlSelectSimple 500000 3555 ns/op 952 B/op 15 allocs/op BenchmarkSqrlSelectConditional 300000 4377 ns/op 1112 B/op 20 allocs/op BenchmarkSqrlSelectComplex 100000 24040 ns/op 4751 B/op 100 allocs/op BenchmarkSqrlSelectSubquery 100000 26203 ns/op 3560 B/op 67 allocs/op BenchmarkSqrlSelectMoreComplex 30000 47018 ns/op 7256 B/op 150 allocs/op BenchmarkSqrlInsert 200000 7773 ns/op 1304 B/op  25 allocs/op BenchmarkSqrlUpdateSetColumns 200000 8633 ns/op 1369 B/op 32 allocs/op BenchmarkSqrlUpdateSetMap 200000 15786 ns/op 1788 B/op 36 allocs/op BenchmarkSqrlDelete 500000 3669 ns/op 496 B/op 12 allocs/op BenchmarkSquirrelSelectSimple 100000 14934 ns/op 2737 B/op 52 allocs/op BenchmarkSquirrelSelectConditional 100000 18034 ns/op 4023 B/op 84 allocs/op BenchmarkSquirrelSelectComplex 20000 63096 ns/op 12742 B/op 283 allocs/op BenchmarkSquirrelSelectSubquery 30000 48956 ns/op 9954 B/op 206 allocs/op BenchmarkSquirrelSelectMoreComplex 20000 83842  ns/op 17153 B/op 386 allocs/op BenchmarkSquirrelInsert 100000 14517 ns/op 3356 B/op 75 allocs/op BenchmarkSquirrelUpdateSetColumns 100000 23995 ns/op 4787 B/op 108 allocs/op BenchmarkSquirrelUpdateSetMap 50000 27141 ns/op 5203 B/op 112 allocs/op BenchmarkSquirrelDelete 100000 16728 ns/op 2815 B/op 67 allocs/opCopy the code