Over a million developers have joined DZone.

SQL Zone Link Roundup (Apr. 5)

DZone 's Guide to

SQL Zone Link Roundup (Apr. 5)

· Java Zone ·
Free Resource

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

Creating PostgreSQL Arrays Without A Quadratic Blowup

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.

Count Distinct Compared on Top 4 SQL Databases

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.


Easily query spreadsheet-like or json data with SQLite or PostgreSQL. Built around node-postgres and node-sqlite3.

PostgreSQL Pain Points

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.

Subtly Bad Things Linux May Be Doing To PostgreSQL  

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

PostgreSQL Columnar Store for Analytic Workloads

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.

Oculus VR SQL Injection Vulnerability

Over the weekend we discovered a vulnerability that potentially allowed for SQL injection within the Oculus Developer Center.

The Problem With SQL Azure

The problem with SQL Azure is that it’s not named SQL Azure.

Thank You MySQL, We’ll Miss You!

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.

MySQL is Webscale Now

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.

Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}