Calendar

Category Archives: MySQL

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.

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

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

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

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

As a developer I have often wanted to be able to test query speeds among other things. The problem is I didn’t always have a usable data set sitting around that could meet the requirements of my test cases. To make a long story short,

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

. 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

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

I have used many shared hosting providers throughout my years as a webmaster. Shared hosts have many great points, namely, price, and then they have their major drawbacks. For me, one of the major drawbacks is the limited use of the machine on which your