Over a million developers have joined DZone.

The Best of the Week (Nov. 07): SQL Zone

DZone's Guide to

The Best of the Week (Nov. 07): SQL Zone

· Java Zone ·
Free Resource

Get the Edge with a Professional Java IDE. 30-day free trial.

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (November 07 - November 14). Here they are, in order of popularity:

1. Painless Access from Java to PL/SQL Procedures with jOOQ

  • PL/SQL is one of those things. Most people try to stay clear of it. Few people really love it. I just happen to suffer from stockholm syndrome, since I’m working a lot with banks.

2. Backup and Restore of MySQL to OpenStack Swift

  • MySQL database usage is popular in OpenStack. Core OpenStack services for Compute (Nova), Storage (Cinder), Neutron (Networking), Image (Glance) and Identity (Keystone) all use MySQL database.

3. An Entity Modelling Strategy for Scaling Optimistic Locking

  • Optimistic locking discards all incoming changes that are relative to an older entity version. But everything has a cost and optimistic locking makes no difference.

4. How to Handle Huge Database Tables

  • There's more than one way to 'split' a table.

5. How to Deal with MySQL Deadlocks

  • A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable.


Get the Java IDE that understands code & makes developing enjoyable. Level up your code with IntelliJ IDEA. Download the free trial.


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}