Found an article tonight: Why you Should be using PHP’s PDO for Database Access. Skimmed it. Plan to read the whole thing later.
Monthly Archives: October 2012
jQuery Templating Plugin
Today I learned about the jQuery Templating Plugin. Looks like something I’ll want to learn about!
Firefox prompting to download application x-trash from Apache2
I was changing a HTML file index.html to be a PHP file called index.php and I renamed my index.html file index.html.bak. The plan was that Apache would find index.php rather than index.html and serve that as the default page. But when I went to load my page Firefox was asking me if I wanted to save the file with MIME type application/x-trash — not what I was expecting! It turns out the problem was related to the index.html.bak file, apparently Apache had decided that was the default page and then when it tried to get the MIME type for .bak it came up with application/x-trash. So the solution was to move the index.html.bak file to something with a filename that didn’t begin with ‘index.html’ (I used ‘original-index.html’) and then once that file had been renamed the index.php page was served properly.
MySQL modify column syntax
I needed to modify some columns on a MySQL table today and found myself having to lookup the syntax and found this article which explains it.
PHP parse_url
I learned about the PHP parse_url function today. I’ve wasted a lot of time not knowing about that!
A fast and furious guide to MySQL database engines
Read an article today called A fast and furious guide to MySQL database engines which talks a little bit about how MySQL database engines work.
One thing I learned which I didn’t know before is that you should run OPTIMIZE TABLE from time to time on your MyISAM database tables.
Database Sharding
Read an article about Database Sharding from CodeFutures.
Wikimedia’s servers
Was doing some research into scaling web applications and came across this diagram of Wikimedia’s servers.
Generating waiting or page loading icons
Found preloaders which is a web site that can generate a ‘waiting’ icon for use in your web project.
Portable PHP password hashing framework
Learned about the Portable PHP password hashing framework today.