<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>puRe - FL3X - Marcel Oelke</title>
	<link>http://blog.fl3x.de</link>
	<description>Thats all me!</description>
	<lastBuildDate>Sun, 25 Apr 2010 02:53:53 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>Me on Soundcloud</title>
		<description><![CDATA[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 &#8211; Fameball by   marceloelke

Comments are always welcome, here or on soundcloud.
More of my productions [...]]]></description>
		<link>http://blog.fl3x.de/2008/11/12/me-on-soundcloud/</link>
			</item>
	<item>
		<title>Plusser.de ist online</title>
		<description><![CDATA[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 [...]]]></description>
		<link>http://blog.fl3x.de/2008/03/05/plusserde-ist-online/</link>
			</item>
	<item>
		<title>Who is the Subversion King in your Company?</title>
		<description><![CDATA[Have you ever wanted to know who&#8217;s the top committer in your company?
In my previous company we etablished the term &#8220;CVS King&#8221;, a title comparable to &#8220;Employee of the month&#8221;. The developer with the most cvs commits was the &#8220;CVS King of the month&#8221;. We determined who was the &#8220;CSV King&#8221; using commit emails that [...]]]></description>
		<link>http://blog.fl3x.de/2007/11/26/who-is-the-subversion-king-in-your-company/</link>
			</item>
	<item>
		<title>Record mouse movement using Javascript and AJAX</title>
		<description><![CDATA[I just found some piece of code i created one or two years ago. The &#8220;movelogger&#8221; 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 &#8220;replay&#8221; these movements [...]]]></description>
		<link>http://blog.fl3x.de/2007/10/18/record-mouse-movement-using-javascript-and-ajax/</link>
			</item>
	<item>
		<title>Random Timestamps in MySQL</title>
		<description><![CDATA[Have you ever needed a random timestamp in MySQL? For example to create demo data programmatically? Here&#8217;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 [...]]]></description>
		<link>http://blog.fl3x.de/2007/10/14/random-timestamps-in-mysql/</link>
			</item>
	<item>
		<title>How to name something that imports and exports ?</title>
		<description><![CDATA[Simple Question:
When a script/function/class exports something, I name it &#8220;exporter&#8221;.
When it imports something, I name it &#8220;importer&#8221;.
How do I name it when it does both?
What do you think? Write your thoughts into the comments please. Thanks!
]]></description>
		<link>http://blog.fl3x.de/2007/10/11/how-to-name-something-that-imports-and-exports/</link>
			</item>
	<item>
		<title>New minimal music</title>
		<description><![CDATA[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&#8217;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
]]></description>
		<link>http://blog.fl3x.de/2007/07/15/new-minimal-music/</link>
			</item>
	<item>
		<title>MySQL Performance: Use counter tables</title>
		<description><![CDATA[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 [...]]]></description>
		<link>http://blog.fl3x.de/2007/04/03/mysql-performance-use-counter-tables/</link>
			</item>
	<item>
		<title>MD5 Hash Database Update &#8211; Supports SHA1 Now</title>
		<description><![CDATA[<a href="http://md5.rednoize.com/"><img src="http://md5.rednoize.com/images/md5_logo_xs.gif" alt="md5.rednoize.com - md5/sha1 hash database" style="float: left;padding: 4px;border:0;" /></a><a href="http://md5.rednoize.com/">Md5.rednoize.com</a> 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 ;)]]></description>
		<link>http://blog.fl3x.de/2006/11/27/md5-hash-database-update-supports-sha1-now/</link>
			</item>
	<item>
		<title>MySQL: Collation matters when using unique indexes</title>
		<description><![CDATA[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.]]></description>
		<link>http://blog.fl3x.de/2006/11/26/mysql-collation-matters-when-using-unique-indexes/</link>
			</item>
	<item>
		<title>Chora Subversion Viewer Path Error</title>
		<description><![CDATA[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.]]></description>
		<link>http://blog.fl3x.de/2006/10/17/chora-subversion-viewer-path-error/</link>
			</item>
	<item>
		<title>Google likes md5();</title>
		<description><![CDATA[<a href="http://md5.rednoize.com/"><img src="http://pure.rednoize.com/images/md5_logo_50.gif" alt="md5.rednoize.com logo" style="float: left;padding: 4px;border:0;" /></a> At least on my monitor md5(); is visible on the first page without scrolling when <a href="http://www.google.com/search?hl=en&#038;q=md5&#038;btnG=Google+Search">searching for "md5"</a>. 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 <a href="http://pure.rednoize.com/images/google_likes_md5.gif">screenshot</a>.]]></description>
		<link>http://blog.fl3x.de/2006/09/03/google-likes-md5/</link>
			</item>
	<item>
		<title>Md5 Database Under Attack</title>
		<description><![CDATA[<a href="http://md5.rednoize.com/"><img src="http://pure.rednoize.com/images/md5_logo_50.gif" alt="md5.rednoize.com logo" style="float: left;padding: 4px;border:0;" /></a> The amount of the stored hashes on md5.rednoize.com has made a large jump in the last few days. The site in the <a href="http://www.google.com/search?q=cache:ey2reqMVDTEJ:md5.rednoize.com/+http://md5.rednoize.com/&#038;hl=en">google cache</a> (dated from 30 Aug 2006 19:49:32 GMT) counts 5,531,616 md5 strings.
The actual count is about 6,363,467.]]></description>
		<link>http://blog.fl3x.de/2006/09/02/md5-database-under-attack/</link>
			</item>
	<item>
		<title>Hiphop-Battles.com 2.0 finally online</title>
		<description><![CDATA[<img src="http://pure.rednoize.com/images/hiphop_battles_v2_001.jpg" alt="Hiphop-Battles.com 2.0 screenshot" style="float: left;padding: 4px;" />The most recent project i am working on, <a href="http://www.hiphop-battles.com">Hiphop-Battles.com</a>, went finally online today. My partners and me are working on this project for about 2 years now. The team consists of Eike Reifhardt (<a href="http://www.hiphop-battles.com/user/1111/">BioPhonC</a>) who made all the artistic stuff (web design, CI, and all other types of media), Michael Scheel (<a href="http://www.hiphop-battles.com/user/1003/">StarbuG</a>) who is the original founder of hiphop-battles.com and manages all the organizational stuff, and me (<a href="http://www.hiphop-battles.com/user/1027/">puRe</a>) 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 <a href="http://www.prweb.com/releases/2006/9/prweb430845.htm">official press release</a>.]]></description>
		<link>http://blog.fl3x.de/2006/09/01/hiphop-battlescom-20-finally-online/</link>
			</item>
	<item>
		<title>Dynamic Materialized Views in MySQL</title>
		<description><![CDATA[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&#8217;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 [...]]]></description>
		<link>http://blog.fl3x.de/2005/11/12/dynamic-materialized-views-in-mysql/</link>
			</item>
	<item>
		<title>Checking password strength using md5.rednoize.com and AJAX</title>
		<description><![CDATA[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 [...]]]></description>
		<link>http://blog.fl3x.de/2005/11/10/checking-password-strength-using-md5rednoizecom-and-ajax/</link>
			</item>
	<item>
		<title>Hamachi &#8211;  Secure Mediated peer to peer VPN</title>
		<description><![CDATA[
Hamachi is a piece of software that belongs to the very rare category &#8220;Double-click to install and it works&#8221;. If you ever wanted to build a &#8220;private&#8221; VPN, take Hamachi into consideration.
&#8220;Hamachi is fast, secure and simple. It is also free.&#8221; The client is available for Windows and Linux.
The Hamachi website describes how it works:
&#8220;Hamachi [...]]]></description>
		<link>http://blog.fl3x.de/2005/11/07/hamachi-secure-mediated-peer-to-peer-vpn/</link>
			</item>
	<item>
		<title>Materialized Views in MySQL</title>
		<description><![CDATA[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&#8217;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&#8217;s [...]]]></description>
		<link>http://blog.fl3x.de/2005/10/26/materialized-views-in-mysql/</link>
			</item>
	<item>
		<title>2,007,161 md5 strings</title>
		<description><![CDATA[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 [...]]]></description>
		<link>http://blog.fl3x.de/2005/10/26/2007161-md5-strings/</link>
			</item>
	<item>
		<title>MD5 Database</title>
		<description><![CDATA[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 &#8220;safe&#8221; uppon registration.
But actually this project is kinda useless i think. At least it was big fun to read posts like this [...]]]></description>
		<link>http://blog.fl3x.de/2005/05/28/md5-database/</link>
			</item>
	<item>
		<title>Sunday HipHop-Battles</title>
		<description><![CDATA[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&#8217;m just so uncreativ when it comes to naming stuff.
The tune has been [...]]]></description>
		<link>http://blog.fl3x.de/2005/01/05/sunday-hiphop-battles/</link>
			</item>
	<item>
		<title>Lorem Ipsum</title>
		<description><![CDATA[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 facilisi. Aliquam aliquet, dui eget [...]]]></description>
		<link>http://blog.fl3x.de/2004/11/21/lorem-ipsum/</link>
			</item>
	<item>
		<title>Hello world!</title>
		<description><![CDATA[Hi, this is my first post on my first Blog. I just installed this wonderfull piece of software.
I&#8217;ll write more later.
]]></description>
		<link>http://blog.fl3x.de/2004/11/19/hello-world-2/</link>
			</item>
</channel>
</rss>

