The Best of the Week (Mar. 21): SQL Zone
Join the DZone community and get the full member experience.Join For Free
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:
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.
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.
The MySQL client has some functionalities some of us never use. Why would you use them and what is the added value of this?
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.