Soundcloud.com is a really great site for producers and music lovers. You can listen to some of my tunes using their player here:
New: Lush Lush by marceloelke
Updated: RR

RR Track by marceloelke

MoboKoo

Marcel Oelke MoboKoo by marceloelke

Fameball

Marcel Oelke – Fameball by marceloelke

Comments are always welcome, here or on soundcloud.
More of my productions [...]

Seit kurzer Zeit ist das Projekt (Plusser), an dem ich arbeite, mit dem ersten Release online. Plusser.de ist ein Portal, das über den schlichten Community-Gedanken hinaus geht. Plusser.de soll die Startseite ins Internet für alle ab ca. 40 Jahren werden, da Plusser.de Spaß, Kommunikation und Lernmöglichkeiten miteinander verbindet. Obwohl im Zentrum des Portals der Erfahrungsaustausch [...]

Have you ever wanted to know who’s the top committer in your company?
In my previous company we etablished the term “CVS King”, a title comparable to “Employee of the month”. The developer with the most cvs commits was the “CVS King of the month”. We determined who was the “CSV King” using commit emails that [...]

I just found some piece of code i created one or two years ago. The “movelogger” records the mouse movement a users does on a web site. Just before the user leaves the current page, the recorded data get posted back to the server using AJAX.
The cool thing is that you can “replay” these movements [...]

Have you ever needed a random timestamp in MySQL? For example to create demo data programmatically? Here’s my solution:

SELECT FROM_UNIXTIME(
FLOOR(
UNIX_TIMESTAMP(‘2007-01-01′) +
RAND() *
(UNIX_TIMESTAMP(‘2007-01-03′)-UNIX_TIMESTAMP(‘2007-01-01′))
)
) as random_timestamp;

Or if you prefer a function:

CREATE FUNCTION random_timestamp (start TIMESTAMP, end TIMESTAMP)
RETURNS TIMESTAMP NOT [...]

Simple Question:
When a script/function/class exports something, I name it “exporter”.
When it imports something, I name it “importer”.
How do I name it when it does both?
What do you think? Write your thoughts into the comments please. Thanks!

Hey guys
Here are some of my latest tunes. I guess its something between minimal, electro and techno. None of these is finished 100% yet, but you’ll get the idea.
http://pure.rednoize.com/tunes/
By the way, the picture in the background is taken in my favorite club, the water gate in Berlin.
I appreciate any comments !
Thanks
puRe

I guess many of you know, that using SELECT count(*) FROM table is problematic and slow when using Innodb tables.
This actually only applies to COUNT(*) queries without WHERE a clause as mentioned in the MySQL Performance Blog.
But if you got some slow count query in your application the best way to increase its performance is [...]

Md5.rednoize.com has been updated yesterday. The web site features a new design and has gained support for sha1 hashes. The interface has been ajaxified and the amount of hashes stored in the database has been increased again. The database stores now about 35,000,000 md5/sha1 hashes with their plain text counterpart. And md5.rednoize.com got a new logo as well ;)

When using a uniqie index on a text field in mysql, the column collation setting is very important. The collation settings of a column does not only affect sorting and comparsion, but also unique indexes. So you can not insert “a” and “A” into a table that has a unique index on a column that has a case-insensitive collation.

Today i faced one of these problems that i really hate. I mean these kind of problems that are absolutly bogus.
Even google had no solution for this one handy. And thats why i am posting this solution, so that anyone that could have the same problem may find the solution a little bit faster.

At least on my monitor md5(); is visible on the first page without scrolling when searching for “md5″. So my page is on position 7 or 8 (depends whether you count php.net twice or not). Thats so awesome!
Oh .. and here is a screenshot.

The amount of the stored hashes on md5.rednoize.com has made a large jump in the last few days. The site in the google cache (dated from 30 Aug 2006 19:49:32 GMT) counts 5,531,616 md5 strings.
The actual count is about 6,363,467.

The most recent project i am working on, Hiphop-Battles.com, went finally online today. My partners and me are working on this project for about 2 years now. The team consists of Eike Reifhardt (BioPhonC) who made all the artistic stuff (web design, CI, and all other types of media), Michael Scheel (StarbuG) who is the original founder of hiphop-battles.com and manages all the organizational stuff, and me (puRe) who made all the web site programming, database layout and such things.

We’ve put a lot new features into the new version, which i will describe detailed in forthcoming posts.
For now you may read the official press release.

In one of my latest postings I mentioned a way to create semi materialized views in MySQL. The problem was that the solution required a stored procedure for every materialized view. That’s very annoying. So I looked for a more general and dynamic approach. The result is another stored procedure with 3 parameters:

the name for [...]

With some inspiration from Ben Ramsey i created a little demo for using my md5 database during the signup process on a website.
This example demonstrates the use of the MD5 database at http://md5.rednoize.com and AJAX to check password strength during signup on a website. After supplying a username and a password, a md5 hash of [...]

Hamachi is a piece of software that belongs to the very rare category “Double-click to install and it works”. If you ever wanted to build a “private” VPN, take Hamachi into consideration.
“Hamachi is fast, secure and simple. It is also free.” The client is available for Windows and Linux.
The Hamachi website describes how it works:
“Hamachi [...]

Update: Dynamic Materialized Views
Please read this article also. Its an improved versio of the technique described below.
Today i found a workaround for a feature that was realy missing in MySQL.
Let’s say you got a really complicated query that requires a lot of cpu and time to complete, but the resulting data is quite static. That’s [...]

Today i took a look at my md5 site and found out that i (we) broke the 2 million barrier. The database has now 2,007,161 md5 strings with their counter part stored. 222,101 queries where run against the database till now. The size of the database has grown to 320 MB on the [...]

I just did some work on my little MD5 project today. I added Plain and XML Output to http://md5.rednoize.com. For example some website could use this to automaticly check if a password is “safe” uppon registration.
But actually this project is kinda useless i think. At least it was big fun to read posts like this [...]