Over a million developers have joined DZone.

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

· Java Zone

Discover how powerful static code analysis and ergonomic design make development not only productive but also an enjoyable experience, brought to you in partnership with JetBrains

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.

Learn more about Kotlin, a new programming language designed to solve problems that software developers face every day brought to you in partnership with JetBrains.


The best of DZone straight to your inbox.

Please provide a valid email address.

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}