Apparently the autocomplete attribute is now supported in HTML5.
Category Archives: Design
Smallest 1×1 pixel transparent GIF image
Looking for a small 1×1 pixel transparent GIF image to use in your website? Here is a 1×1 pixel transparent GIF image. You could use a transparent PNG instead, but then the file size would be bigger, so why would you do that? :)
How many requests per second does a load balancer support?
I’m working on an application that is going to need to scale, and I haven’t done this before. One of the things I wanted to know what how many requests per second I could expect a single load balancer to support. I found this article Benchmarking Load Balancers in the Cloud which says that on average you can get about 5000 requests/sec through a load balancer.
SEO Best Practices for URL Structure
Read this article SEO Best Practices for URL Structure this evening and learned to use no more than 3-5 words in your URL as according to Google’s Matt Cutts if there are more than 5 words Google algorithms typically will just weight those words less and just not give you as much credit.
Are Prepared Statements a waste for normal queries? (PHP)
I was interested to know if using prepared statements was a waste of time if the statement was only going to be used once. I found Are Prepared Statements a waste for normal queries? (PHP) on StackOverflow and basically came away with the understanding that it’s a pretty low overhead and it’s good for security so you might as well use prepared statements all the time.
PHP Best Practices
Found a great article today! PHP Best Practices.
To use mysqli or PDO?
I’m trying to make my mind up about whether I should be using mysqli or PDO for a project I’m just starting and I’ve found a few relevant articles:
- PDO vs. MySQLi: Which Should You Use?
- mysqli or PDO – what are the pros and cons?
- When to use MySQL, MySQLi, or PDO in PHP
- Should I use mysql, mysqli or PDO?
- Why you Should be using PHP’s PDO for Database Access
- Not Convinced PDO is Everything It’s Hyped Up to Be
- PHP Driver: MySQL vs MySQLi vs PDO MySQL
- PHP mysqli overview
- The diffrence beteen PHP’s PDO bindParam & bindValue
- PHP, PDO, MYSQLI opinions please
And based on all of that I think I’ve decided to use PDO.
jQuery Templating Plugin
Today I learned about the jQuery Templating Plugin. Looks like something I’ll want to learn about!
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.