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

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.