I’ve been working on an SQL sugar. Here’s a screenshot of it colouring a database backup:
http://www.fileability.net/downloads/SQLSugar.png

I’ll upload the actual sugar later today when it’s a bit more polished.

EDIT:
Download the SQL sugar:
http://www.fileability.net/downloads/SQLSugar.zip

It needs to be put in ~/Library/Application Support/Espresso/Sugars/

Seems to be a problem with that link but a SQL sugar is certainly going to be useful. Be very interested to see this one personally.

Oh damn, screencast.com has gone down for some reason. Here’s another link (post updated):
http://www.fileability.net/downloads/SQLSugar.png

Hey that one works. Very cool beans.

OK, I think this is about ready enough for a first release. I need to add loads more keywords but it’s certainly useable at least.

Download the SQL sugar:
http://www.fileability.net/downloads/SQLSugar.zip

It needs to be put in ~/Library/Application Support/Espresso/Sugars/

EDIT: I’ve just noticed that I forget to change a few selectors ending in .js to .sql. Shouldn’t affect the usage of the sugar.

Release 2

New:
  • Rewritten using XML
  • Now in bundle format
  • More keywords + functions + constants
  • Some basic codesense

Download: fileability.net/downloads/SQL2.zip

This sugar is looking good.  Espresso is really starting to replace Textmate for me now.  One thing I’ve noticed is that inline in PHP, the SQL highlighting works fine for normal strings, but when I have a string encapsulated with ’<<<EOQ’ and ‘EOQ;’, no formatting occurs.

I’ve attached a screenshot showing a working and non-working example.

That’s a problem with the PHP sugar not supporting heredoc, not the SQL sugar.

OK, I’ll re-post it there then.

Less Confusion - More info - Which one is the updated one? The one in the first post or the one further down.

... generally keep the first one the most updated?

Usually Sugar devs keep the link in the first post the most updated, but in this case I’d recommend just getting it from GitHub:

http://github.com/fileability/sql.sugar/

Since it doesn’t have any special compiled portions, you can just use GitHub’s project downloading, unzip it, rename the folder SQL.sugar if necessary, and install it.

how would you setup syntax coloring for the following part of a mysql command inside a .php file:

mysql_query(“UPDATE table SET field1=’$value1’”)

OR

mysql_query(“UPDATE table SET field1=’$value1‘“)

Right now everything except ‘UPDATE’ is the same color and so syntax coloring perks don’t apply to the code :/

It depends; if the SQL already has syntax zones defined for it you might be able to just add some rules to your theme’s CSS in order to add coloring. If there aren’t zones defined, though, you’ll need to modify the SQL sugar to add them.

You can figure out if the zones are already there by choosing Actions->Show Syntax Inspector and sticking your cursor in the text that you want to see the syntax zone for.