tags:

views:

89

answers:

3

Is there a database out there that I can use for a really basic project that stores the schema in terms of documents representing an individual database table?

For example, if I have a schema made up of 5 tables (one, two, three, four and five), then the database would be made up of 5 documents in some sort of "simple" encoding (e.g. json, xml etc)

I'm writing a Java based app so I would need it to have a JDBC driver for this sort of database if one exists.

+1  A: 
  1. CouchDB and you can use it with java

  2. dbslayer is also light weight with MySQL adapter. I guess, this will make life a little easy.

zengr
+1  A: 

I haven't used it for a bit, but HyperSQL has worked well in the past, and it's quite quick to set up:

"... offers a small, fast multithreaded and transactional database engine which offers in-memory and disk-based tables and supports embedded and server modes."

Rodney Gitzel
I have thought of using hsqldb however can it easily be split into files per table? (see one of my comments about diffs and merges on the original post as to why I ask this)
digiarnie
Like this? http://hsqldb.org/doc/guide/ch06.html "In a nutshell, Text Tables are CSV or other delimited files treated as SQL tables."
Rodney Gitzel
A: 

CouchDB works well (@zengr). You may also want to look at MongoDB.

Comparing Mongo DB and Couch DB

Java Tutorial - MongoDB

Edward Leno