postgresql included in software package

[alexattek]

Hello everybody,

i plan a platform independent software package to visualize some data (written in java). as backend i would like to use a postgresql database via JDBC.
i would like to incorporate the postgresql database in my package in such a way, that i have a 'standalone' solution, as many end users don't like to have to install an postgresql server first.
the standalone program should be installable locally (without root access), each userinstance of the program would use its own, internal postgresql database server which would get started with the program.
please don't blame me, I come from linux's modular approach. but my hunch is, that most end users prefer installing 200 Mb extra using one click instead of working through an installation manual.

what do you think? is this possible? how to start? is there some good documentation related to this?

thanks a lot

alex

 

[stoolpigeon]

you can do a lot with postgres - and i'm not trying to be unhelpful - but have you considered HSQLDB?

http://www.hsqldb.org/

 

[stoolpigeon]

oh - and if you are really set on postgres- this might be helpful:

http://www.macosxguru.net/article.php?story=20041119135924825

 

[alexattek]

this timing test is really interesting. in the menatime i switched to java/derby instead of sql as it can easily be embedded. i'm a bit astonished, that derby and hsqldp perform much better than mysql.
i will chekc hsqldb against derby.
thank you for the hint.

alex