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

Java-based (JDBC) data connectivity to SaaS, NoSQL, and Big Data. Download Now.

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.

Connect any Java based application to your SaaS data.  Over 100+ Java-based data source connectors.


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}