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? :)
Category Archives: Design
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.
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.