Archive for the tag 'qKAI'

increasing productivity – part 2: Subversion

These days about every adept in software engineering knows what version control (VC) is: A tool to commit changes into remote repositories. It is seen as replacement for some sort of postal system, where the source code is literally sent to a superior or customer.

But there are more aspects to know about it, which I am going to write a about taking Subversion (SVN) as an example. One of it is lowering the barrier of committing code and enabling to maintain flow. Read more »

MySQL native function implementation of FNV hash (and others)

MySQL does not support HASH index for several storage engines. The common practice is to emulate them by creating an additional row and maintain it by triggers.

For reasons described below I’ve re-implemented FNV1 and FNV1A 64bit for MySQL – as native functions (performance of MySQL UDFs vs. native functions at kazuho’s blog). To round out the mix I’ve added MurmurHash2, 64A and 64B.

Download the MySQL native functions here.

Read more »

increasing productivity – part 1: Maven

One of the most important challenges to face first is leveraging developers’ time for maximum efficiency. At qKAI this is especially due to students, writing their theses, contribute to the code base. Therefore we have established several tools to spare them redundant work, maintain a constant code quality and automate the build.

This time I will write about Maven, Read more »

MySQL with Sphinx storage engine

mysql-sphinx

Today I’ve launched Visual Studio 9 2008 and compiled Sphinx, the full-text indexer, as storage engine into MySQL. I’ve limited my effords to the latest 64bit Windows version, because compiling under Linux is with GCC rather trivial.

MySQL 5.1 with SphinxSE for 64bit Windows can be downloaded here.

Just replace your original MySQL files by these from the zipfile.