Going Beyond Django ORM with Postgres

#1

Post by superchink » Thu, Mar 21, 2013, 7:29 PM UTC

Going Beyond Django ORM with Postgres
speakerdeck.com

Re: Going Beyond Django ORM with Postgres

#2

Post by rdegges » Thu, Mar 21, 2013, 8:43 PM UTC

This was one of my favorite Pycon talks this year! Great job, Craig ^^

Re: Going Beyond Django ORM with Postgres

#3

Post by craigkerstiens » Thu, Mar 21, 2013, 8:46 PM UTC

Original author here, this was a talk given at PyCon. Videos not live yet, but when it is it should be living here - http://pyvideo.org/video/1734/going-beyond-the-django-orm-li...

Re: Going Beyond Django ORM with Postgres

#4

Post by obviouslygreen » Thu, Mar 21, 2013, 9:07 PM UTC

I usually won't flip all the way through a deck, just because it's often a waste of time without the talk that goes with it... but man, this looks like great information!

Re: Going Beyond Django ORM with Postgres

#5

Post by coaxmetal » Thu, Mar 21, 2013, 9:50 PM UTC

craigkerstiens wrote: post #3

Original author here, this was a talk given at PyCon. Videos not live yet, but when it is it should be living here - http://pyvideo.org/video/1734/going-beyond-the-django-orm-li...

I was at the talk, it was great. We use a lot of that at work.

I did find a bug with serialization with the djorm-ext-pgarray extension that niwibe made and submitted a pull request with a quick fix

Re: Going Beyond Django ORM with Postgres

#6

Post by ivankirigin » Thu, Mar 21, 2013, 10:09 PM UTC

craigkerstiens wrote: post #3

Original author here, this was a talk given at PyCon. Videos not live yet, but when it is it should be living here - http://pyvideo.org/video/1734/going-beyond-the-django-orm-li...

Like others, I was at the talk and really enjoyed it. Thanks!

We've been storing json as a text blob, and now we realize we should do a lot more. Postgres continues to impress, and also Heroku's postgres service is awesome. https://postgres.heroku.com/

Re: Going Beyond Django ORM with Postgres

#7

Post by crucialfelix » Thu, Mar 21, 2013, 10:33 PM UTC

craigkerstiens wrote: post #3

Original author here, this was a talk given at PyCon. Videos not live yet, but when it is it should be living here - http://pyvideo.org/video/1734/going-beyond-the-django-orm-li...

Great job. The slides are clear enough but I'll check out the video for the rest. I've come across some of those orm extensions before but not all of those.

Btw. Do you think those pooling managers are much better than pgbouncer ?

Re: Going Beyond Django ORM with Postgres

#8

Post by [deleted] » Thu, Mar 21, 2013, 10:33 PM UTC

craigkerstiens wrote: post #3

Original author here, this was a talk given at PyCon. Videos not live yet, but when it is it should be living here - http://pyvideo.org/video/1734/going-beyond-the-django-orm-li...

[deleted]

Re: Going Beyond Django ORM with Postgres

#9

Post by gtaylor » Thu, Mar 21, 2013, 10:55 PM UTC

crucialfelix wrote: post #7

craigkerstiens wrote: post #3

Original author here, this was a talk given at PyCon. Videos not live yet, but when it is it should be living here - http://pyvideo.org/video/1734/going-beyond-the-django-orm-li...

Great job. The slides are clear enough but I'll check out the video for the rest. I've come across some of those orm extensions before but not all of those. Btw. Do you think those pooling managers are much better than pgbouncer ?

I haven't tried the other pooling managers, but I'm not sure they're going to be able to go toe to toe with pgbouncer alone. Though, I wonder if a combination of the pooling manager and pgbouncer would be worth a shot.

Re: Going Beyond Django ORM with Postgres

#10

Post by jmgrosen » Thu, Mar 21, 2013, 11:51 PM UTC

craigkerstiens wrote: post #3

Original author here, this was a talk given at PyCon. Videos not live yet, but when it is it should be living here - http://pyvideo.org/video/1734/going-beyond-the-django-orm-li...

Thanks for the talk! I was there; it was pretty awesome.

One question regarding djorm-ext-pgarray: is there a cleaner way to search inside of the array? The where(SqlExpression) works, but it really feels like a chore.