Over a million developers have joined DZone.

The Best of the Week (Apr. 18): SQL Zone

DZone's Guide to

The Best of the Week (Apr. 18): SQL Zone

· Java Zone ·
Free Resource

Verify, standardize, and correct the Big 4 + more– name, email, phone and global addresses – try our Data Quality APIs now at Melissa Developer Portal!

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

1. NewSQL: The Cake You Can Eat

NewSQL is growing in popularity because it preserves the value accumulated over the last 30 years of database development and deploys that capability on modern architectures and configurations. But SQL is dead, right? Not even close.

2. Three Very Useful Open Source SQL Editors

This is an update to "Two very useful open source SQL editors." A year later and the author has added one more SQL editor to his first list. He keeps this post updated to give context to lists of Open Source SQL front ends.

3. Creating GEO-Enabled Applications with MySQL 5.6

In the author's previous post, he showed some new MySQL 5.6 features which can be very helpful when creating geo-enabled applications. In this post he will show how we can obtain open-source GIS data, convert it to MySQL, and use it in our GEO-enabled applications.

4. Update Row With Highest ID In MySQL

Recently, the author needed to update the last inserted row of a table but didn't have any way of knowing what the highest ID in the table was. He can easily do this by using the max() function to select the highest ID in the table.

5. The Anatomy of Connection Pooling

All projects the author has been working on have used database connection pooling, and that’s for very good reasons. Sometimes we might forget why we are employing one design pattern or a particular technology, so it’s worth stepping back and reason on it.

Developers! Quickly and easily gain access to the tools and information you need! Explore, test and combine our data quality APIs at Melissa Developer Portal – home to tools that save time and boost revenue. Our APIs verify, standardize, and correct the Big 4 + more – name, email, phone and global addresses – to ensure accurate delivery, prevent blacklisting and identify risks in real-time.


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}