Re: [sqlalchemy] using Column.in_(a_large_list) is very slow.

On 15 Nov 2013, at 17:00, John Kida jdk...@gmail.com wrote: Hi guys, i dont really think this is sqlalchemy issue, but thought someone might be able to tell me why. I have a large list of id values, over 100,000 that are given to me from a text file.. Now I need to pull all rows that

[sqlalchemy] Using PostgreSQL DELETE ... USING tableA... syntax

How might one extend a Delete clause such that I can use USING in the statement? Something like this (given t2 is a Table (or selectable?)): Turn this (assuming SomeObject is tied to t1): q = sess.query(SomeObject) q = q.filter(...) q = q.filter(SomeObject.some_column==t2.c.some_other_column)

[sqlalchemy] SQLSoup, whitespace

Happy Friday night everyone. Maybe there's an easy way to deal with this: How can I use the SQLSoup insert function to update columns whose names contain whitespace? ie: db.table.insert(XML Schema Version=None) Are there any cool tricks I don't know? Thanks -- You received this message