Geek Answers Handbook

Any way to get Meteor using a native ACID-compatible db?

I am seriously considering the Meteor framework for creating each POC and applications in the future ... but I can’t access the ACID-compatible database, since I have little use of atomic transactions with multiple documents that require such compliance.

The meteor currently relies heavily on MongoDB's syntax and storage mechanism (this means there is no syntax associated with the transaction ...)

I am currently evaluating any solution that allows this ACID feature:

  • Using the native MySQL driver for Meteor (different syntax than MongoDB?)
  • Using the native PostgreSQL driver for Meteor (SQL) syntax
  • Using TokuMX (MongoDB fork with ACID compatibility ... the same syntax as the MongoDB appart from the transaction related commands you need to add)

These 3 solutions are good candidates for the Meteor Roadmap, as shown here.

What are the pros and cons regarding this decision? Which of them are the most advanced? What would you consider as a solution to save Meteor when storing documents in NoSQL, such as an ACID-compatible db?

+4
source share
3 answers

I finally faked my own conclusion ...

I will have two platforms:

  • - PostgreSQL MongoDB
  • Java ( 2), - PostgreSQL... (SAP, Salesforce), BPMN 2.0 (Actility) SOA,

-

+1

sqlAndMeteor

, , . Meteor Trello (https://trello.com/b/hjBDflxp/meteor-roadmap) SQL, PostgreSQL, MySQL.

, , .

1.- SQL .

, , SQL ( JOINS, GRUP BY ..) . , SQL , , : - (2010), SqlLike (http://www.thomasfrank.se/sqlike.html). - alaSQL, @agershun (https://github.com/agershun/alasql). SqlLike , 10 . AlaSQL, , , SQL mongo sintax SqlLike .

- :

productsSold:function(){
  var customerSalesHistory=salesHistory.find({cutomerId:Session.get('currentCustomer')}).fetch();
  var items=products.find().fetch();
  return alasql("select item.name, sales.ordered as sumaVentas from ? sales, ? items
      where items.Id=sales.itemId",[customerSalesHistory,items]);
}

2.- SQL.

Mongo ( minimongo) MySql PostgreSQL. @numtel MySql Meteor-MySql https://github.com/numtel/meteor-mysql, PostgreSQL - Meteor-pg (https://github.com/numtel/meteor-pg). , - .

Hack Reactor Meteor Stream, PostgreSql Meteor, meteor-postgres (https://github.com/meteor-stream/meteor-postgres). alaSql minimongo.

, :

. , . AFAIK - -, , . 3.- Mongo, MySql.

Meteor Mongo MySql PostgreSql.

- mysql-shadow by @perak (https://github.com/perak/mysql-shadow). , , Mongo MySql MySql.

, , , , , .

SymmetricsDS (http://www.symmetricds.org), . , java-, , , , Mongo MySql, PostgreSQL, SQL Server, Informix. .

MySQL Shadow .

, Meteor, , .. , , .

, - Meteor , SQL, , , , .

+2

If MySQL works for you, I used the meteor-mysql package and it works well.

+1
source

More articles:


All Articles