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:
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.
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.
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.
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.
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.