Open source databases rise and fall on the popularity of the programming languages which use those databases. MySQL largely rose on the success of PHP, and it fell as PHP became marginalized. Our current PostgreSQL salad days are based largely on the current hegemony of Python, Ruby, and Rails. While other events have fed into changes in adoption, where the numbers of developers come from is really "what is the default database for popular language X".
While the future is unpredictable, the current momentum in programming languages is behind two platforms: Node.js and Go. PostgreSQL already enjoys good support and adoption among Go users. However, our adoption in the Node.js community is less encouraging.
I was given a set of statistics I'm not allowed to publish, but I can summarize them. Two of them are fairly alarming:
- PostgreSQL is the database for fewer than 1 out of 8 Node.js deployments which use a database.
- The rise in popularity of MongoDB almost exactly parallels the rise in usage of Node.js.
What do Node.js users want that we don't have? There's three main things that I've been able to identify:
- A better, faster, driver which fully supports asynchronous querying.
- Relatively painless multi-node scaling
- Full, indexed support for jsonish hierarchical data and queries.
Oh, and if anyone wants to work on our Node driver ... please pitch in!