Over a million developers have joined DZone.

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

DZone 's Guide to

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

· Java Zone ·
Free Resource

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.


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}