jd_mongodb's comments

On: NoSQL: The Baby and the Bathwater

[jd_mongodb]

You knowledge of MongoDB is a little out of date.

MongoDB supports SQL queries. Tableau has an MongoDB connector. You can connect MongoDB to Excel via our DataAPI and of course our Cloud platform provides embeddable charts.

Only the DataAPI is a relatively recent addition. The rest are very mature features.

[zX41ZdbW → jd_mongodb]

I did not find a reliable way to query MongoDB with SQL: https://github.com/ClickHouse/ClickBench/blob/main/mongodb/q...

It looks like it's only available in the Atlas service. Please correct me if I'm wrong.

Writing analytic queries in JS is painful.

[emptysea → jd_mongodb]

Problem with mongo is if you start using more SQL like things like pipelines and aggregations your perf goes out the window

you really have to think about how you structure your data in mongo for it to work with lots of queries since joins are untenable (even if aggregations support them)

[senttoschool → jd_mongodb]

So it's no longer a NoSQL database. ;)

On: It's not you, it's SQL

[jd_mongodb]

Comparing any modern database (i.e. developed after 1980) with IMS is like comparing a flint knife with a Barrett .50 calibre.

[commandlinefan → jd_mongodb]

Which one is the flint knife and which one is the Barrett .50 calibre?

On: Show HN: Music Audio Search Engine Using OpenAI's ...

[jd_mongodb]

We would love to help promote this? Ping me Joe dot Drumgoole at mongodb.com as we can get you some time on our podcast.

On: Make G-Sheets a UI for your MongoDB

[jd_mongodb]

See also https://www.mongodb.com/developer/products/atlas/atlas-data-...

On: Faster PostgresSQL to BigQuery Transfers

[jd_mongodb]

See https://cloud.google.com/blog/products/data-analytics/mongod...

[jd_mongodb → jd_mongodb]

See also https://www.youtube.com/watch?v=9MFv8J7Smws

[boundlessdreamz → jd_mongodb]

Thank you!

On: Show HN: Infisical – open-source secrets manager

[jd_mongodb]

MongoDB provides MongoDB Atlas, our own managed service. which is supported on every cloud (AWS, Azure, GCP).

On: Python 3.12.0 is to remove long-deprecated items

[jd_mongodb]

We have recognised this problem and to that end we have produced a Stable API standard https://www.mongodb.com/docs/manual/reference/stable-api/

I realise this doesn't help you with historical API changes.

If you look for help in the MongoDB community and tag me (Joe.Drumgoole@mongodb.com) I will make sure you get help migrating your app.

https://www.mongodb.com/community/forums/

On: Elasticsearch SQL

[jd_mongodb]

MongoDB has an SQL interface these days if you need it

https://www.mongodb.com/atlas/sql

[tofuahdude → jd_mongodb]

That is absolutely hilarious

On: Cloud costs are in a bubble

[jd_mongodb]

I am not disputing the bill, just curious how he got there. He doesn't say in his post.

[tomgs → jd_mongodb]

You're the mild one:)

On: Cloud costs are in a bubble

[jd_mongodb]

I did manage to approach his costs by running a sharded cluster with our largest configuration (M600 nodes with 640GB RAM. 4TB storage and 3.8m IOPS).

That is priced quite clearly on the bottom page at 102.49 USD an hour.

[NohatCoder → jd_mongodb]

Depending on exact specifications that is like $10k of hardware, so 4 days of rent pays the machine in full.

So in this service the actual cost of the hardware is a rounding error. It also needs power, cooling, a roof and some maintenance crew, but that still doesn't come close to the rental price. So what are customers actually paying for?

[vitaly_il → jd_mongodb]

Obviously we cannot launch such 3node cluster in Azure/AWS for $800/month :-)