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.

Derek Adair

Posted 2010-02-04T18:36:03.550

Reputation: 355

Answers

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.

Josh K

Posted 2010-02-04T18:36:03.550

Reputation: 11 754

I used textmate... I like Coda better for its project management functionality. I'll definitely check out the others (x11 == terminal) – Derek Adair – 2010-02-04T18:47:27.457

Code is better in a "this is your project" sense, but it tries to cram too much stuff in there at once. It has a lackluster editor, and the rest of the features just fell short for me. The "Publish" feature was the only thing I missed moving to TextMate full time. – Josh K – 2010-02-04T18:48:39.437

wow. This is the EXACT same list I use with the exception of Cornerstone and SmartCVS (I use git). – macek – 2010-02-05T22:53:38.697

Never tried GIT, how is it? – Josh K – 2010-02-06T04:13:23.020

DON'T FORGIT GIT.

/me ducks

http://git-scm.com/

macek

Posted 2010-02-04T18:36:03.550

Reputation: 5 157

Another vote for Sequel Pro for MySQL stuff. For SVN, I can recommend Versions. It's not free, but it makes SVN a breeze to use and works nicely along side Coda.

Garry

Posted 2010-02-04T18:36:03.550

Reputation: 457

I've only just opened sequel pro and I already love it =) – Derek Adair – 2010-02-15T16:17:06.053

For MySQL browsing I highly recommend Navicat. I do extensive PHP/MySQL development and I couldn't live without it.

Paulo

Posted 2010-02-04T18:36:03.550

Reputation: 1 400