Re:Selecting All Columns Except One in PostgreSQL
by djd20 on Saturday May 19, 2018 @12:21PM
(#17108511)
Much simpler usint the ORM - you can defer columns:
http://docs.sqlalchemy.org/en/latest/orm/loading_columns.htm...
This is both at the 'object' level, and at the query level for example at the query level: from sqlalchemy.orm import defer, undefer
query = session.query(Book) query = query.options(defer('summary')) query = query.options(undefer('excerpt')) query.all()
You can also group columns for deferral/undeferral.
I use this loads.
Re:Selecting All Columns Except One in PostgreSQL
by blattimwind on Saturday May 19, 2018 @01:08PM
(#17108721)
Interesting, I knew about defer and used it in the past for pretty much the purpose the first example illustrates, but didn't remember/realize it could be used on a per-query basis.
I think if you strip columns for performance reasons for one specific query it would still be better to use Bundles or the equivalent loose select (i.e. session.query(Book.id, Book.title)) instead of query-local-deferred columns, because then you will notice if a code change leads to a down-stream access of an unwanted column for some reason.
Re:Selecting All Columns Except One in PostgreSQL
by Bishonen88 on Saturday May 19, 2018 @02:10PM
(#17108994)
what sql does this produce though? I can imagine that there'd be a hit on performance
Re:Selecting All Columns Except One in PostgreSQL
by blattimwind on Saturday May 19, 2018 @03:04PM
(#17109223)
Why would you imagine that? This compiles to SELECT col1,...,coln FROM table ...;
With sqlalchemy.orm you could also define a Bundle, see https://docs.sqlalchemy.org/en/latest/orm/query.html?highlig...