ResultsTable to MySQL

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

ResultsTable to MySQL

JaapK
Hello all,

Inspired by the MySQL plugin written by Dimiter Prodanov, I wrote a
plugin that writes the data in a ResultsTable to a MySQL table.
Please respond if you are interested, then I can release it somewhere.

Kind regards,
Jaap Kokorian
Reply | Threaded
Open this post in threaded view
|

Re: ResultsTable to MySQL

Michael Doube
Hi Jaap.

> Inspired by the MySQL plugin written by Dimiter Prodanov, I wrote a
> plugin that writes the data in a ResultsTable to a MySQL table.
> Please respond if you are interested, then I can release it somewhere.

This sounds very useful indeed. At the moment I have to save as CSV,
then use a Perl script to INSERT into a MySQL table.

Michael
Reply | Threaded
Open this post in threaded view
|

Re: ResultsTable to MySQL

JaapK
Hello all,

Thank you very much for your responses. You can download the plugin from:
http://sourceforge.net/projects/openpheno/files/ImageJ%20Plugins/ij_mysql.zip/download

Let me know if it works. If it doesn't I'll get right on to fixing it!

Cheers,
Jaap

2010/12/31 Michael Doube <[hidden email]>:

> Hi Jaap.
>
>> Inspired by the MySQL plugin written by Dimiter Prodanov, I wrote a
>> plugin that writes the data in a ResultsTable to a MySQL table.
>> Please respond if you are interested, then I can release it somewhere.
>
> This sounds very useful indeed. At the moment I have to save as CSV,
> then use a Perl script to INSERT into a MySQL table.
>
> Michael
>
Reply | Threaded
Open this post in threaded view
|

Re: ResultsTable to MySQL

Prodanov Dimiter
In reply to this post by JaapK
Hello,
Thanks for the acknowledgement. I have the DB system working since 2004 so I'll be happy to share some expertise.

Best regards,

Dimiter Prodanov
Reply | Threaded
Open this post in threaded view
|

Re: ResultsTable to MySQL

Michael Doube
In reply to this post by JaapK
Hi Jaap

> Thank you very much for your responses. You can download the plugin from:
> http://sourceforge.net/projects/openpheno/files/ImageJ%20Plugins/ij_mysql.zip/download
>
> Let me know if it works. If it doesn't I'll get right on to fixing it!

Sorry it has taken a month to get around to trying this out.  It looks
like it can connect OK to my MySQL server, and I can get data straight
from the Results table into a MySQL table.  Nice!  I will be playing
with this some more...

One thing that would be useful is a configuration guide, especially with
regard to user and schema permissions.  I was slightly surprised to see
the plugin creating a table, rather than INSERTing into an existing one.
 I made a MySQL user called imagej, and I'd like to give it very limited
permissions: what are the minimum permissions needed for this to work?
(CREATE and INSERT?).

Is there a way to make the plugin a bit more compact, or are all the
classes needed? I see that ij_mysql.jar contains jdbc, and so does
mysql-connector-java-5.1.13-bin.jar, so this appears to be a bit redundant.

Otherwise, thanks!

Michael