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.
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)
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.
When I chose to learn how to code in Java, one of the biggest factors that played into that decision was the fact that it compiles into bytecode, which can be run on any machine with the Java Virtual Machine (JVM) running on it. I wanted to be able to write programs for friends to… Continue reading Java Program Distribution with JAR Files