SQL Zone is brought to you in partnership with:

Alec is a Content Curator at DZone. He lives in Raleigh and spends his free time writing and programming. Alec is a DZone Zone Leader and has posted 530 posts at DZone. You can read more from them at their website. View Full User Profile

The Best of the Week (Aug. 15): SQL Zone

08.24.2014
| 3548 views |
  • submit to reddit

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

1. Math and SQL, Part 4: Basic Data Types - Sets, Tuples, and Bags

A reasonable understanding of the relational model requires understanding the basic data types which make it up, both in the idealized model and in real-world applications. This post discusses both the idealized model and the accommodations the standard implementations of it make to the messiness of the real world.

2. JPA Tutorial: Setting Up JPA in a Java SE Environment

When I first started out with JPA, I had real difficulties to set it up because most of the articles on the web are written for Java EE environment only, whereas I was trying to use it in a Java SE environment. I hope that this article will be helpful for those who wish to do the same in the future.

3. PostgreSQL Wishlists: What Users Want to See in 9.5

It wasn't too long ago that we saw the release of PostgreSQL 9.4 Beta 1, but now there's talk of PostgreSQL 9.5 and, in particular, what sorts of changes it ought to bring. Two separate wishlists have been assembled in the last few days, each sporting a handful of hopes for 9.5.

4. The Dark Side of Hibernate Auto Flush

Now that I described the the basics of JPA and Hibernate flush strategies, I can continue unraveling the surprising behavior of Hibernate’s AUTO flush mode.

5. Script to Manage MaxScale

There are still some rough edges and stuff to be fixed in MaxScale 1.0, but it is clearly close to GA. One thing missing, though, is something to manage starting and stopping MaxScale in a somewhat controlled way, which is what this blog is all about.