Riak for the cache?

[slopjong]

Riak?

Alternatives

[slopjong]

I've played with SQLite user-defined functions which allow queries that can operate on JSONs directly. For the prototype of the new OpenSpaceLint SQLite will be used.

Motivation: the old OpenSpaceLint is not well structured. Additionally the cache is file-based, with a db-based cache one can implement a history more easy. The new cache will also detect changes that affect the directory so that there's no need to fix it manually. E.g. if the space name changes one (hopefully) doesn't need to adapt any cron.

[slopjong]

Embedded databases:

• db4o => only java & .net (see db4o and php and db40)
• podb => dead
• berkeleydb is supported by php. It's licensed AGPL which should be no problem for SpaceAPI as long as it's licensed GPLv3 or AGPL. Read this article
• MapDB => java-only
• Derby => seems to be java-only

SO discussion

Where's the difference between the Berkeley DB handler types?