marrowyung
asked on
MS SQL , MySQL together with PostgreSQL
Hi,
We are considering to use PostgreSQL as a open source DB as well as MySQL but from your point of view, what great is PostgreSQL?
we are currently using MS SQL on Azure and some MySQL/MariaDB, why PostgreSQL is good ? why still need it ?
usually how other companies will implement PostgreSQL together with other DB?
We are considering to use PostgreSQL as a open source DB as well as MySQL but from your point of view, what great is PostgreSQL?
we are currently using MS SQL on Azure and some MySQL/MariaDB, why PostgreSQL is good ? why still need it ?
usually how other companies will implement PostgreSQL together with other DB?
ASKER
PostgreSQL is noSQL, right?
"you'll end up paying more for people to work with it."
why?
"You'll always be stuck with either writing your own code or hassling with PostgreSQL problem due to minimal testing done by projects who do provide support."
ok. tks.
I am not sure why people from time to time use PostgreSQL !
"you'll end up paying more for people to work with it."
why?
"You'll always be stuck with either writing your own code or hassling with PostgreSQL problem due to minimal testing done by projects who do provide support."
ok. tks.
I am not sure why people from time to time use PostgreSQL !
ASKER
any kind of PostgreSQL topology diagram ? on how it HA and scale out ?
noSQL DB usually act as a file system on RAM, right?
noSQL DB usually act as a file system on RAM, right?
ASKER
as PostgreSQL also relational DB engine , and is also come from MySQL, why people use it but not MariaDB and MySQL ?
ASKER
PostgreSQL is the open source Oracle but why simply do not use MariaDB with SQL_Mode= oracle on?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
"PostgreSQL uses it's version of SQL."
someone tried to tell me they want to use PostgreSQL as it is open source Oracle, do you agree?
" also another important reason is the pluggable storage engine model"
pluggable storage engine also means if one day MariaDB get acquire by other company and want to kill it, the DB engine can backup and restore to other REAL open source DB, is that right?
but like MySQL 5.6 + and MariaDB 10.3.x , this model is not working any more, right? MariaDB and MysQL can't have replication setup between as their structure is not the same any more, do you agree on this ?
"So I'd have the same question, I'm unsure why people might use PostgreSQL either."
see my reply above.
someone tried to tell me they want to use PostgreSQL as it is open source Oracle, do you agree?
" also another important reason is the pluggable storage engine model"
pluggable storage engine also means if one day MariaDB get acquire by other company and want to kill it, the DB engine can backup and restore to other REAL open source DB, is that right?
but like MySQL 5.6 + and MariaDB 10.3.x , this model is not working any more, right? MariaDB and MysQL can't have replication setup between as their structure is not the same any more, do you agree on this ?
"So I'd have the same question, I'm unsure why people might use PostgreSQL either."
see my reply above.
ASKER
tks.
Likely best you stick with MariaDB, as development is faster, especially rolling in features like new storage engine.
If you go with PostgreSQL, it's just different enough, you'll end up paying more for people to work with it.
And most CMS systems either don't support PostgreSQL or provide support as an after thought, so rapid site setup using tech like WordPress will be impossible. You'll always be stuck with either writing your own code or hassling with PostgreSQL problem due to minimal testing done by projects who do provide support.