When Panic first released Coda, the all-in-one web development application, I was quite skeptic to the entire concept of all-in-one solutions.
I have a workflow currently using BBEdit from Barebones for coding HTML and PHP. It's always been a premier first choice for developers on the Mac. I am using projects, clippings, applescript, unix script text filters and tons of other stuff tailored to my specific needs, and it supports the bbsftp protocol (see the note on Interarchy below).
Espresso from Macrabbit for CSS editing which replaced their CSSEdit application. Espresso is, like Coda an attempt at an all-in-one coding application, but I'm only using it for CSS editing. I liked CSSEdit more, but it's out of development and Espresso has support for more CSS goodies.
Sequel Pro for SQL queries, and I am suspecting that the code from Sequel Pro is the same one that Panic is using in Coda because they are strikingly similar. It's an amazing SQL editor/client in either case.
Interarchy for SFTP, mostly because it has this amazing protocol named bbsftp that I LOVE and depend on on a daily basis, I wrote about it here.
One thing I really like in BBEdit is the way it handles projects. You create a new project and can add files and folders to it, pretty much creating links to specific parts of a file hierarchy relevant to the project. Most projects I handle deal with a mix of some site-specific and some global resources. These are never in the same file-tree and the ability to just drag in the resources needed is golden.
BBEdit even handles SFTP links in these projects. So I can drag and drop file references from Interarchy instead of the Finder. Unfortunately, BBEdit does not support remote SFTP folders this way, so I need to manually add each file in a folder if I want to use it this way.
Coda has a slightly different approach to this, which is evident in that they don't call it "Projects", they call it "Sites", and when you create a new one you specify the remote path to the site. Well, that works for me some one time out of ten, but most of the times, I have several projects relevant to one site, each having a different set of files/folders relevant to it. Coda has grown from Panics Transmit, which is a FTP/SFTP client so the focus of a single remote directory is understandable, but unfortunate.
I had hoped that Coda could handle this using its "Favorites" sidebar part, but alas, it seems broken out of the box. First, you can't drag files there, only folders. So it's really a place to put favorite folders. I suppose I could live with that, but worse was that for some reason, this isn't saved between sessions. Surely that's a bug, but it's a bad one.
BBEdit projects are files with the extension ".bbprojectd". I keep these in a folder in my DropBox so they are always synced between home and work. The only problem here is the aforementioned inability to add SFTP folders to a project, and the remote host doesn't always mount nicely on my home computer for unknown reasons.
Coda has iCloud support where it syncs my projects, which is very handy. But without the project management I need, that doesn't help it enough. Plus, the iCloud syncing only works between Coda 2 on the Mac, it doesn't sync them to Diet Coda on the iPad. Granted, BBEdit has no way to do that either, and Panic seems to say it's on its way but that was several months ago, so I don't know.
But I really want to like Coda, it has a great full screen mode where BBEdit has a really crappy full screen mode. I like the idea of consolidating my terminal, CSS, file transfers and SQL queries per project (uh, sorry, "Site"), and in spite of having so much functionality, Coda 2 is really lightweight and snappy