File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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: 9059

"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!