[SVN] r7189 (Experimental SQL)

[Allan Odgaard]

On 13. May 2007, at 17:35, Ciarán Walsh wrote:

> On 9 May 2007, at 15:13, Ciarán Walsh wrote:
>
>> A new SQL bundle.
> Has anyone tried this? I'm hoping to get some feedback, especially  
> on setup, to gauge it as a potential replacement for the current  
> SQL bundle.

Works very well for me with MySQL 4.1.22.

Only two concerns with replacing the old stuff:

  1) the old query command also supports sqlite (though not the old  
browser)
  2) the old stuff was styled nicer :)

Of course it would be nice if someone with Postgresql could test this.

Two things I have been considering for the SQL stuff bundle:

  1) use KeyChain for database password
  2) provide a GUI to setup stuff (and store the values preferably as  
a .textmate_init file either in users home folder or in a folder of  
his choosing), perhaps not use the current .textmate_init system, but  
just use the same principle of locating the first file from the  
current folder and up, to find the settings.

I can do most of this latter stuff, just wanted to have some opinions  
on this. IMO we should a) avoid having passwords in readable formats  
(especially as environment variables) and b) setting the four or so  
SQL variables is tedious to do in Preferences → Advanced or via the  
project specific variable settings.