Over a million developers have joined DZone.

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

· Java Zone

Discover how powerful static code analysis and ergonomic design make development not only productive but also an enjoyable experience, brought to you in partnership with JetBrains

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.

Learn more about Kotlin, a new programming language designed to solve problems that software developers face every day brought to you in partnership with JetBrains.

Topics:

The best of DZone straight to your inbox.

SEE AN EXAMPLE
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.
Subscribe

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

{{ parent.tldr }}

{{ parent.urlSource.name }}