There is any NoSql database as simple as SQLite? I'm looking for a lightweight database to persist a small set of data for a simple desktop application. I still can use SQLite but prefer a more OO approach since my app doesn't handle much data.
You can check some oodb (object-oriented database) Gemstone is nice. http://www.gemstone.com/ http://www.versant.com/
Do you need something embedded in your application (if yes, which language are you using?) or a separate database server?
Sounds like a job for y_serial ;-)
Here's the description: "Serialization + persistance :: in a few lines of code, compress and annotate Python objects into SQLite; then later retrieve them chronologically by keywords without any SQL. Most useful "standard" module for a database to store schema-less data."
See http://yserial.sourceforge.net/ for more details.
Friendly http://friendlyorm.com is sort of a NOSQL database that uses Ruby + SQLite as its backend. It's kind of a hack, but it's also kind of nice. I wrote a sample Sinatra app that demonstrates it here: http://gist.github.com/507749#file_friendly%20sqlite%20nosql%20sinatra