Xarg - xarg.org - Code is poetry
General Information:
Latest News:
Running Standard Deviation in MySQL 19 Aug 2012 | 06:41 am
Calculating the standard deviation in MySQL is a no-brainer by using the build-in aggregate function STDDEV(). If you don't need the original data and only want to save aggregated values in your datab...
Optimal index size for variable text in MySQL 17 Jul 2012 | 01:58 am
You often see databases with huge dynamic text fields, such as VARCHAR(255), TEXT, or as I recently was allowed to see the blanket use of LONGTEXT (max 4GiB) in order to be invulnerable from all conti...
Statistical functions in MySQL 14 Jul 2012 | 09:39 am
Even in times of a growing market of specialized NoSQL databases, the relevance of traditional RDBMS doesn't decline. Especially when it comes to the calculation of aggregates based on complex data se...
MySQL Infusion UDF for statistical analysis 12 Jul 2012 | 09:39 am
Since I use MySQL for the statistical analysis on a project, I wanted to optimize the database queries and learned a lot about stuff like number theory, set theory and partial sums. I took my MySQL UD...
What I would change if I were the CEO of Spotify 6 Jul 2012 | 03:38 am
Since March, I can use Spotify officially in Germany, and also do this extensively every day. Albeit, from my initial exuberant joy on the new toy is not much left after nearly two months of use. I fr...
Flag based COUNT using MySQL 27 Oct 2011 | 11:45 pm
I was asked for help in optimizing a MySQL query where flags are stored in a database and references should be counted based on the flag value. Sounds not complicated at first, but there are several f...
Optimized Pagination using MySQL 24 Oct 2011 | 11:45 pm
Dealing with large data sets makes it necessary to pick out only the newest or the hottest elements and not displaying everything. In order to have older items still available, Pagination navigation's...
Optimized trend analysis 27 Sep 2011 | 10:43 am
If you look at the number of visitors of your website, you can only take the data of the previous days for a serious analysis. In itself logical, but it would also be desirable to know which traffic y...
jQuery Pagination revised 4 Sep 2011 | 11:10 pm
There are many nasty pagination implementations and certainly sooner or later I've also written such a cruelty. That's why I've been working on a generalized solution for long in order to combine the ...
Faster PHP behind FastCGI 10 Jun 2011 | 06:00 pm
A few years ago, Jan Kneschke came up with the idea of using lighttpd's X-Sendfile to send dynamic content without copying it several times. I liked the idea and used it as basis of my framework. It s...
