macOS SQL Quicklook Plugin

[anonmill]

I don't know if this is the right forum to post this in, but does anyone know of a SQL Quicklook Plugin? I am not after anything fancy, even just showing the text of a *.sql file would be good. Anything beyond that would be gravy (i.e. syntax highlighting). I have looked around some, but haven't found anything. I found some great ones for Zip files, Java files, etc. though.

I have some programming experience, though none for native Mac stuff. Is it hard to write one that would just grap the text from the file and show it?

Thanks!

 

[iSee]

Here's a trick you could try to get .sql files to open with the plain text quicklook generator (I haven't tried this myself):

http://www.macosxhints.com/article.php?story=20071028184428583

 

[anonmill]

Thank you!!

Following those instructions appears to have worked. In fair warning to others who may come across this however, I have done little testing beyond seeing that it worked initially. So I don't know yet if there are any crazy side affects. If anyone is interested, I followed the instructions but used TextWrangler. I added this to the Info.plist:

 <key>UTExportedTypeDeclarations</key>
  <array>
    <dict>
      <key>UTTypeConformsTo</key>
      <array>
        <string>public.text</string>
        <string>public.plain-text</string>
      </array>
      <key>UTTypeDescription</key>
      <string>SQL Code</string>
      <key>UTTypeIdentifier</key>
      <string>com.barebones.textwrangler</string>
      <key>UTTypeTagSpecification</key>
      <dict>
        <key>com.apple.ostype</key>
        <string>TEXT</string>
        <key>public.filename-extension</key>
        <array>
          <string>sql</string>
        </array>
      </dict>
    </dict>
  </array>

Immediately before:

</dict>
</plist>

I then issued this from terminal to make the changes take affect:

touch /Applications/TextWrangler.app

 

[jeffreykennedy]

Watch for competing (and now dead) apps being engaged by QuickLook

Head's up. I was trying to get TextMate to handle some SQL file types like .sql, .pks and .pkb (those last 2 are specific to Oracle). I could get .pks and .pkb to get recognized by QuickLook, but not .sql.

Turns out, at some point I tried out Froq. I deleted the app, but not some of the other files associated with it. QL was trying to engage Froq to handle .sql, not TextMate. All I saw was a generic QL icon for .sql files. After I deleted the final remnants of Froq, QL started using TextMate. All's well.

Peace.