[sqlalchemy] how to use postgresql json type in sql expression language

2015-12-11 Thread kk
Dear all, I am using Postgresql for the data and in some tables there is the json type field. It may often have float values and keys as strings. I don't use ORM very often but love using the sql expression api of alchemy. I wonder if there is some syntax for accessing json type without using

Re: [sqlalchemy] how fast can pure sqlalchemy perform?

2015-08-10 Thread kk
Hello, Tahnks to you and Mike for detaild insight, My questions follow in-line.On Friday 07 August 2015 08:48 PM, Claudio Freire wrote: On Fri, Aug 7, 2015 at 12:05 PM, kk krm...@gmail.com wrote: On Friday 07 August 2015 03:03 PM, Ladislav Lenart wrote: Hello. ORM is certainly slower. How

Re: [sqlalchemy] how fast can pure sqlalchemy perform?

2015-08-10 Thread kk
hacking. Krishnakant. On Friday 07 August 2015 09:21 PM, Mike Bayer wrote: On 8/7/15 11:05 AM, kk wrote: On Friday 07 August 2015 03:03 PM, Ladislav Lenart wrote: Hello. ORM is certainly slower. How much depends A LOT on your workload. For example bulk operations with ORM are an order

Re: [sqlalchemy] how fast can pure sqlalchemy perform?

2015-08-10 Thread kk
On Tuesday 11 August 2015 03:44 AM, Claudio Freire wrote: On Mon, Aug 10, 2015 at 6:42 PM, kk krm...@gmail.com wrote: Hello, Tahnks to you and Mike for detaild insight, My questions follow in-line.On Friday 07 August 2015 08:48 PM, Claudio Freire wrote: On Fri, Aug 7, 2015 at 12:05 PM, kk

Re: [sqlalchemy] how fast can pure sqlalchemy perform?

2015-08-10 Thread kk
On Monday 10 August 2015 10:36 PM, Claudio Freire wrote: On Fri, Aug 7, 2015 at 6:58 PM, kk krm...@gmail.com wrote: On Friday 07 August 2015 10:05 PM, Claudio Freire wrote: On Fri, Aug 7, 2015 at 12:51 PM, Mike Bayer mike...@zzzcomputing.com wrote: On 8/7/15 11:05 AM, kk wrote: On Friday

Re: [sqlalchemy] how fast can pure sqlalchemy perform?

2015-08-07 Thread kk
On Friday 07 August 2015 10:05 PM, Claudio Freire wrote: On Fri, Aug 7, 2015 at 12:51 PM, Mike Bayer mike...@zzzcomputing.com wrote: On 8/7/15 11:05 AM, kk wrote: On Friday 07 August 2015 03:03 PM, Ladislav Lenart wrote: Hello. ORM is certainly slower. How much depends A LOT on your

[sqlalchemy] how fast can pure sqlalchemy perform?

2015-08-07 Thread kk
Dear all, I am planning to totally revamp my rdbms model and totally migrate to sqlalchemy. Right now we have a lot of stored procedurs for obvious performance benefits. However it is becoming more and more difficult to maintain the system and also difficult to migrate existing users when

Re: [sqlalchemy] how fast can pure sqlalchemy perform?

2015-08-07 Thread kk
On Friday 07 August 2015 03:03 PM, Ladislav Lenart wrote: Hello. ORM is certainly slower. How much depends A LOT on your workload. For example bulk operations with ORM are an order of magnitude slower than raw SQL. On the other hand, SQLAlchemy Core let's you write generative SQL queries