Over a million developers have joined DZone.

PostgreSQL Wishlists: What Users Want to See in 9.5

DZone's Guide to

PostgreSQL Wishlists: What Users Want to See in 9.5

· Java Zone ·
Free Resource

Verify, standardize, and correct the Big 4 + more– name, email, phone and global addresses – try our Data Quality APIs now at Melissa Developer Portal!

It wasn't too long ago that we saw the release of PostgreSQL 9.4 Beta 1, but now there's talk of PostgreSQL 9.5 and, in particular, what sorts of changes it ought to bring. Two separate wishlists have been assembled in the last few days - one from Craig Kerstiens on his website, and another from Neil McGuigan on DatabasePatterns.com - each sporting a handful of hopes for 9.5. 

Kerstiens goes into detail on a few ideas. For example, he's looking for:

  • Foreign data wrappers
  • Logical replication
  • An official GUI

Among other things. McGuigan, on the other hand, is a little more sparse - just a quick list of 10 ideal updates. His hopes include:

  • Replication with SQLite over WebSocket
  • Incremental/Differential backup and restore over HTTPS
  • Text Search improvements to be more like Solr

But most interesting is their primary overlap, which took the number one position: Upsert.

Kerstiens says:

Merge/Upsert/Insert or Update whatever you want to call it this is still a huge wart that it doesn’t exist. There’s been a few implementations show up on mailing lists, and to the best of my understanding there’s been debate on if it’s performant enough or that some people would prefer another implementation or I don’t know what other excuse. The short is this really needs to happen, until that time you can always implement it with a CTE which can have a race condition.

And McGuigan keeps it simple:

1. Upsert, as always

Check out the full wishlists from Kerstiens and McGuigan for all the details, and leave a comment if there's anything else you'd like to see in PostgreSQL 9.5.

Developers! Quickly and easily gain access to the tools and information you need! Explore, test and combine our data quality APIs at Melissa Developer Portal – home to tools that save time and boost revenue. 


Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}