db
db copied to clipboard
upper
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
Could we get Go methods for `SUM`, so that we don't have to write as many SQL queries? I tried passing `db.Raw("SUM(net_cost)")` to `pool.Collection("charge").Select()`, but this unfortunately returns zero every...
Hello, I want to perform a lexicographic `ORDER BY` in SQL via upper.io. In raw SQL, this is accomplished with `ORDER BY LENGTH(), `. However, upper.io's API does not appear...
Hi, I would like to use `InsertReturning()` through a view. However, upper complains that it doesn't know about the primary keys for the view. (The view is writeable and the...
Hi, I would like to use conditions like `Where()`/`Find()` around my `UpdateReturning()` statements. Can we grow the API to support this?
I think MySQL may have limited support for marshaling between UUID Go objects and VARCHAR(36) SQL columns. However, binary UUID format in SQL is much more performant. Do you think...
Hi, I am having good luck using the upper API. However, the upper.io website appears to have some glitches. I can hover over each of the INSERT, RESULT SETS, RETRIEVING...
For nested structures, it is helpful to assume JSON codecs by default. Currently, users have to add boilerplate for Scan(), Value() methods for each and every nested struct type involved...
upper looks awesome at manipulating tables! Could there be support for manipulating views as well, so that we can use more high level Go methods instead of raw SQL queries?...
Hi, I would like to see improved integration between the upper API and the standard library database/sql API. For example, it would be good for the upper API to allow...
I've referred to https://tour.upper.io/sql-builder/02 but the example doesn't show how to deal with optional relationships / left joins. In this made up example, a parent has zero or more children...
