Two things I miss from BB:
a) Opening/saving directly by FTP/SFTP (not going through Transmit, Interarchy, etc) b) "show invisibles"!!! I know this has been asked for already... I just wasted 10 mins on a file where 2 spaces were emulating a tab; partly my fault (confused about Tab Emulation) but show invisibles would be great...
Otherwise I'm loving it. The recent HTML-PHP syntax coloring seems better, or is that my imagination :) I found myself running MySQL queries directly in TM... cool! Just think of the possibilities with a macro :)
Paul
On Nov 2, 2004, at 12:53, Paul Nordstrom August wrote:
I found myself running MySQL queries directly in TM... cool! Just think of the possibilities with a macro :)
Hmm, care to share how you are doing the MySQL queries directly in TM ?? It might be obvious, but I just can't see it right now.
Kind regards,
Mats
Well, I have CocoaMySQL installed, and so "Perform selection as MySQL query" shows up under the TextMate->Services menu.
I don't know how Paul's doing it, if you do it that way your selected query will show up in the Query window in CocoaMySQL.
-- Mando
On Tue, 2 Nov 2004 14:58:57 +0000, Mats Persson mats@imediatec.co.uk wrote:
On Nov 2, 2004, at 12:53, Paul Nordstrom August wrote:
I found myself running MySQL queries directly in TM... cool! Just think of the possibilities with a macro :)
Hmm, care to share how you are doing the MySQL queries directly in TM ?? It might be obvious, but I just can't see it right now.
Kind regards,
Mats
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/mailman/listinfo/textmate
hi Mats, Well I'm just fooling around at present (and I'm hardly a unix geek!)... The key is to have a MySQL user defined on localhost w/o a password and then grant selected privileges. Obviously you have to be careful here with regards to security and what you permit :)
The output is a bit messy but I've done a few simple commands e.g. the following. I haven't had time yet to explore more complex SELECT queries. But presumably one could wrap the whole thing up in macros to tidy it up. (I use macros extensively to convert DESCRIBE queries into various other queries by parsing out the field names.)
Note that after the mysql dengue -e "YOUR QUERY HERE" you hit ctrl-R of course ;)
mysql dengue -e "SHOW TABLES"Tables_in_dengue bairropos bairrostats denguemenu elispotplates elispotwells poolpeptides pools poolsheets samples weeklypos weeklystats wellset_a wellset_b wellset_c
mysql dengue -e "DESCRIBE weeklystats"Field Type Null Key Default Extra week int(6) YES NULL samplecount int(4) YES NULL poscount int(4) YES NULL posrate decimal(3,2) YES NULL month char(3) YES NULL
Hope this helps. No doubt others have found a more elegant approach! Cheers and thanks for your interest. Paul
On 2 Nov 2004, at 15:58, Mats Persson wrote:
On Nov 2, 2004, at 12:53, Paul Nordstrom August wrote:
I found myself running MySQL queries directly in TM... cool! Just think of the possibilities with a macro :)
Hmm, care to share how you are doing the MySQL queries directly in TM ?? It might be obvious, but I just can't see it right now.
Kind regards,
Mats
textmate mailing list textmate@lists.macromates.com http://lists.macromates.com/mailman/listinfo/textmate
-
Allan Odgaard -
Mando Escamilla -
Mats Persson -
Paul Nordstrom August