Over a million developers have joined DZone.

The Best of the Week (Oct. 31): SQL Zone

· Database Zone

Build fast, scale big with MongoDB Atlas, a hosted service for the leading NoSQL database. Try it now! Brought to you in partnership with MongoDB.

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

1. Hibernate Collections Optimistic Locking

  • Hibernate provides an optimistic locking mechanism to prevent lost updates even for long-conversations.

2. MySQL 5.6 Full Text Search Throwdown: Webinar Q&A

  • Yesterday (Oct. 22) I gave a presentation titled “MySQL 5.6 Full Text Search Throwdown.” If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I answered as many as we had time for during the session, but here are all the questions with my complete answers

3. Facebook MySQL database engineers ready for Percona Live London 2014

  • I spoke with Facebook database engineers Yoshinori “Yoshi” Matsunobu and Shlomo Priymak about their upcoming sessions along with what’s new at Facebook since our last conversation back in April.

4. Understanding the Execution Plan [When Table JOIN occurs Part-I]

  • In my previous article we are just using a single table as per our example is concern, Now in this article we are going to see the different table join each other’s and make a single data set by using JOIN.

5. Back to Learning Grammar with ANTLR

  • This post is going to be about language processing. Language processing could be anything like an arithmetic expression evaluator, a SQL parser or even a compiler or interpreter. Many times when we build user facing products, we give users a new language to interact with the product.


Now it's easier than ever to get started with MongoDB, the database that allows startups and enterprises alike to rapidly build planet-scale apps. Introducing MongoDB Atlas, the official hosted service for the database on AWS. Try it now! Brought to you in partnership with MongoDB.


The best of DZone straight to your inbox.

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.

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

{{ parent.tldr }}

{{ parent.urlSource.name }}