I found a great visual database design tool, DBDesigner 4, to help with creating databases. DBDesigner is an Open Source project and is published under GNU GPL, So that is great!
I've been using the software for a couple of weeks now and have found it very useful. It has actually helped me learn a bit more about indexes …
[Read more...]
Visual Database Design Tool, Like Visio
June 5, 2006 by 4 Comments
Web Development Cheat Sheets, Must Haves
June 25, 2005 by 2 Comments
Today I found a site that offers great web development cheat sheets!
There is MySQL, mod_rewrite, CSS, PHP and RGB Hex color chart. All great to have, I hope to print them out on the nice color laserjet at work!
I know the MySQL one will be helpful for reminding me the MySQL data types, the PHP one will be great …
[Read more...]
New Lines to Paragraphs PHP Function
May 25, 2005 by Leave a Comment
This is a great php function, written by Matthew Mullenweg, that will format text that has been pulled from a MySQL database so that it is displayed with HTML paragraph tags.
The function will replace new lines/carriage returns or even HTML line breaks with the paragraph tags, within the given string.
I have used …
[Read more...]
First Letters SQL Statement
May 25, 2005 by Leave a Comment
Here is a neat SQL statement that will return a recordset that counts the number of records that start with a particular letter.
I do have a good use for this that I need to implement. It was created by Matthew Mullenweg, the creator of Wordpress.
First Letters Query …
[Read more...]
InnoDB MySql
April 26, 2005 by Leave a Comment
Got an email today from Bam4D & he mentioned InnoDB. I did a little google on it, wait, that sounds horrible. So i googled it and found that it is a MySQL table type that can have many advantages over the other types of MySQL tables.
When designing tables in the past, I have never changed the table type. I have known …
[Read more...]
