I'd like to build a simple program using a database stored in a local file and I don't really know where to begin.
Ideally, I would like to use something akin to SQLite ( http://www.sqlite.org
) because it's simple, can be used with local files (as opposed to connecting to a remotely or locally installed db such as mySQL) and is sufficient for my modest requirements. I don't want the user to have to install anything.
Is this a good choice? I don't like the idea of using an MSAccess db but I couldn't explain why - is that a good cross platform choice?
I have seen references to SQLite wrappers so I know it's possible and I have some familiarity with building and querying SQLite dbs. What I don't know is how I would go about integrating such a database into a java project (I'm still very much a newb in this territory).
If someone could point me in the direction of some resources that might help me get up and running, that would be very much appreciated.
edit: I should probably mention that I'm working on OS X
[ February 13, 2006: Message edited by: L�szl� Kov�cs ]