Announcing MoSQL
stripe.com
Announcing MoSQL
1–10 of 118 posts
Re: Announcing MoSQL
#2At what point do you abandon mongodb and just use postgresql?
Re: Announcing MoSQL
#3At what point do you abandon mongodb and just use postgresql?
At no-point. Stripe is doing it right. They are using the right tool for each job. Mongo for storage speed etc and then postgres to analyze query etc.
This kind of comment shows how little knowledge you have about NoSQL and SQL. Is not a SQL vs NoSQL, it's about using the right technology for the job.
Re: Announcing MoSQL
#410gen also has a nice python app which syncs by tailing the MongoDB oplog to an external source. Most common is Solr.
https://github.com/10gen-labs/mongo-connector/tree/master/mo...
Seems to be high quality, and supports replica sets.
Re: Announcing MoSQL
#5At what point do you abandon mongodb and just use postgresql?
[deleted]
Re: Announcing MoSQL
#6Nice. Real businesses need a data warehouse and SQL is the right tool for that job.
I thank them for releasing this.
Re: Announcing MoSQL
#7This is pretty cool but I'm struggling to see what the use cases are, atleast for analysis. There might be quite a bit of benefits for running application code that I'm not aware of. With regards to analysis though, their own example question is "what happened last night?" but then they go on to say that it is a near real-time data store. Does it matter that it is a real-time mirror then?
I've always liked the paradigm of doing analysis on "slower" data stores, such as Hadoop+Hive or Vertica if you have the money. Decoupling analysis tools from application tools is both convenient and necessary as your organization and data scales.
Re: Announcing MoSQL
#8At what point do you abandon mongodb and just use postgresql?
At no-point. Stripe is doing it right. They are using the right tool for each job. Mongo for storage speed etc and then postgres to analyze query etc. This kind of comment shows how little knowledge you have about NoSQL and SQL. Is not a SQL vs NoSQL, it's about using the right technology for the job.
> This kind of comment shows how little knowledge you have about NoSQL and SQL.
The question is perfectly valid. In many scenarios (not necessarily Stripe's), PostgreSQL is fast enough to do the job. Stop putting people down for legitimate engineering questions.
Re: Announcing MoSQL
#9At what point do you abandon mongodb and just use postgresql?
At no-point. Stripe is doing it right. They are using the right tool for each job. Mongo for storage speed etc and then postgres to analyze query etc. This kind of comment shows how little knowledge you have about NoSQL and SQL. Is not a SQL vs NoSQL, it's about using the right technology for the job.
are you kidding me? There is absolutely NO reason whatsoever to use a NoSQL database for a financial services company. Postgres is more than capable of sustaining the necessary speeds of a startup.
Relational databases were created in the first place to solve these very problems around transactionality and analytics for finance.
This library is a beautiful example of reinventing the wheel, and otherwise creating a patchwork of unnecessary - and ultimately brittle - infrastructure.
Re: Announcing MoSQL
#10Nice. Real businesses need a data warehouse and SQL is the right tool for that job. I thank them for releasing this.
Maybe I'm misunderstanding your comment but... Real businesses need real solutions for their use cases. SQL is not necessarily the right tool for "that" job.