Java and PostgreSQL vs MongoDB | Together Java | Page 1

mellow charm Mar 19, 2023, 9:31 AM

#

Hey! I am aware of:
https://en.wikipedia.org/wiki/Object–relational_impedance_mismatch

And the fact that JPA is supposed to solve this, isn't however MongoDB way more convenient in the case of Object Oriented Languages?

Hope to hear some opinions.

Object%E2%80%93relational_impedance_mismatch

young cipherBOT Mar 19, 2023, 9:31 AM

#

<@&987246584574140416> please have a look, thanks.

young cipherBOT Mar 19, 2023, 9:31 AM

#

young cipher <@&987246584574140416> please have a look, thanks.

#

While you are waiting for getting help, here are some tips to improve your experience:

Code is much easier to read if posted with syntax highlighting and proper formatting.

If nobody is calling back, that usually means that your question was not well asked and hence nobody feels confident enough answering. Try to use your time to elaborate, provide details, context, more code, examples and maybe some screenshots. With enough info, someone knows the answer for sure.

Don't forget to close your thread using the command </help-thread close:1027500463647621170> when your question has been answered, thanks.

past hill Mar 19, 2023, 9:44 AM

#

they all have their advantages and disadvantages

#

we are using mongo at my job and sometimes i miss my relational db as well

#

being schemaless can be a huge pain sometimes

#

backwards compatibility in case u have to rollback a buggy deployment is also a big problem

mellow charm Mar 19, 2023, 9:55 AM

#

I see

#

makes sense

#

thanks for your opinion

hybrid cargo Mar 19, 2023, 10:48 AM

#

Mongo isn't purely schemaless. Transactions and sharing in mongo are also immature.

#

What data requirements do you have? Impedance mismatches are rarely the bugbear neward made it out to be, and he damn well knows it.

#

Sharding, not sharing.

#

Jpa does not solve the mismatch. It perpetuates it.

gritty stratus Mar 19, 2023, 10:58 AM

#

wym @hybrid cargo ?

#

My understanding is that a mismatch happens because a relational database may represent a single entity while an object in your OOP language may represent a complex aggregation of multiple entities, which JPA solves

#

or more so ORM solves

#

Not sure how sharding is related to this

hybrid cargo Mar 19, 2023, 11:01 AM

#

Or vice versa. The real problems come in representation and access efficiency. To me, those rarely matter, because once you choose relationals, you're already slow, the rabbit is dead, move along. Orm doesn't really matter at that point.

gritty stratus Mar 19, 2023, 11:01 AM

#

relational is the best model imo lol

hybrid cargo Mar 19, 2023, 11:01 AM

#

It's a general issue with mongo. It's fast, but there are good reasons to not use it if you need those features.

gritty stratus Mar 19, 2023, 11:02 AM

#

ah yeah screw mongo

hybrid cargo Mar 19, 2023, 11:02 AM

#

Why?

gritty stratus Mar 19, 2023, 11:02 AM

#

because postgres is better

#

mysql is better

hybrid cargo Mar 19, 2023, 11:02 AM

#

At being postgres, sure.

#

MySQL is not better.

gritty stratus Mar 19, 2023, 11:03 AM

#

yeah it is

#

the latest MySQL is amazing

hybrid cargo Mar 19, 2023, 11:03 AM

#

If you say so.

gritty stratus Mar 19, 2023, 11:03 AM

#

have you used it?

hybrid cargo Mar 19, 2023, 11:03 AM

#

Yes?

gritty stratus Mar 19, 2023, 11:03 AM

#

why is it not better

hybrid cargo Mar 19, 2023, 11:03 AM

#

I'm on my ipad. Not typing all that out.

gritty stratus Mar 19, 2023, 11:03 AM

#

Actually, I should say Oracle Database is better

#

Oracle owns MySQL now anyway

hybrid cargo Mar 19, 2023, 11:04 AM

#

MySQL is what I'd use if I were running WordPress. That's it.

#

For every other rdms, postgres.

#

MySQL and oracle db are not the same creature at all.

gritty stratus Mar 19, 2023, 11:05 AM

#

Yeah Oracle is better

hybrid cargo Mar 19, 2023, 11:05 AM

#

... if you can afford it and have the space and need for it. I'd choose postgres over oracle, too.

gritty stratus Mar 19, 2023, 11:06 AM

#

That is the only caveat but Oracle have pumped millions into it

hybrid cargo Mar 19, 2023, 11:06 AM

#

And?

#

Postgres outperforms it in nearly every way, but pl/SQL is still oracle property.

frozen geode Mar 19, 2023, 11:07 AM

#

database scripting is cursed 😵

gritty stratus Mar 19, 2023, 11:08 AM

#

hybrid cargo Postgres outperforms it in nearly every way, but pl/SQL is still oracle property...

I don't agree, Oracle DB is known for high performance and scalability

hybrid cargo Mar 19, 2023, 11:08 AM

#

Sigh

#

Java is known for being slow, too.

#

Definitely true, right? It is known.

gritty stratus Mar 19, 2023, 11:09 AM

#

A few years ago yes not now

hybrid cargo Mar 19, 2023, 11:09 AM

#

Tenty years ago. And oracle being fast is just as known.

#

Don't feed me crap that's in my baileywick, please.

gritty stratus Mar 19, 2023, 11:10 AM

#

It's my ballpark too lol

hybrid cargo Mar 19, 2023, 11:11 AM

#

Oracle performance is OKAY. Not great. For raw speed, you go with no relational MySQL, lose time support and data integrity but it's fast. If those things matter postgres.

gritty stratus Mar 19, 2023, 11:11 AM

#

Yeah actually, the latest MySQL is shockingly quick lol

hybrid cargo Mar 19, 2023, 11:12 AM

#

Andif you really want speed but don't need SQL, then you get to consider what needs you have for cap theorem.

gritty stratus Mar 19, 2023, 11:12 AM

#

gritty stratus Yeah actually, the latest MySQL is shockingly quick lol

I'm saying this because the previous version of MySQL I had a query that took 10 seconds to run, but using the latest it was 1 second

#

and no underlying difference when I did an analysis on it

hybrid cargo Mar 19, 2023, 11:13 AM

#

Explain plan didn't show a difference?

gritty stratus Mar 19, 2023, 11:13 AM

#

1 very minor detail

hybrid cargo Mar 19, 2023, 11:13 AM

#

Then MySQL optimized something. Good for them.

gritty stratus Mar 19, 2023, 11:13 AM

#

that didn't affect the result

#

Yeah they did

hybrid cargo Mar 19, 2023, 11:42 AM

#

Slightly outdated information, but: http://grimoire.ca/mysql/choose-something-else

polar blaze Mar 19, 2023, 12:30 PM

#

One thing I really like about mongodb is if you have a complex aggregate, you don't have to create 10+ tables for that one aggregate. Of course, you are giving up normalization for that benefit but we haven't had any issues with it.

#

We also have a collection that has a parent class with a bunch of sub-types. Mongodb has made that a lot easier rather than having to create a new table for each sub-type.

#Java and PostgreSQL vs MongoDB