NO SQL reliable for small business applications?

Question

I decide how to switch to the NON-SQL engine or regular SQL code for a document management system for small business systems.

I have experience with firebird / sql server and found good reliability (especially with Firebird).

This market is full of crappy "servers" (cloned PCs, City Hall), a cheap hard drive, rarely use RAID or something like that, some of them are in places where the power is off, some of them do not have UPSs, etc. . (I will enable automatic backup to external servers, but without changing the internal settings). (I know about end-user education about such proper settings, but stupidly depends on that, so stick to te point)

From a design perspective, a database without a schema is the way to go for my system, but I'm worried if any of the real solutions (MongoDb, Tokyo Cabinet, etc.) seem like torture loss and survival, crashes and abuse, so damage data is very rare.

The plan stores office documents there and provides a central repository.

Answer 1

Check out Neo4j . This is a graphical database (without a schema) that can be used as a repository of documents or keys / values.

Neo4j has been working for many years in environments such as you describe. Unlike many other databases, NOSQL Neo4j actually flushes data to disk and uses a transaction log to recover from an inconsistent state. It also has real transactions (full ACID) that can span multiple operations and process them as a whole (which also seems to be a feature that is often missing in many other NOSQL stores).

-Johan

(Disclaimer: I am part of the Neo4j team)

Answer 2

CouchDB has the necessary reliability:

The CouchDB layout and commitment system has all the features of an Atomic Consistent Isolated Durable (ACID). On disk, CouchDB never overwrites transferred data or related structures, ensuring that the database file is always in a consistent state.

Have a look at the ACID properties section here for more information.

With CouchDB, you also get easy backup and replication.

I don't have code in production using CouchDB yet, but so far I am very pleased with the tests and development process with CouchDB.