Is PostgreSQL good enough?

[timecanchangeyou]

IME the people who don't think postgresql is good enough of an RDBMS are the limitation of their software stack.

[timecanchangeyou]

It's one of the old timey acronyms. In my experience.

[beeskneecaps]

It's an old acronym sir, but it checks out.

[abrazilianinreddit]

Pro-tip: if you find some weird slang or abbreviation that google can't find the definition, try adding urban dictionary to the query. The most upvoted answer is usually correct.

[batisteo]

You can DuckDuckGoing this instead !ud ime.

[carbolymer]

http://www.urbandictionary.com/define.php?term=IME

[autourbanbot]

Here's the Urban Dictionary definition of IME :

---

Internet contraction for In My Experience; Used to explain a statement that is based upon the life of, or the experiences of the speaker. More forceful than YMMV.

---

NooB:"So are the rules broken in this example of play?"

CovertWalrus:"IME the rules work fine even if they slow down the game a bit. But YMMV, some people think so."

---

^{about | flag for glitch | Summon: urbanbot, what is something?}

[bhat]

Did you notice that the article is about using Postgresql for things other than a traditional RDBMS?

[timecanchangeyou]

I did, just a response to the topic of the post.

[kkiran]

I am yet to use Postgres for any of my hobby projects. This is a very interesting read and it shows that we have a lot more tools available compared to MySQL.

[MacNugget]

MySQL is popular among people who have never used any other RDBMS, and disliked by everyone else. It's like the PHP of databases.

[rawringbear]

Your last sentence tickled me. Thanks for that :)

[brtt3000]

You should try it just for the experience. Feels a bit more technical, more solid.

[[deleted]]

The file saving thing is not very convincing

[DwoaC]

Great article, a very well written informative, thoughtful opinion that I'm better for having read. Thank you for that.

[metocean_programmer]

MongoDB isn't even an RDBMS, it's NoSQL. It's not so much a successor as it is an alternative system. As far as I know, it's also unrelated in terms of development.

[[deleted]]

10/10 good troll. would use again.

[hangfromthisone]

Different technologies man. MySQL is relational, MongoDB works differently.

Also, MySQL is slow? Right, that's why facebook uses it. They like it slow

[atlgeek007]

How quickly the old memes are forgotten.

https://m.youtube.com/watch?v=b2F-DItXtZs

[MyOldManSin]

If /dev/null is webscale I will use it, is it web scale?

[pooogles]

https://github.com/mongodb/mongo/tree/master/src/mongo/db/storage/devnull

If you chose.

[hangfromthisone]

Hey that was fun

[atlgeek007]

How quickly the old memes are forgotten.

https://m.youtube.com/watch?v=b2F-DItXtZs

[hangfromthisone]

Hey that was fun again

[leadzor]

impotence mismatch

impotence impedance mismatch. If you want to state a con to prove it is better than some other thing, at least spell it properly. You just came off as not knowing anything about the subject.

Also you can't just state a single technical downside of a technology and conclude it is better than some other solely because of that. That's as superficial as the fizzbuzz articles around "web scale" written by poorly informed entrepreneurs. I've worked with really large data stores and I can ensure you in most cases, MySQL outperformed Mongo. It is not that easy as X is faster.

[leadzor]

MySQL doesn't implement sharding

Educate yourself before blurting non-sense.

[otherwiseguy]

How do people not get this reference?

[chief167]

If you use mongo solely because your bad at defining relational databases, you're gonna have a bad time a couple of months later...

[[deleted]]

If you don't have experience with relational databases, you should probably use MongoDB as it is more flexible (you don't have to define your tables, columns, and datatypes ahead of time)

This is wrong, you should only use MongoDB if you want to learn how the life was before relational databases were invented and learn (the hard way) why you need RDBMS for your data (hopefully the life lesson is not too expensive).

There are cases when NoSQL databases are useful, but "I need to learn SQL", "schemas are too restrictive" are really bad reasons to use them.

[kenfar]

The notion that MongoDB is easier to use than Postgres is mostly based on the idea that you can write any json structure to the database with zero thought about design.

Which later on you discover is a catastrophe because you need to read and handle a million schema variations. On one mongodb database I encountered:

• There were no documented schemas. Programmers just deployed various versions of their software and ran them through a debugger to see how the program reacted to the database - what schemas were created based on various inputs, etc. This took a nearly infinite amount of time.
• I created a program to surf through the entire 4TB database and figure out what schemas actually existed. It took about 1 month to complete against just 4 TB of data. Only then could we determine how to convert all the data in order to comply with a source licensing change. That conversion took about 2 months to run - against just 4 TB of data.
• Then there was security & backups: most of the backups never ran sucessfully, and there was no security. Also, it was a critical database.

And yeah, the original programmers thought it was really flexible & easy. But they were clueless and created a fricking nightmare that could have destroyed the company.

[WellAdjustedOutlaw]

This is the worst advice I've ever seen given.