Tell me more ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.
up vote 0 down vote favorite

SQLite is nice for small, standalone projects, since the data file is a single object that lives with the project. Most of the NoSQL solutions I've seen are servers that store data there. Is there a NoSQL solution that keeps the data in a single file like SQLite?

share|improve this question
I dont think there is a true flatfile nosql solution out there. Mongodb claims to be able to run for small installations requiring minimal config and it does do that. However there is no way around running a daemon. I suppose it is the way nosql systems are designed that they must manage processes. Other than that you are basically looking at flat files or sql embedded databases. – Vangel Jul 10 '12 at 8:13

closed as off topic by John Gardeniers, voretaq7♦ Jul 28 '12 at 4:14

Questions on Server Fault are expected to relate to professional server, networking, or related infrastructure administration within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

3 Answers

up vote 0 down vote accepted

If you really have a hard-on for keeping everything in a single file (well, almost), BerkeleyDB is what you want. However, I'd probably just use the original key-value store: your filesystem.

share|improve this answer
up vote 1 down vote

There's GDBM:

The basic use of GDBM is to store key/data pairs in a data file. Each key must be unique and each key is paired with only one data item.

The library provides primitives for storing key/data pairs, searching and retrieving the data by its key and deleting a key along with its data. It also support sequential iteration over all key/data pairs in a database.

share|improve this answer
up vote -2 down vote

yep its called CSV

http://en.wikipedia.org/wiki/Comma-separated_values

example http://code.activestate.com/recipes/577419-query-csv-file/

share|improve this answer
Cute idea, but the CSV file format has no optimization (B-Tree or whatnot) for dealing with very large data sets as most databases do. The linked implementation reads the entire database into memory for every query run. – MidnightLightning Jul 9 '12 at 21:30
neither does nosql. nosql usually does not implement btree but most commly hash indexes or range indexes. It is true that it will read entire thing to memory with CSV but since you wanted an embedded one I assumed it is not going to be a huge DB and reading from memory might infact be better. You can however use MS Access for flat file querying using ADODB or similar adapters for your language. – Vangel Jul 10 '12 at 8:07

Not the answer you're looking for? Browse other questions tagged or ask your own question.