Over a million developers have joined DZone.

The Best of the Week (Mar. 28): SQL Zone

DZone 's Guide to

The Best of the Week (Mar. 28): SQL Zone

· Performance Zone ·
Free Resource

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (Mar. 28 to Apr. 3). Here they are, in order of popularity:

1. 6 Simple Performance Tips for SQL SELECT Statements

After years writing SQL statements, the author began to develop a mental check-list of things he looked at when trying to improve query performance. These are the things the author checks before moving on to query plans and reading the sometimes complicated documentation of the database he is working on.

2. The Power of Spreadsheets in a Reactive, RESTful API

The author has recently been deceived by his own Dilbertesque attitude when he stumbled upon a buzzword-filled article about Espresso Logic. But the actual product that claims to implement “reactive programming” through a REST and JSON API is frankly impressed by the ideas behind this product.

3. VoltDB Beyond Multi-Partition Transactions: Run Everywhere

VoltDB supports single- and multi-partition transactions. But what if you wanted to run an operation on all data (each partition), but you didn’t want to execute the operation as a multi-part transaction? Here’s how to do that.

4. Many-Table Joins in MySQL 5.6

I recently worked on an uncommon slow query: less than 100 rows were read and returned, the whole dataset fit in memory, but the query took several seconds to run. By default, MySQL 5.1 is not good at handling joins with such a large number of tables. The good news is that MySQL 5.6 brings improvements.

5. Installing PostgreSQL on Fedora

The author started the book Seven Databases in Seven Weeks in order to have better understanding of the different SQL / NoSQL paradigms. What are the pros and cons of each approach and play around with each type. In this post, he wants to share the installation process I had with PostgreSQL on Fedora.


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}