For a look at what's been happening outside of the SQL Zone, we've assembled a collection of links from around the web covering all the tutorials, tools, new releases, rants, and raves you might have missed over the past couple of weeks:
Tutorials & Tools
In this post, we’ll take a look at a PostgreSQL function that hangs on large inputs and rewrite it in an efficient, idiomatic way.
After reading our last post, Use Subqueries to Count Distinct 50X Faster, some good folks at Hacker News and r/programming asked to see our results compared across RDBMS's.... the gauntlet had been thrown, and we are here to answer.
The kernel has to work for a wide range of workloads; it is arguably unsurprising that it does not always perform as well as some user communities would like. One community that sometimes felt left out in the cold is the PostgreSQL relational database management system project.
In addition to talking about PostgreSQL at LSF/MM and Collab, I also learned a few things about the Linux kernel that I had not known before, some of which could have implications for PostgreSQL performance.
News & Opinion
We are excited to open source our columnar store extension for PostgreSQL and share it with the community! Columnar stores bring notable benefits for analytic workloads, where data is loaded in batches.
Over the weekend we discovered a vulnerability that potentially allowed for SQL injection within the Oculus Developer Center.
The problem with SQL Azure is that it’s not named SQL Azure.
Thank you for introducing me to SQL. It must have been 1998 when we first met I and fell in love with the simplicity of SQL immediately.
WebScaleSQL is a collaboration among engineers from several companies that face similar challenges in running MySQL at scale, and seek greater performance from a database technology tailored for their needs.