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

Just released, a free O’Reilly book on Reactive Microsystems: The Evolution of Microservices at Scale. Brought to you in partnership with Lightbend.

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.


Strategies and techniques for building scalable and resilient microservices to refactor a monolithic application step-by-step, a free O'Reilly book. Brought to you in partnership with Lightbend.


Opinions expressed by DZone contributors are their own.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}