Postgres Weekly
Archives| Latest| RSS
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.
« Prev
Next »
Postgres Weekly
Issue 125 — October 1, 2015
Upsert Lands in Postgres 9.5
Upsert is here! Well… It will be available in Postgres 9.5, it’s now fully committed so there’s no question about if, it’s just when. Take a read through the commit here.
postgresql.​org
PGConf Silicon Valley PostgreSQL Conference
One of the last Postgres conferences of the year is coming up, and it’s looking to be a great one in Silicon Valley. With a number of speakers from within the Postgres community and several from others, make sure to check it out if you’re looking for another conference to get to.
pgconfsv.​com   #news 
Postgres session_replication Role - Bucardo and Slony's Powerful Ally
Postgres’ session_replication role is really meant to be a utility when using replication, allowing you to avoid certain workflows–it’s also extremely efficient at bulk loading. But there’s also some more detailed use cases where it’s incredibly useful.
Greg Sabino Mullane
The Top 10 List for Planning a Postgres Deployment
A well-prepared DBA considers their strategy for a Postgres rollout early. Thinking about key database questions in advance can make you the IT hero as you reveal a solid deployment plan that supports the goals of the business.
EnterpriseDB    #sponsored 
Folding Postgres Window Functions into Rails
When you want to order with some sub-grouping, or compute some operation across different rows, window functions can be powerful. Here, Parker Selbert highlights how they’re not just for SQL reports only but can be used directly from Rails.
Parker Selbert
Modern-SQL.com: The Inaugural Post
You might not realize it from most guides out there, but SQL has changed over the years, or at least expanded. From the creator of Use the Index Luke, here’s a guide that aims to start covering what modern SQL is and how you can take advantage of it.
Markus Winand
Trying JSON in Django and PostgreSQL (and compare with MongoDB)
Postgres has had JSON support for a couple years now, and it’s gotten even better with JSONB. Now frameworks have caught up as well adding solid support, take a look at the Django experience for working with JSON and Postgres compared with Mongo.
Alexey Evseev
Barman 1.5.0 released
2ndQuadrant has released version 1.5.0 of Barman - the Backup and Recovery Manager for PostgreSQL.
PostgreSQL.​org   #tools 
Win a Ticket to 'All Your Base' Database Conference in London on November 13
All Your Base   #news 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.