[ANN] SQLQueryPlugin version 1.0.9 released

Sure it works!
All you need to do is to put hsqldb.jar into IDEA/lib and configure "Other Driver".

"Daniel Moldovan" <d.moldovan@level7.ro> wrote in message news:b7ljfa$kej$1@is.intellij.net...

Does this plugin support HSQL DB? If not, do you know any plugin
that support it? Or, what should I do to modify this plugin to work with
HSQL.

>

Thanks,
Daniel

>
>

"Stefan Stiller" <stefan@sstiller.de> wrote in message
news:30934332.1045555233158.JavaMail.jrun@is.intellij.net...

I can't test my plugin on a Sybase db but I think the 'SET CHAINED'

problem is connected to the 'AutoCommit' option. Did you try it with
'AutoCommit' empty (=default) and disabled the option 'Highlight primary key
columns'.

Regarding the connection editing bug see the reply above.

>

Thanks,
Stefan.

>

>
>

Thanks for the great plugin!

I'm using it with HSQL DB.
I have a few feature requests if you don't mind:

1. It would be great if I can see the data in different formats,
like hexadecimal/octal/etc for numeric types, wrapped text
for long strings, different date formats etc.. For now I have to do the
conversion in a select statement which is a bit of pain. Justification
options would be also very helpful (including justification "on symbol").

2. It would be even greater to be able to specify a classpath
to my own java classes/jars (defaulted to the project output classpath?).
In this case it would be possible to use my own conversion/formatting
methods for retrieved data and use my java functions in the SQL query
(if the DB supports this, like hsqldb)

3. It would be nice to have a column width automatically set by double
clicking on the column separator in the header (like many others do)

There is also a tiny bug I found: when you're saving the query, the *.sql
extension is not added automatically to a file name although "sql sources"
is selected in the file type drop-down. So if you forgot to put the extention
down you won't see your saved files next time.

Thank again, Oleg

"Stefan Stiller" <stefan@sstiller.de> wrote in message news:6792737.1045410375304.JavaMail.jrun@is.intellij.net...

I've release the latest version of my plugin.

>

New features:

• Syntax highlighting for queries

• Copy and paste actions

>

http://www.intellij.org/twiki/bin/view/Main/SQLQueryPlugin

>

I would like to know on which database other than Oracle or MySQL my plugin works, so please let me know on what

database you use my plugin.
>

Bye, Stefan.

Great plugin!

Feature request: when starting IDEA, I often find myself wishing that the
SQL Query Plugin would remember which (saved) queries I had open when I last
closed IDEA and re-open them. Perhaps make it optional for those who don't
want this.

thanks!

chris


"Stefan Stiller" <stefan@sstiller.de> wrote in message
news:6792737.1045410375304.JavaMail.jrun@is.intellij.net...

I've release the latest version of my plugin.

>

New features:

• Syntax highlighting for queries

• Copy and paste actions

>

http://www.intellij.org/twiki/bin/view/Main/SQLQueryPlugin

>

I would like to know on which database other than Oracle or MySQL my

plugin works, so please let me know on what database you use my plugin.
>

Bye, Stefan.

I already thought about it I just don't know what to do with queries which not have been saved in a file yet. I could save them in the project workspace but a query can be relatively large and I don't want to overload the workspace.

Bye,
Stefan

1. It would be great if I can see the data in
different formats,
like hexadecimal/octal/etc for numeric types,
es, wrapped text
for long strings, different date formats etc..
c.. For now I have to do the
conversion in a select statement which is a bit
bit of pain. Justification
options would be also very helpful (including
ing justification "on symbol").

I've added the possibility to format dates with time in the next version. I will think about adding different number formats, but user must still specifiy the format for each column because there is no way to identify the format for a column through the plugin.

2. It would be even greater to be able to specify a
classpath
to my own java classes/jars (defaulted to the
the project output classpath?).
In this case it would be possible to use my own
own conversion/formatting
methods for retrieved data and use my java
java functions in the SQL query
(if the DB supports this, like hsqldb)

I don't think this is neccessary because it would go beyond the scope of the plugin.

3. It would be nice to have a column width
automatically set by double
clicking on the column separator in the header
ader (like many others do)

Will be include in the next version as configurable option.

Bye,
Stefan.

I'd be happy if it only re-opened saved queries. If I didn't save it, then it's my tough luck and I'll learn for next time ;)

Completely unrelated: is there a way to change the format for timestamp fields? The plugin currently shows only the date part, but sometimes I'd like to see the time as well.

thanks for a great plugin!

chris

Duh, sorry--disregard the timestamp formatting question. I missed your post up above.

Sorry.

I've added the possibility to format dates with time in the next version. I will think about adding different number

formats, but user must still specifiy the format for each column because there is no way to identify the format for a
column through the plugin.

Absolutely! Right-click pop-up menu on the column would be perfect. The ability to pre-configure default
format[s] on per-table basis would be even more perfect.

I don't think this is neccessary because it would go beyond the scope of the plugin.

Sorry, no offence, but I could never understand this kind of reasoning.
I can understand if you have no time or desire to continue, but scope....?
Well, let's extend the scope then! Besides, you would get three(!) ducks in
one shot: a) Solve column formatting problem, b) Allow for unlimited extensions
c) Make all this formatting work done by somebody else (us!)
Looks to me like a good example of an ideal system (you know the classic
definition of an ideal system, don't you?). So why don't you go for it?

Bye,
Stefan.

>

Thanks again for the very helpful plugin!
--Oleg