1. Start Transaction on database1
2. Clear out some old data from the table
3. Select a bunch of data from database2.table
4. Loop in PHP, updating each row in its own query to update one column
5. Select a bunch of data from database2.other_table
6. Loop in PHP, updating each row in its own query to update another column
7. Commit database1

1. Create temp table on database2 to hold mydata
2. Select data from database2.table into my temp table
3. Select data from database2.other_table into my temp table
4. Move my temp table using extended inserts via PHP from database2 to database1
5. Start Transaction on database1
6. Clear out some old data from the table
7. Do a multi-table bulk update of my real table using the temp table
8. Commit database1

Back in the day, when URLs and filesystems had a 1:1 mapping, it made perfect sense to have a web server separate from the language it is running. But, nowadays, any PHP app with attractive URLs running behind the Apache web server is going to need a .htaccess file, which tells the server a regular expression to check before serving up a file. Sound complex and awkward with unnecessary overhead? That’s because it is.

Node has a web server built in. Some people call this a bad thing, I call those people crazy. Having the server built in means that you don’t have the awkward .htaccess config thing going on. Every request is understood to go through the same process, without having to hunt through the filesystem and figure out which script to run.

The official website is quite ugly and outdated.

Since a PHP process starts, does some boilerplate work, performs the taks the user actually wants, and then dies, data is not persistent in memory. You can keep this data persistent using third party tools like Memcache or traditional database, but then there is the overhead of communicating with those external processes.

The number one bottleneck with web apps is not the time it takes to calculate CPU hungry operations, but rather network I/O. If you need to respond to a client request after making a database call and sending an email, you can perform the two actions and respond when both are complete.

Node.js is a very new, unstable, untested platform. If you are going to be building a large corporate scale app with a long lifetime, Node.js is not a good solution. The Node API’s are changing almost daily, and large/longterm apps will need to be rewritten often.

Being so new, it doesn’t have a lot of baggage leftover from days of old. Having a server built in, the stack is a lot simpler, there are less points of failure, and there is more control over what you can do with HTTP responses (ever try overwriting the name of the web server using PHP?).

• Are you building some sort of daemon? Use Node.
• Are you making a content website? Use PHP.
• Do you want to share data between visitors? Use Node.
• Are you a beginner looking to make a quick website? Use PHP.
• Are you going to run a bunch of code in parallel? Use Node.
• Are you writing software for clients to run on shared hosts? Use PHP.
• Do you want push events from the server to the client using websockets? Use Node.
• Does your team already know PHP? Use PHP.
• Does your team already know frontend JavaScript? Node would be easier to learn.
• Are you building a command line script? Both work.

The only thing that is *never* on the table is using a Windows server. If you can get me unique visitors for an arbitrary date range in milliseconds and it require Hadoop, go for it.

I know you will ask how our dev db works, here you go:

1. Replicate production over VPN to home office

2. Write MySQL data on SAN

3. Stop replication, flush tables, snapshot FS

4. Copy snapshot to a new location

5. On second dev server, umount SAN, mount new snapshot

6. Restart MySQL all around

7. Talk in dev chat how bad ass that is

<?php



$date = "2011-11-01";



// add 15 days



$new_date = date("Y-m-d", strtotime($date) + (86400 * 15));



// $new_date should be 2011-11-16 right?



echo $new_date;



?>

$new_date = date("Y-m-d", strtotime($date." +15 days"));

$new_date = date("Y-m-d", strtotime($date." 12:00:00") + 86400 * 15);

if(defined("STDERR") && posix_isatty(STDERR)){

    ini_set("log_errors", false);

    ini_set("error_log", null);

}