Feeds

Hipsters hacking on PostgreSQL

Relational cred from SoMa to Shoreditch

Top 5 reasons to deploy VMware with Tegile

Open ... and Shut With the rise of NoSQL, it's easy to assume that old-school relational databases are simply living out their dinosaur dreams for legacy applications. But a funny thing happened on the way to the SQL cemetery: PostgreSQL became cool again. Yes, PostegreSQL.

PostgreSQL was developed in 1986 by Michael Stonebraker. It was meant to be a peer to relational database heavyweights like Oracle and IBM, but never really took off. Ironically, it seems to be doing so now, and increasingly with developers who may not have been alive when Stonebraker first developed the database.

I've been seeing it pop up in conversations on HackerNews and other online forums (Disclosure: Some of those advocating PostgreSQL adoption use the word "rad" which hasn't been used since the 1980s), but the real proof that there's something to this increased interest comes from personal interactions with developer friends. Yes, such data are anecdotal, but they're happening so often now that I can't discount them as isolated biases.

One such developer is Carl Lerche, a friend and former colleague who works at Tilde and is a member of the Ruby on Rails core team. When Carl and I were at Strobe together, he and the team were heavily biased toward Riak, so it was surprising to me when he started extolling the benefits of PostgreSQL. Among them, as he told me:

Postgres is solid. It has many well thought-out features, and it's fast. It's understood: people know what it can and can't do.

There is, of course, no silver bullet solution, but Postgres is as close as it gets. It covers the greatest breadth of cases you need. The only reason i would not use Postgres is if i had other requirements besides modeling data like, for example, uptime requirements where having a single point of failure is not acceptable.

If I'm going to give up relational, i have to gain something in exchange, and 99 per cent of the time you don't need anything fancy.

When I pressed Lerche on this and asked why he doesn't use the more popular MySQL, since a relational database seems to work fine for his needs, he indicated a distrust of Oracle's stewardship of MySQL, but went on to say it has "a lot of problems... [and] a lot fewer features. And Postgres has much better licensing terms."

Lerche's perspective is mirrored by others I've talked to, or whose arguments I've read. As one online commentator says: "It's not hip and takes a bit to set up, but after you are done, you have [a] reliable workhorse with all the stuff you need."

PostgreSQL rising? Yes, it would seem so.

There are some big names using Postgres including Greenpeace and the US State Department for seriously mission-critical purposes.

They're not using PostgreSQL because it's the easiest database to learn and use. It's not. They're not using it because it's cool. It's not. They're using it because it gets stuff done. This doesn't distinguish it as much one might think in the enterprise, where PostgreSQL's free price tag and laid-back licensing isn't an overwhelming draw over Oracle and IBM. Risk-adverse CIOs will still pony up big checks to traditional vendors simply to cover their backsides.

But where PostgreSQL seems to be making headway is new-school developers, which I find fascinating, given the wealth of options they have in new breed databases like MongoDB, Cassandra, Riak and Couchbase not to mention the still-reliable MySQL. It's not that these NoSQL approaches or MySQL are fading in importance. Quite the opposite, as I've written.

But amid the hoopla PostgreSQL seems to finally be getting the attention its adherents have long claimed it deserved, and it's not the grey-beards who are arguing its merits. Not alone, anyway. They're joined by the SoMa and Shoreditch crowds who want to build cool apps that "work beautifully," even if they happen to be founded upon an old-school database like PostgreSQL.

This hasn't yet translated into job inquiries for PostgreSQL experience – which has been growing steadily according to Indeed.com data but still is dwarfed by MySQL job postings in absolute terms – and by MongoDB and other NoSQL offerings in relative terms. I'm not calling a trend here. I'm just seeing serious interest in and adoption of PostgreSQL by a young start-up developers.

Maybe PostgreSQL will finally be cool? ®

Matt Asay is senior vice president of business development at Nodeable, offering systems management for managing and analysing cloud-based data. He was formerly SVP of biz dev at HTML5 start-up Strobe and chief operating officer of Ubuntu commercial operation Canonical. With more than a decade spent in open source, Asay served as Alfresco's general manager for the Americas and vice president of business development, and he helped put Novell on its open source track. Asay is an emeritus board member of the Open Source Initiative (OSI). His column, Open...and Shut, appears three times a week on The Register.

Choosing a cloud hosting partner with confidence

More from The Register

next story
Download alert: Nearly ALL top 100 Android, iOS paid apps hacked
Attack of the Clones? Yeah, but much, much scarier – report
NSA SOURCE CODE LEAK: Information slurp tools to appear online
Now you can run your own intelligence agency
Microsoft: Your Linux Docker containers are now OURS to command
New tool lets admins wrangle Linux apps from Windows
Microsoft adds video offering to Office 365. Oh NOES, you'll need Adobe Flash
Lovely presentations... but not on your Flash-hating mobe
You stupid BRICK! PCs running Avast AV can't handle Windows fixes
Fix issued, fingers pointed, forums in flames
HTML5 vs native: Harry Coder and the mudblood mobile app princes
Developers just want their ideas to generate money
prev story

Whitepapers

Go beyond APM with real-time IT operations analytics
How IT operations teams can harness the wealth of wire data already flowing through their environment for real-time operational intelligence.
Why CIOs should rethink endpoint data protection in the age of mobility
Assessing trends in data protection, specifically with respect to mobile devices, BYOD, and remote employees.
A strategic approach to identity relationship management
ForgeRock commissioned Forrester to evaluate companies’ IAM practices and requirements when it comes to customer-facing scenarios versus employee-facing ones.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Protecting against web application threats using SSL
SSL encryption can protect server‐to‐server communications, client devices, cloud resources, and other endpoints in order to help prevent the risk of data loss and losing customer trust.