http://blog.fl3x.de Thats all me! Sat, 31 Oct 2009 13:14:50 +0000 http://backend.userland.com/rss092 en Soundcloud.com is a really great site for producers and music lovers. You can listen to some of my tunes using their player here: Updated: RRRR Track by marceloelke MoboKooMarcel Oelke MoboKoo by marceloelke FameballMarcel Oelke - Fameball by marceloelke Comments are always welcome, here or on soundcloud. More of my ... http://blog.fl3x.de/2008/11/12/me-on-soundcloud/ 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 ... http://blog.fl3x.de/2008/03/05/plusserde-ist-online/ 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 ... http://blog.fl3x.de/2007/11/26/who-is-the-subversion-king-in-your-company/ 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 ... http://blog.fl3x.de/2007/10/18/record-mouse-movement-using-javascript-and-ajax/ 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 ... http://blog.fl3x.de/2007/10/14/random-timestamps-in-mysql/ 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! http://blog.fl3x.de/2007/10/11/how-to-name-something-that-imports-and-exports/ 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 ... http://blog.fl3x.de/2007/07/15/new-minimal-music/ 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 ... http://blog.fl3x.de/2007/04/03/mysql-performance-use-counter-tables/ 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. ... http://blog.fl3x.de/2006/11/27/md5-hash-database-update-supports-sha1-now/ 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 ... http://blog.fl3x.de/2006/11/26/mysql-collation-matters-when-using-unique-indexes/ 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 ... http://blog.fl3x.de/2006/10/17/chora-subversion-viewer-path-error/ 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. http://blog.fl3x.de/2006/09/03/google-likes-md5/ 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 ip 24.141.55.x has added about 400,000 plain text strings ... http://blog.fl3x.de/2006/09/02/md5-database-under-attack/ 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 ... http://blog.fl3x.de/2006/09/01/hiphop-battlescom-20-finally-online/ 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 ... http://blog.fl3x.de/2005/11/12/dynamic-materialized-views-in-mysql/ 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 ... http://blog.fl3x.de/2005/11/10/checking-password-strength-using-md5rednoizecom-and-ajax/ 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 ... http://blog.fl3x.de/2005/11/07/hamachi-secure-mediated-peer-to-peer-vpn/ 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 ... http://blog.fl3x.de/2005/10/26/materialized-views-in-mysql/ 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 ... http://blog.fl3x.de/2005/10/26/2007161-md5-strings/ 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 ... http://blog.fl3x.de/2005/05/28/md5-database/ A new tune from me that i produced exclusively for HipHop-Battles can be found on the site under Beats / Loops (you need to signup and login there to see that menu entry). Its called Sunday. Not for any particular reason. I'm just so uncreativ when it comes to ... http://blog.fl3x.de/2005/01/05/sunday-hiphop-battles/ Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus sem erat, sollicitudin vitae, auctor ac, aliquet lobortis, enim. Nam quis mi. Maecenas nibh quam, convallis et, placerat quis, mollis eu, tortor. Quisque posuere quam lobortis felis. Suspendisse facilisis dolor ut ipsum. Duis feugiat augue nec nunc. Maecenas ut justo. Nulla ... http://blog.fl3x.de/2004/11/21/lorem-ipsum/ Hi, this is my first post on my first Blog. I just installed this wonderfull piece of software. I'll write more later. http://blog.fl3x.de/2004/11/19/hello-world-2/