• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

database primer

 
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Sheriff
Posts: 9109
12
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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?
 
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks John. The first link looks interesting. Have you used it? What were your experiences?
reply
    Bookmark Topic Watch Topic
  • New Topic