Meaningless Drivel is fun!
The moose likes Beginning Java and the fly likes database primer Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "database primer" Watch "database primer" New topic

database primer

L�szl� Kov�cs

Joined: Jun 18, 2005
Posts: 17
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 ( ) 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.
Marilyn de Queiroz

Joined: Jul 22, 2000
Posts: 9058

"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
L�szl� Kov�cs

Joined: Jun 18, 2005
Posts: 17
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?
John Dell'Oso
Ranch Hand

Joined: Apr 08, 2004
Posts: 130

Here are a couple of links that may be of interest to you:




Hope this helps.

L�szl� Kov�cs

Joined: Jun 18, 2005
Posts: 17
Thanks John. The first link looks interesting. Have you used it? What were your experiences?
I agree. Here's the link:
subject: database primer
It's not a secret anymore!