db
db copied to clipboard
upper
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
Feature request for the query builder: ``` go res1 := col.Find(db.Cond{"name": "Max"}).Limit(10).Sort("-last_name") res2 := col.Find(db.Cond{"name": "Rex", "age >": "21"}).Limit(15).Sort("-last_name") err := db.Union(res1, res2).All(&people) ``` Related: #105
Is the mongo driver you guys are using maintained? It seems not https://github.com/go-mgo/mgo/blob/v2-unstable/README.md Also, what is the recommended way to do a join? Should I use the driver itself? Right...
.Select(db.Raw("o.id ,oc.project_daily_report_send_time ")).From("o1 as o"). Join("o2 as oc").On("oc.org_id = o.id").Where(db.Cond{ "oc.is_delete": consts.AppIsNoDelete, "oc.status": consts.AppStatusEnable, "o.is_delete": consts.AppIsNoDelete, "o.status": consts.AppStatusEnable, }).Paginate(uint(size)).Page(uint(page)) count, err := paginator.TotalEntries() paginator.All(po) can't mapping result into po but...
I looked at the documentation but I don't know if it supports nested transactions.
### Issue description I see MySQL clients experiencing MySQL server disconnects every few days, coinciding with an daily INSERT load of ~100K records, ~100 bytes per record, occurring over the...
SQLite is now available as a distributed database, rqlite! With a Go driver available: https://github.com/rqlite/gorqlite Can we please hook this up to upper so that programmers can benefit from upper...
Could we please get asynchronous operations? For example, some of my application's `TRUNCATE` needs would be better served by confirming that the database has received the truncation request, without having...
upper overrides the driver default connection lifetime, but does so with zero, which is already the default for both database/sql and go-sql-driver/mysql: https://github.com/upper/db/blob/master/settings.go#L185 If we're going to override this value,...
My use case is to apply MarshalDB() and UnmarshalDB() functions on custom types. After grokking around the source code, it has worked for me when I insert rows, select columns,...
