Free Django Hosting

Are you looking for free hosting for your Django project? Here its some of very rare free Django hosting I found on net.

-DotCloud
-RXName
-Bitnami
-alwaysdata
-Google AppEngine

I have not try those web hosting above, except Google AppEngine. So, I can't give you review for each of them. However, Google AppEngine is very complicated, especially because they don't support RDBMS. Django developer may use Django-nonrel.

Wordpress MU: Error Establishing Database Connection Issue

I get problem while creating new blog on my Wordpress MultiSite (WPMU). The screen only show Error establishing database connection, see figure below.

5 CSS resources

Here its 5 (and counting) CSS resources I found while learning web design:
-Sitepoint specific CSS hacks will introduce you some hack for, you guess it, Internet Explorer.
-960.gs, CSS framework for creating layout fast.
-Alistapart tutorial on basic structural/page layout with CSS. Old-school, dated 2001, but still informative stuff. Alistapart also your good resource in web development.
-Dynamic Drive, JavaScript and CSS huge practical examples.
-w3school, provide interactive CSS learning, you can learn each CSS command directly on their website.

Ok, I will update this post for more interesting CSS game.

How To Create Wordpress Theme from Scratch #4

We come to the most interesting part of Wordpress theme system, the content of our blog itself. In Wordpress, content of blog is stored in posts table. This table is mapped in Wordpress object the_posts(). Open our content.php then change it to make it like code below:

How To Create Wordpress Theme from Scratch #3

We will learn Wordpress code to generate dynamic data, in this post we focus on header section of our template. There are some critical part of our web page that you must aware, especially in page that generated dynamically by Wordpress, or PHP in general.

How To Create Wordpress Theme From Scratch #2

We've successfully create our first Wordpress theme. Actually, we didn't create real theme, that just static HTML and CSS that identified as theme by Wordpress. Now, we will make that static script to become real Wordpress theme.

How To Create Wordpress Theme From Scratch

Wordpress is popular bloging platform that evolve into self-publishing-site platform. And you may be wonder how to create Wordpress theme. I share my experience learning Wordpress theme here.

PHP array() syntax into Python

Here are some comparison PHP array() into Python. In Python, there are list, dict and tuple -- or sequence in general -- as data structure format.

Create RSS Agregator with SimplePie and CakePHP

Here it's my experiment creating RSS agregator using CakePHP and SimplePie. This code I found here, but I write again with some fixes for CakePHP 1.3.

Delete data in MySQL Older than x days

Deleting data in MySQL that older than [x] specified time. MySQL has INTERVAL to specified MINUTE, HOUR, DAY and YEAR.

If data type is MySQL Timestamp, Datetime:

DELETE
FROM my_table 
WHERE time_created < (NOW() - INTERVAL 10 DAY);

If data type is UNIX Timestamp:

DELETE
FROM my_table 
WHERE time_created < (UNIX_TIMESTAMP() - 600);
Note that UNIX Timestamp in second, statement above meaning 600 seconds => 10 minutes