Mac compatible Web-Development Tools

I'm looking for any Mac compatibile development tools that are tried and tested.

I'm quite sick of my MySQL query browser crashing... And i'm sure there is probably better software out there anyways...

At the moment my focus is dedicated to application development using PHP/MySQL/Ajax. (although, I will be learning ActionScript/Flex shortly).

Here are the apps I regularly use and a general idea of the environment I work in:

Hosting -
   localhost: Mamp
   Production: Amazon EC2

IDE -
   Coda: PHP/Mysql/Javascript

Mysql -
   PHPMyAdmin
   MySQL query browser

FTP -
   Coda
   FileZilla

X11 is used for connecting to my production environment

I am mainly looking for...

-tools that will help me better manage (create, edit... whatever) databases.
-Version control.  This is huge as I'm working with a team of three other developers (we reeeeeeaaally need to standardize our environments..)

Although any cool little tools to make my job easier are always a plus!

I am unable to insert more than one link as I'm not rated on this forum.


I use the following extensively:

TextMate is a fast and easy to pick up text editor that handles every syntax I've ever used (PHP, MySQL, Perl, Ruby, Python, Java, CSS, and more). With bundles and keyboard shortcuts it greatly speeds up the time it takes to code.

Cornerstone or SmartCVS for SVN / CVS respectively.

Transmit for FTP. Tight Mac OSX integration and good speeds make this one a winner.

CoRD for remote desktop on IIS boxes.

Terminal for ssh and anything I can't do with another program in including tailing logs and grep.

Changes for file diff / merge.

Sequel Pro if I don't want to use phpMyAdmin for database manipulation.

For version control I recommend SVN over CVS. It's smarter, faster, less prone to errors and conflicts, and easier to understand for the beginner. There are a variety of SVN hosts but I find Slik SVN to be a great free host.


DON'T FORGIT GIT.

/me ducks

http://git-scm.com/