Re: TrakEM2 0.3g released

Posted by Albert Cardona on Oct 03, 2006; 8:19am
URL: http://imagej.273.s1.nabble.com/TrakEM2-0-3g-released-tp3701430p3701431.html

Hi Dimiter,

> good to hear this from you. I was thinking also of adding
> multiple database support in TrakEM2. If you are interested
> I can try to port it to a MySQL backend.

Why not, almost everything database-dependent is clustered at the
ini.trakem2.persistence.DBLoader class, which you can copy verbatim and
replace a few lines of code (perhaps one could make an abstract DBLoader and
then create a PGLoader and a MyLoader and so on). At the moment there is
already an abstract class, the Loader, which both the DBLoader and the
FSLoader (file system loader) extend, and which handles the rolling memory
and the insertion of images, stacks and montages.

In the SQL language I have avoided any postgresql-specific idioms, except for
the PGpolygon class to store points. This class is also used as a convenience
in the Profile and Pipe classes of the ini.trakem2.display package, but I can
change it to a more portable array of points.

On MySQL: I tried a year ago version 4.0.* and it had performance issues
(read: very slow) when inserting large amounts of data (say, a layer with
about 0.5 GB of montaged images), which PostgreSQL 8.1.4 does not suffer
from. The situation may have changed now with MySQL 5, I haven't tested it.

It would help me Dimiter to have such a MySQL loader in that you may spot
performance bottlenecks (some I suspect, some I can't test). So just ask what
you need!

Albert