Accessing Sphinx as a Database

Sphinx is a popular open source full text indexing engine which can be used to greatly improve search functionality over the full-text search options available in most databases. While adding this to the search function of a site recently, I stumbled upon some neat tricks that I would like to share with you.

Table Locking for Dummies (MySQL)

Writing a multi-threaded program is hard enough to do without having to worry about data concurrency in your database. Lucky for us, MySQL has the methods necessary to help us keep our data current built in. There are two main kinds of locks supported by MySQL, table-level locks and row-level locks. Table-level locks are supported… Continue reading Table Locking for Dummies (MySQL)

Categorized as Database

Oracle and Apache Square Off

Oracle, the database giant, has given notice that the Java development Kit 7 (JDK7) will be available for the general public on July 28, 2011. This includes several improvements to the java language that will be implemented by the new release. At the same time, Oracle also submitted specs for the next iteration, Java 8.

Categorized as Java