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

Learn how to stop testing everything every sprint and only test the code you’ve changed. Brought to you by Parasoft.

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 top tips for Java developers and best practices to overcome common challenges. Brought to you by Parasoft.


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}