Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

The Best of the Week (Apr 03): SQL Zone

DZone's Guide to

The Best of the Week (Apr 03): SQL Zone

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (April 03 - April 10), with appearances by Java 8 and MySQL.

· Database Zone
Free Resource

Learn how to create flexible schemas in a relational database using SQL for JSON.

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

1. How to Avoid the Dreaded Dead Lock When Pessimistic Locking - And Some Awesome Java 8 Usage!

  • Sometimes you simply cannot avoid it: Pessimistic locking via SQL. In fact, it’s an awesome tool when you want to synchronise several applications on a shared, global lock. Some may think this is abusing the database. We think use the tools you have if they can solve the problem you have.

2. Modifying Your MySQL Structure w/o Downtime

  • Did you try to add a new index to your MySQL huge table and suffered from a downtime?

3. The Cost of Not Properly Managing Your Databases

  • Every day hundreds of millions of dollars are wasted by allowing improperly tuned or misconfigured systems, misunderstood infrastructure, and inefficient IT operations to live and thrive in data centers around the globe. There are both direct and indirect costs associated with allowing these unhealthy systems to continue to exist.

4. Using MobileFirst SQL Adapters with an Ionic Application

  • MobileFirst Adapters are server-side components that connect your hybrid mobile application to other things. Those “things” being generally broken down into a few categories, and a few specific adapter types. The SQL adapter is, as you can guess, a connection to a database.

5. Q&A: Multi-threaded Replication in MySQL 5.6 and MySQL 5.7

  • My webinar “Multi-threaded Replication in MySQL 5.6 and 5.7″ on February 25 generated several excellent questions following the presentation. I didn’t have time to answer many of the questions during the session and so in this post I answer all of them.

 

Create flexible schemas using dynamic columns for semi-structured data. Learn how.

Topics:
sql ,best of the week ,database

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

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

{{ parent.tldr }}

{{ parent.urlSource.name }}