wood burning stoves*
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


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "database primer" Watch "database primer" New topic
Author

database primer

L�szl� Kov�cs
Greenhorn

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 ( 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.
Marilyn de Queiroz
Sheriff

Joined: Jul 22, 2000
Posts: 9043
    
  10
http://www.javaranch.com/drive/jdbc/index.jsp


JavaBeginnersFaq
"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
Greenhorn

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
Laszlo,

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

HSQLDB

and

PointBase

Hope this helps.

Regards,
JD
L�szl� Kov�cs
Greenhorn

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: http://aspose.com/file-tools
 
subject: database primer
 
Similar Threads
Suitable database for desktop application
Where are SQLite3 databases created?
Newbie - web service design assistance needed
Newbie - Best practice for a new .db ?
Data store Options in Java for Desktop Applications