Snapshot of astaxie/beedb: 704★, Go. beedb is a go ORM,support database/sql interface,pq/mysql/sqlite
Snapshot summary built from the project's own GitHub metadata — there's no written TopGit review yet. The page will update automatically when a full review is published.
WHY NO REVIEW YET
TopGit writes full reviews for the most-starred, most-requested repositories. This page is a snapshot until then — see the READ ME tab for the original README in full.
:exclamation: IMPORTANT: Beedb is being deprecated in favor of Beego.orm :exclamation:
Beedb is an ORM for Go. It lets you map Go structs to tables in a database. It's intended to be very lightweight, doing very little beyond what you really want. For example, when fetching data, instead of re-inventing a query syntax, we just delegate your query to the underlying database, so you can write the "where" clause of your SQL statements directly. This allows you to have more flexibility while giving you a convenience layer. But beedb also has some smart defaults, for those times when complex queries aren't necessary.
Right now, it interfaces with Mysql/SQLite/PostgreSQL/DB2/MS ADODB/ODBC/Oracle. The goal however is to add support for other databases in the future, including maybe MongoDb or NoSQL?
Relationship-support is not implemented, for this we will recommend you to use Beego.orm.
All in all, it's not entirely ready for advanced use yet, but it's getting there.
Drivers for Go's sql package which support database/sql includes:
Mysql:github.com/ziutek/mymysql/godrv[*]
Mysql:github.com/Go-SQL-Driver/MySQL[*]
PostgreSQL:github.com/bmizerany/pq[*]
SQLite:github.com/mattn/go-sqlite3[*]
DB2: bitbucket.org/phiggins/go-db2-cli
MS ADODB: github.com/mattn/go-adodb[*]
ODBC: bitbucket.org/miquella/mgodbc[*]
Oracle: github.com/mattn/go-oci8
Drivers marked with a [*] are tested with Beedb
API Interface
wiki/API-Interface
Installing Beedb
go get github.com/astaxie/beedb
How do we use it?
Open a database link(may be will support ConnectionPool in the future)
type Userinfo struct {
Uid int `beedb:"PK" sql:"UID" tname:"USER_INFO"` //if the table's PrimaryKey is not "Id", use this tag
Username string `sql:"USERNAME"`
Departname string `sql:"DEPARTNAME"`
Created time.Time `sql:"CREATED"`
}
###Caution
The structs Name 'UserInfo' will turn into the table name 'USER_INFO', as defined by the tname tag.
If the key 'UserName' will turn into the select colum 'USERNAME' because of the sql tag.
saveone.Username = "Update Username"
saveone.Departname = "Update Departname"
saveone.Created = time.Now()
orm.Save(&saveone) //now saveone has the primarykey value it will update
Fetch a single object
var user Userinfo
orm.Where("uid=?", 27).Find(&user)
var user2 Userinfo
orm.Where(3).Find(&user2) // this is shorthand for the version above
var user3 Userinfo
orm.Where("name = ?", "john").Find(&user3) // more complex query
var user4 Userinfo
orm.Where("name = ? and age < ?", "john", 88).Find(&user4) // even more complex
Fetch multiple objects
var allusers []Userinfo
err := orm.Where("id > ?", "3").Limit(10,20).FindAll(&allusers) //Get id>3 limit 10 offset 20
var tenusers []Userinfo
err := orm.Where("id > ?", "3").Limit(10).FindAll(&tenusers) //Get id>3 limit 10 if omit offset the default is 0
var everyone []Userinfo
err := orm.FindAll(&everyone)
Find result as Map
//Original SQL Backinfo resultsSlice []map[string][]byte
//default PrimaryKey id
a, _ := orm.SetTable("userinfo").SetPK("uid").Where(2).Select("uid,username").FindMap()
Update with Map
t := make(map[string]interface{})
var j interface{}
j = "astaxie"
t["username"] = j
//update one
orm.SetTable("userinfo").SetPK("uid").Where(2).Update(t)
a, _ := orm.SetTable("userinfo").Join("LEFT", "userdeatail", "userinfo.uid=userdeatail.uid").Where("userinfo.uid=?", 1).Select("userinfo.uid,userinfo.username,userdeatail.profile").FindMap()
Group By And Having
a, _ := orm.SetTable("userinfo").GroupBy("username").Having("username='astaxie'").FindMap()
Nesting Models (inline)
type SQLModel struct {
Id int `beedb:"PK" sql:"id"`
Created time.Time `sql:"created"`
Modified time.Time `sql:"modified"`
}
type User struct {
SQLModel `sql:",inline"`
Name string `sql:"name" tname:"fn_group"`
Auth int `sql:"auth"`
}
// the SQL table has the columns: id, name, auth, created, modified
// They are marshalled and unmarshalled automatically because of the inline keyword
The most recent commit recorded on astaxie/beedb was 11.9 years ago, based on the GitHub push timestamp. The repository has 162 forks — one of the better signals of community interest.
How many stars does astaxie/beedb have?
astaxie/beedb has 704 GitHub stars — refresh the page for the live number, or check github.com/astaxie/beedb. TopGit mirrors GitHub's count but does not claim minute-by-minute accuracy.
Is astaxie/beedb open source?
TopGit's metadata for astaxie/beedb does not record a license. Most public repositories on GitHub ARE open source, but the exact terms vary — verify by opening the LICENSE file directly.
What is astaxie/beedb?
astaxie/beedb (astaxie/beedb) is a Go project on GitHub. From the project's own README: beedb is a go ORM,support database/sql interface,pq/mysql/sqlite
Where do I read more about astaxie/beedb?
This TopGit page is a snapshot — the READ ME tab shows the project's own README content (links stripped, images preserved). The GitHub repository at github.com/astaxie/beedb is the definitive source.
Read full README in the tab above.
Curious whether beedb is right for you?
Let ChatGPT, Claude, or Perplexity look into it — click below and see what AI actually says about beedb.