Postgres 9.5’s headline features include UPSERT, row level security, and extra ‘big data’ features like BRIN indexing, improved foreign data wrappers, and TABLESAMPLE, an SQL clause for statistical sampling of large tables.
PGCon, the premiere conference for Postgres hackers, is back. If you’re doing something interesting either down in the core, as an extension, or even as an end user the CFP is open to come and speak.
If you’re looking to take Postgres 9.5 for a spin and down want to spin it up yourself on a server, Heroku has an answer. Supporting 9.5 on its beta release day, a single click can bring you a 9.5-powered database to explore.
A few years back MySQL had a few legs up on Postgres with simple replication setup, upsert… but now that list of missing features is virtually nonexistent. So with Postgres moving not just to feature parity but beyond, here’s some good speculation on what the future might hold.
Now that 9.5 has been released, it’s time to start speculating about the future. Here’s one developers wish list of what they’d like to see for 9.6 - what’s yours?
Writing SQL is one thing, but when it comes to reading other’s SQL, things can get tricky. These few tips will help to make your SQL much more understandable by others.
Nested or hierarchical structures in a database aren’t overly common, and can provide numerous frustrations when you try to implement them, but Postgres has one option that can work quite well: Ltree.
Indeed Prime is an elite new program from Indeed.com that presents
in-demand tech talent like you to top employers. Indeed Prime opens
the door to exciting career opportunities with one simple application.
Join today.
