Issues » 77

Archives   Read this issue on the Web
Postgres Weekly Issue 77
October 15, 2014
PostgreSQL 9.4 Beta 3 Released
We’ve all been excitedly waiting for Postgres 9.4 and in particular the new JSONB features, and while we have a little longer to wait, the latest beta with fixes is here and available now.
postgresql.org
Following a Select Statement Through Postgres Internals
This is hands down the best walk through I’ve seen of what happens when you run a standard SELECT query in Postgres. If you’re an end user and want to dig a little deeper this walk through is a great start.
Pat Shaughnessy
Announcing PGConf US 2015: Mar 25-27 in New York City
PGConf NYC 2014 was the largest PostgreSQL conference ever in the US and has now been renamed PGConf US to recognize its growth. A call for proposals is now open, so if you want to speak, consider submitting a talk.
postgresql.org
Pagination Done the Right Way
Paginated results can often wreck havoc on the performance of your database. If you need to paginate anything in your app, here’s what you need to know.
Markus Winand
Exploring the Postgres Gin index
Postgres has a pretty vast array of Postgres indexes, all of which can be immensly valuable, but you have to know when to use which. Gin is one of the lesser known, but can be especially handy and here’s the perfect crash course.
Derek Parker
How to Persist Hashes in Rails Applications with PostgreSQL
Sometimes you don’t want to think about columns and just want to store a hash of your data. Fortunately Postgres can help, and here’s the perfect crash course for it, at least for Rails that is.
Kamil Lelonek
How To Deploy Django on Nginx, Gunicorn with Postgres
Setting up Postgres for production isn’t rocket science, but isn’t elementary math either. For Python devs here’s a great guide on a production ready setup.
Vexxhost
SQL for Marketers
SQL isn’t the most friendly of languages, but it is incredibly powerful. Furthermore, the amount of valuable data that lies in relational databases continues to grow, if you’re not a developer here’s an awesome intro to SQL.
Periscope
Find Database Tech Interesting? Check out DB Weekly, our Database Weekly
DB Weekly is our newsletter that covers database trends and new releases and technologies each week. Issue 33 looked at an overview of NoSQL databases, a library that runs a filesystem through a SQLite database, and Amazon's new SSD storage options for RDS.
Cooper Press Sponsored
Curated by Craig Kerstiens and published by Cooper Press.
Want to sponsor an issue? See our media kit.

© 2014 Cooper Press Ltd. Email policy Privacy policy
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK
Update your email address
or unsubscribe here

ONE e-mail each Wednesday. Easy to unsubscribe. No spam — your e-mail address is safe
Published by Cooper Press and curated by Craig Kerstiens