Over a million developers have joined DZone.

The Best of the Week (Mar. 21): SQL Zone

· Java Zone

Learn more about how the Java language, tools and frameworks have been the foundation of countless enterprise systems, brought to you in partnership with Salesforce.

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

1. Grails Goodness: Using Groovy SQL

In a previous post we learned how we can use Hibernate native SQL queries in our Grails application.

2. You’re Very Likely to Have Gotten SQL Date Time Arithmetic Wrong!

You’re very likely to have gotten SQL date time arithmetic wrong. Many common approaches don't consider things like timezones, daylight savings time, leap seconds, and other factors. But luckily, there's jOOQ to standardize SQL.

3. MaxScale for the Rest of Us, Part 3: Install and Configure MaxScale

[This is part 3 of a series. Be sure to check out part 1, part 2, and part 4!]

The first blog in this series was an overview of what MaxScale is and the second about how to set up a Cluster of MariaDB servers, using MariaDB Replication, for MaxScale to access. But now it's time to introduce MaxScale.

4. DBA 101: Sometimes Forgotten Functionality in the MySQL Client

The MySQL client has some functionalities some of us never use. Why would you use them and what is the added value of this?

5. Goose for Database Migrations

The author has been hunting for good database tools to perform that class of tasks that we all need, but that we end up re-implementing over and over again. One such task is database migrations. He's been experimenting with Goose to provide general-purpose database migration support.

Discover how the Force.com Web Services Connector (WSC) is a code-generation tool and runtime library for use with Force.com Web services, brought to you in partnership with Salesforce.


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 }}