Over a million developers have joined DZone.

The Best of the Week (June 20): SQL Zone

DZone's Guide to

The Best of the Week (June 20): SQL Zone

· Java Zone ·
Free Resource

Automist automates your software deliver experience. It's how modern teams deliver modern software.

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

1. Error Logging and Tracking Done Right with Raygun.io

For some years now, one of the first things the author has dropped into any new project has been ELMAH. It’s neat stuff, but also an absolute firehose of exceptions. But this isn’t intended to be an ELMAH-bashing session; rather, it’s to look at the next evolution of error logging, and that’s what brings us to Raygun.io.

2. High Availability with MySQL Fabric: Part II

In a previous post, the author showed a simple HA setup managed with MySQL Fabric, including some basic failure scenarios. Today, he’ll present a similar scenario from an application developer’s point of view, using the Python Connector for the examples.

3. Database Primary Key Flavors

In this article, the author discusses the importance of primary keys in relational databases and the types of primary keys and strategies for generating them, including natural keys and surrogate keys.

4. Postgres-XL: A Scalable, Open Source SQL Database Cluster

If you're a fan of PostgreSQL, you'll certainly be interested in Postgres-XL. It's a scalable database cluster based on PostgreSQL, open source and fully ACID. The home page points to a few different use cases, including large-scale data capabilities with MPP and ease of database scaling.

5. 8 Notable SQL-on-Hadoop Frameworks

Hadoop is a standard when it comes to Big Data, and SQL is a standard when it comes data storage, so it makes sense that SQL and Hadoop would sometimes overlap. In those cases, you end up with SQL-on-Hadoop solutions.

Get the open source Atomist Software Delivery Machine and start automating your delivery right there on your own laptop, today!


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}