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 ]
Disclaimer: The above post may or may not reflect reality as seen by other people.
JavaBeginnersFaq "Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
Joined: Jun 18, 2005
Thank you Marilyn. It's an interesting read but I don't quite see how it answers the question. I understand that many of the principles will be the same whether I'm using a client/server database or an embedded flat-file database but I'm really only interested in the latter and am looking for a resource that doesn't assume I'm doing the former. Do you know of anything like that?