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:
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.
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.
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.
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.
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.