MoSQL
2013-02-05 19:54:50.038466+01 by
Dan Lyke
0 comments
Announcing MoSQL: live-replicate data from MongoDB into PostgreSQL.
An obvious solution is to periodically dump your MongoDB
database and re-import into PostgreSQL, perhaps
using mongoexport.
We
experimented with this approach, but found ourselves frustrated
with the ever-growing time it took to do a full refresh. Even if
most of your analyses can tolerate a day or two of delay,
occasionally you want to ask ad-hoc questions about "what happened
last night?", and it's frustrating to have to wait on a huge
dump/load refresh to do that. In response, we built MoSQL,
enabling us to keep a real-time SQL mirror of our Mongo data.
[ related topics:
Interactive Drama Weblogs Theater & Plays Databases
]
comments in ascending chronological order (reverse):
Comment policy
We will not edit your comments. However, we may delete your
comments, or cause them to be hidden behind another link, if we feel
they detract from the conversation. Commercial plugs are fine,
if they are relevant to the conversation, and if you don't
try to pretend to be a consumer. Annoying endorsements will be deleted
if you're lucky, if you're not a whole bunch of people smarter and
more articulate than you will ridicule you, and we will leave
such ridicule in place.
Flutterby™ is a trademark claimed by
Dan Lyke for the web publications at www.flutterby.com and www.flutterby.net.