Any way to get Meteor using a native ACID compliant db?

Question

I am seriously considering Meteor framework for building every POC and apps in the future...but, I can't get ride of an ACID compliant database as I have few usages of multi-documents atomic transaction that require this compliance.

Meteor strongly rely on MongoDB syntax and storage engine at the moment (it means there are no "Transaction" related syntax available...)

I am currently evaluating any solution allowing this ACID capability :

• Using a MySQL native driver for Meteor (different syntax than MongoDB?)
• Using a PostgreSQL native driver for Meteor (SQL syntax)
• Using a TokuMX (a MongoDB fork with ACID compliance...same syntax than MongoDB appart from transaction related commands that would be required to add)

Those 3 solutions are good candidates for the Meteor roadmap as shown here

What pros/cons about those solution ? Which are the most advanced one ? What would you although consider as a solution to keep Meteor while storing documents in a NoSQL like ACID compliant db ?

Answer 1

I finally forged my own conclusion...

I will have TWO platforms :

• a Meteor front with business data in PostgreSQL and some front data or easy-to-replicate data in MongoDB
• a Java data backend (server2server only) handling all atomic operations on my business data in PostgreSQL...plus technical adapters (SAP, Salesforce), a BPMN 2.0 workflow engine (Actility), and any registered SOA needed from other systems

Any comments are still very welcomed and will be considered and answered