Browse By

Category Archives: MySQL

Performance Tuning Best Practices for MySQL – Google TechTalks

I was scouring the web for some MySQL tips, tricks, and documentation to help me as I work on the blog and other development projects. Tuning is often times overlooked; sometimes once the database table structure is built and normalized, development stops there. I am trying to be more conscious of that and during my research I came across a performance tuning video published by Google during one of their Google TechTalks.

No Thumbnail

MySQL Field Types Cheatsheet

If you have been using MySQL for your database choice, you’ll probably find this cheatsheet to be pretty useful. Whether you are new to MySQL or advanced, this is pretty handy to have around. A help page on help.scibit.com offers a great breakdown of the

No Thumbnail

phpMyAdmin 3.1.0 Relesased

For those of you that are as hooked on phpMyAdmin as I am, you will be happy to know that there is a new version available. phpMyAdmin 3.1.0 includes a number of improvements and fixes. The list of improvements includes security updates, language updates, export

No Thumbnail

How In-Demand Are Your Skills?

Have you ever wondered if your skills are in demand? With so many different possibilities available for web development, it is tough to know if you should keep mastering a specific technology or start learning a new one. After reading an article about how PHP

No Thumbnail

Free Online Tech Books from Techotopia

Techotopia offers free online books that cover a number of subjects including programming languages, security,  and Linux. The books are hosted on their wiki and are available to read online. The four main books that brought me to this site are: PHP Essentials MySQL Essentials

No Thumbnail

All-In-One Web Server Installation Packages

A traditional web server is made up of many different components, including an http server, mail server, FTP server, and more. In days gone by, a webmaster would install each software package individually to get a custom web server up and running. These kinds of

No Thumbnail

phpMyAdmin 2.11.8.1 Released Yesterday

. phpMyAdmin 2.11.8.1 was released yesterday. The main reason for the updated release is to patch bugs and security issues. There were some XSS problems reported by Aung Khant from the YGN Ethical Hacker Group. The two main fixes are both XSS related, one having

No Thumbnail

SQL Speed Test: IN vs OR

Speed and efficiency are key factors when running a website. All code needs to be optimized, whether it is PHP, ASP, Python, or SQL. Internet users are notorious for having a low attention span, and a fast page load will help to keep their attention