The Best of the Week (May 16): SQL Zone

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

1. The PostgreSQL Datatypes You Aren't Using

You're probably not using all the datatypes available to you in PostgreSQL - there are actually quite a few. And that's not to say you should be using all of them, but it's always interesting to know what's out there, and to that end, Craig Kerstiens has made a list with descriptions and warnings.

2. Errant Transactions: Major Hurdle for GTID-Based Failover in MySQL 5.6

The author previously written about the new replication protocol that comes with GTIDs in MySQL 5.6. Because of this new replication protocol, you can inadvertently create errant transactions that may turn any failover to a nightmare. Let’s see the problems and the potential solutions.

3. SQL Server Trick: Circumvent Missing ORDER BY Clause

SQL Server is known to have a very strict interpretation of the SQL standard. In this article, the author discusses a number of ways to handle ORDER BY clauses in SQL Server.

4. High Availability with MySQL Fabric: Part I

Today, the author will review MySQL Fabric’s HA concepts, and then walk you through the setup of a 3-node cluster with one Primary and two Secondaries, doing a few basic tests with it.

5. Mobilize and Restify your SQL Data

Full-featured back-office Mobile apps in minutes, with RESTful APIs for front-office apps. Declarative logic and security - simple and powerful as a spreadsheet. JavaScript for complex logic and integration. Here’s two new technologies that make it possible.