D
D
DYLAN2017-03-12 18:14:57
CMS
DYLAN, 2017-03-12 18:14:57

Why don't some modern CMS link their tables in the DB?

Why do some modern website engines not link their tables in the database? Actually, I had such a question, why did the developers start doing this, is it an act of shit coding or is there a hidden meaning, because a database that has no connections will not be informative, a new developer who wants to join this project will face difficulties in understanding the structure of the database.
Actually, this is the question, just as for me, it’s easier to write an SQL query than tossing tons of data rows and trying to combine them somehow at the program level.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
dinegnet, 2017-03-12
@ermolaev_nikita

Because they bind at the application level of the engine.
For a long time it is no longer fashionable to use all conceivable features of a particular DBMS.
At least for the reason that this makes it too much to become attached to a specific DBMS .
The fact that it is easier for you to write a query than to understand the engine only says that your qualifications regarding this particular engine are not very high.
There is nothing wrong with that - there will always be someone more competent in this particular engine. You can't be competent in all engines.
Indeed, it is easier to write inside SQL. Simply because much less global issues are being resolved there. You can say SQL - only primitive problems .
That's why it's easier for you. Solving primitive questions is always easier.
In fact, you do not solve the problems of the end customer by doing so - but your own.
It is more difficult to poke around in the engine, but it is more necessary - since high-level tasks are solved there.
This is not so (that is, you can get by with one SQL and not do anything in the engine) only on simple tasks.
But when the task becomes more complicated, then you need to strain your brain and go to understand the logic of the engine.
Many programmers are unable to do this.
Here, after all, it is already necessary to solve not simple primitive programming tasks that are understandable to you,
but to delve into the problems of the subject area.
On this, many merge.
Another reason is that a full-fledged relational model with the relationships you are interested in does not fit well .on many applied tasks solved on CMS.
Disconnected tables allow you to make the solution more flexible , bringing relational DBMS closer to No-SQL DBMS.
Transferring logic from the database to the engine allows you to solve many problems better . For example, such an important thing as caching. Yes, and many others.

S
sim3x, 2017-03-12
@sim3x

I hope that due to the fact that in some subds this possibility did not immediately appear
stackoverflow.com/questions/12971246/why-doesnt-my...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question