MySQL Tips & Tricks

Monday, November 19, 2007

Technorati the Specialist Blog Search Engine

I'm trying to get this blog registered with Technorati the Specialist Blog Search Engine.

I have to post this to show that I own the Blog

Technorati Profile

Labels: ,

Friday, November 16, 2007

PHPRunner saved me from a Nervous Breakdown!

We know we have to work cleverer rather than harder.

I was working on a large PHP/MySQL website where the specification kept changing. It was bad enough redesigning that data and recoding the PHP all the time. Fortunately by using PHPRunner I was able to rebuild the admin side each time in just minutes. Using PHPrunner you can build your PHP Pages (or ASP using ASPRunner) which allow you to search and list your records and subsequently create, modify or delete them. You know that tedious repetitive stuff.

I know PHPrunner can also build the Web side as well, but I haven't looked into that yet , but will let you know.

There is an evaluation version, download it and get hooked!

Download Here

Labels: ,

Wednesday, November 7, 2007

What Can You Store in a MySQL Database?

I used rely on flat text files and grep or Perl to store and retrieve my data. Increasingly I try and use MySQL for everything.

I use MySQL for all my logins,passwords,urls etc

I use MySQL as a code snippet stores, so every time I develop a useful reusable bit of Perl,PHP,HTML and even MySQL it gets stored in MySQL

Family History well that's obvious

They are all tables in one database so one quick datadump backs up all my information.