This week's book giveaway is in the Cloud/Virtualizaton forum.
We're giving away four copies of Mesos in Action and have Roger Ignazio on-line!
See this thread for details.
Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

database primer

 
L�szl� Kov�cs
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Marilyn de Queiroz
Sheriff
Posts: 9063
12
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
http://www.javaranch.com/drive/jdbc/index.jsp
 
L�szl� Kov�cs
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 130
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks John. The first link looks interesting. Have you used it? What were your experiences?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic