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 108 — June 3, 2015
Zero-Downtime Postgres Migrations: The Hard Parts
Chris Sinjakli
Stopping Time In PostgreSQL
A look at how sequential rows in a table can end up with ‘out of order’ timestamps due to the way Postgres manages times within transactions.
Lauren Ellsworth
PostgreSQL: The Good, The Bad, and The Ugly
While Postgres is a great piece of software sometimes how the pudding gets made isn’t as pretty. While community members have good intentions, sometimes they just don’t see eye to eye. Here’s a bit of inside baseball among the community.
Jonathan Corbet
Who Needs Training? You may want to think twice.
We often get asked by our customers about how to find skilled Postgres resources for their team. With Postgres training and certification from EDB, you may have that extra something an employer is looking for, to set you apart. Check out the Foundations course to get started or look over our advanced classes. Keep your skills sharp and stay competitive.
EnterpriseDB    #sponsored 
PostgreSQL 9.5's Upsert Feature Explained
Peter Geoghegan explains Postgres 9.5’s recently-committed UPSERT feature in this 20 minute presentation.
Peter Geoghegan   #video 
Can Anyone Provide A Sound Argument for Choosing MySQL Over Postgres?
It’s not easy, but some people fight MySQL’s corner pretty well.
Hacker News
YeSQL: Battling the NoSQL Hype Cycle with Postgres [PDF]
This talk explores how new NoSQL technologies are unique, and how existing relational database systems like Postgres are adapting to handle NoSQL workloads.
Bruce Momjian
What's New in PostgreSQL 9.5
Upsert isn’t the only new thing in Postgres 9.5, and while we’re still several months away from 9.5’s release the wiki is starting to show a great picture of what’s new including a brand new index type.
PostgreSQL wiki
Block Range (BRIN) Indexes in PostgreSQL 9.5
The standard index in Postgres, a BTree index is often what you want. But, Postgres has a variety of other types, including BRIN with 9.5.
Python Sweetness
Fun with Django's New Postgres Features
Postgres has a lot of awesome datatypes, but if you can’t easily use them in your web framework then they’re much less useful. This post walks through several awesome and less common ones including hstore and arrays in Django.
Real Python
Porting ActiveRecord Validations to Postgres
A look at how common ActiveRecord validations port to Postgres constraints in SQL.
Sean Huber
Front-end Developer at Guidebook (Palo Alto or SOMA)
Guidebook helps people build and publish mobile apps for all types of devices. Our CMS is a huge part of that and you will play a key part in building our new CMS by collaborating with our design and back-end development teams to implement mockups and integrate with our back-end stack.
Guidebook    #job 
« Prev
Next »
Easy to unsubscribe at any time. Your e-mail address is safe — here's our privacy policy.