PostreSQL is a great SQL platform that is truly SQL, unlike MySQL that has forked from the standard. MySQL is definitely the thing to run if your software was built to run on LAMP, but if you are starting from scratch there is a lot of advantages to running PostgreSQL
Tag: postgres vs mysql, postgresql, vs, mysql, lamp, sql, open, source, LAMP (software Bundle), Management, Data, database
Xem thêm: https://meohay360.com/category/internet
33 thoughts on “PostgreSQL Vs. MySQL”
Points for (for some reason) not saying "Seequel"!
It will be interesting to watch MariaDB and Percona, forks of MySQL. But you can never go wrong when you go with PostgreSQL. Rock-solid.
Is there a spinach on his teeth?
“MySQL is not ACID complaint” you are from which planet??
When you mention "mySQL" do you really mean "MariaDB"? PostgreSQL is free for commercial use (BSD license). However, I discovered a couple of years back that mySQL was NOT free for commercial use and had commercial licensing similar to Microsoft SQL Server. Is this still the case?
I watched this just to know how PostgreSQL is actually pronounced. Okay bye.
so stop the shity talk and tell me wich one is better and stop saying "it depends" that is not an answer
I had problems running MySQL, even if in past was succesful. However found MySQL deals different with views and is strict with data types, making me keep an separate schema or having to modify existing code, to handle basic db operations to provide for MySQL expected datatype. Not interested, stick to PostgreSQL and SQLite.
o postgres tá lento pra caramba. já fiz todos os tutoriais de tunning pra melhorar a velocidade e continua lento. pra comparar: uma tabela com 60 milhos de linhas e 7 colunas, um select que resulta em 10 linhas leva dois minutos. se eu fizer a mesma pesquisa usando grep em um csv retorna o resultado em 40 segundos. alguém tem alguma sugestão de melhorias e ajustes para o postgres?
How are different between PostgreSQL and SQL Server?
I feel like this video was 10 minutes too short. It leaves a lot on the table about resources usage, data types, ACID compliance rules, etc. Feels pretty biased and over simplified.
Thanks for the clear and concise comparison.
can you do a compare on Postgresql vs MONGO?
MySQL is not ACID compliant?.. In which world you live?
You mean InnoDB storage engine is not ACID capable?
Request you talk about things you are sure about…. rather than misleading people with wrong information and assumptions.
hi how to distribute database from server to dev clients , just like we share database on mysql workbench
MySQL is alot better nowadays and a fairly reliable option for a database server. I agree that PostgreSQL is a better choice in most cases. MySQL used to shine with it's limited resource usage and easy to set-up in smaller projects, but SQLite is an excellent alternative in these cases.
PostgreSQL is flat-out JUICY for an open-source database. Superb IMO.
As others have said, comparing raw performance between the two can be tough. But here's my $0.02:
MySQL does rather well with simple queries, particularly when memory is constrained. Need a key/value pair storage? MySQL is great. PostgreSQL stomps the ever loving stuffing out of MySQL when you have very large queries with a complex schema, and lots of RAM is available.
Give PostgreSQL gobs of RAM and it will make very effective use of it. Also, OP does a terrible job of describing ACID.
Anyone with a homophobic handle leaving criticism is not worth listinging too. I'm not defensive. I'm just not tolerant of stupid people.
oracle must DIE fuck oracle, you do not want to go public and then get money and switch to oracle, when your money is better spent on hardware. POstgresql and firebird DB are both better than mysql or mariaDB. MariaDB has hope but is far behind firebird and postgresql. Python people dont ignore zodb
Great video Brandon and thanks for sharing. I have been using Postgresql for 1 year now, and totally love it.
Performance in a video is hard. Both have query types they are fast and slow at, and both can be optimized for different sized data sets… Hard to say what is faster in very general terms.
Was expecting a little more on performance information because for a lot a people thats what the choice comes down too. But good video none the less.
There is both ACID Compliance and an ACID Certification of compliance. This is done because there are varying levels of ACID based on scale.
whats with this attitude hummmm
PostgreSQL is FANTASTIC, I like it
The default installation does not do multi-master replication. Wether that is a real problem for your setup depends entirely on the setup, why do you use multi-master replication?
With MySQL seeming to be in use more on Linux systems and the way Oracle is treating MySQL, what about MariaDB which is promoted as a drop in replacement for MySQL?
Nobody wants to hear your bitching, tennis4free. Hire a tutor if you are not happy.