MySql

SQLyog

SQLyog

I wish I had found this software a long time ago. It’s a lot easier to use that MySql’s own GUI’s. This and DB Designer 4 is all you need. Even MySql’s own data modeling tool is only in a beta version and it won’t run on my computer. Always throws errors. I am now syncing a local and remote database as I type.

Drupal

drupal.org | Community plumbing

I have yet to use Drupal for a site, but a list of successful sites using the software shows me I might need to look into Drupal. Users have contributed everything from ecommerce packages to themes to make the software universal for any need you might happen to have.

Removing MySql Table duplicates

After hunting around looking for a solution to help me get this accomplished for a database of over 100,000 rows. I found the simple method linked to below.

tip : remove mysql table duplicates – mysql magic

An addition to my last post.

MySQL Connection Management in PHP – How (Not) To Do Things – Jay Pipes

Only recently studying Object Oriented PHP, I need to learn some new tricks and this article is a great help in not pissing off a hosting provider.