Using Reactive MySQL Databases in Meteor (An Update?)

Question

I'm developing a new app and while I really like the entire Meteor ecosystem, I'm a bit turned off by the MongoDB requirements, mostly because a document-based database seems like putting a square peg through a round hole, due to the lack of Joins, which my DB setup would have used extensively.

It seems as if I'll need to "denormalize" my database and have lots of duplicate data if I choose to use MongoDB, and I haven't seen a convenient way to update the duplicated data if it needs to later be modified.

Now, I really want Meteor's offline DB capabilities and syncing for realtime updates, but it seems like my data better fits a classic relational database.

So, looking around, I saw that Meteor had SQL support in its roadmap, and that some connectors have been written already, but I didn't see anything newer than early 2014 even discussing it, so does anyone know where SQL support is at in Meteor? Is there a recommended project that adds it, or an alpha in place?

Answer 1

If you want to play Meteor with mySQL you will ended up using the numtel/meteor-mysql package.

There is a really good example using mysql with the leaderboard example.

Take a look into the documentation here

If you take a look into the comments on the trello sql support board Slava(core developer) point into the numtel package.