Flickr Backend

January 30, 2008 § Leave a comment

Early Flickr:

Flickr Architecture:

Advertisements

Digg Backend

January 30, 2008 § Leave a comment

Super Sizing YouTube with Python

January 29, 2008 § Leave a comment

By Mike Solomon

The Theory of Psyco

January 27, 2008 § Leave a comment

Below is the theory behind Psyco, the Just In Time(JIT) Compiler, for Python

Google Mondrian…

January 27, 2008 § Leave a comment

Is Guido Von Rossum‘s project at Google.

He created online code review application for Google’s internal use.

Google Mondrian uses:

Resource: 

LiveJournal Backend

January 27, 2008 § Leave a comment

August 2005: 

April 2004:

PHP annoyance: MySQL now() vs PHP time()

January 23, 2008 § 3 Comments

When your DBA is thinking differently than you, you might get:

MySQL

field: created_on

type: DATE

while, on PHP side:

$created_on = time();

Below is simple script that get rid of such annoyance.

From PHP to MySQL:

$created_on = date(‘Y-m-d H:i:s’, time());

From MySQL to PHP:

$query = “SELECT created_on FROM some_table WHERE id=1”;

$row = mysql_fetch_array(mysql_query($query));

$created_on = $row[‘created_on’]; //created_on from MySQL in DATE format

list($date, $time) = explode(‘ ‘, $created_on);

list($y, $m, $d) = explode(‘-‘, $date);

list($h, $i, $s) = explode(‘-‘, $time);

$created_on = mktime($h, $i, $s, $m, $d, $y); //created_on timestamp

Where Am I?

You are currently viewing the archives for January, 2008 at RAPD.