0

For a small application, need to use a flat file database with relational capabilities (2 or 3 tables).

Couple questions regarding this schema:

  1. Does such databases exist?
  2. Any performance hits with large datasets? (say, 10k-20k entries)

The reason I want to go with a flat-file database is so the whole thing(root directory) can be copied and pasted, and not have to worry about exporting the database, installing & configuring a database in another system, etc.

thanks.

sqram
  • 7,069
  • 8
  • 48
  • 66
  • 2
    You didn't specify language... In Java, I'd use H2SQL,, and save a lot of time not worrying about special issues. It can be embedded into the app itself, so it is portable that way. – ppeterka Mar 20 '13 at 17:18
  • 1
    How about [SQLLite](http://www.sqlite.org)? – Nuno G Mar 20 '13 at 17:20

1 Answers1

3

Try SQLite.

It is easy to use, portable, no configuration and has great performance (10k / 20k is nothing)

Miguel Rodrigues
  • 917
  • 6
  • 19