Re: storing data in a desktop app

From:

Tom Anderson <twic@urchin.earth.li>

Newsgroups:

comp.lang.java.programmer

Date:

Sun, 27 Feb 2011 20:37:20 +0000

Message-ID:

<alpine.DEB.1.10.1102272026290.3615@urchin.earth.li>

On Sat, 26 Feb 2011, harryos wrote:

I am plannig to write a task /time tracking app in which a user can
add/edit tasks and later get reports about the tasks completed.I thought
of doing it as a web app with hsqldb to store data.Then ,when I came to
think about it,I wondered why I couldn't do this as a desktop
application.Is it a good idea to use rdbms in a desktop app?I mean can I
make my application in such a way that a user will not have to do
database setup separately.I am intending to give this application to
users who will have no knowledge about database systems or their
setup.Can I hide the db setup/access and everything related to data
storage inside my appliation and thus invisible to the user?Or do I have
to store data as csv?

You can do that, no problem. The embedded databases like HSQLDB will
create databases in local files, which behave just like any other files.

Don't use HSQLDB, though, use H2. It's faster, and has better SQL support.

tom

--
Everything looks kind of OK