MySQL compared with PostgreSQL

PSNC have published a comparison of MySQL 4.1 and PostgreSQL 8.0.

If you’re interested to know what features you’re missing out on by using MySQL rather than PostgreSQL, the comparison table provides a handy summary. MySQL 5.0 (in development) is getting closer to PostgreSQL’s impressive feature set, with Views and Stored Procedures on the list. According to the article, however, MySQL still beats PostgreSQL in terms of performance. Details of a number of benchmarks are given.

MySQL has certainly made progress since I began using it, adding support for subqueries (in 4.1), full text searching with boolean, and transactions (InnoDB).

From the article:

MySQL is simplier than PostgreSQL but much faster. MySQL doesn’t support many advanced features that may be important in huge relational and complicated databases. But for JRA1 measurement architecture MySQL should be adequate (we probably wouldn’t use the most advanced features).

Currently, MySQL is a staple of the LAMP (Linux, Apache, MySQL, and PHP) architecture, pre-installed on many hosting accounts and bundled with many operating systems. This makes it very attractive to novices and intermediate web programmers, as it is relatively easy and cheap to get started playing around with it. With its expanding feature set and dual license, MySQL is looking to expand its usage in other market segments.

The article also contains link to more detailed comparison information, such as the feature comparison page at

Via Open Source Versus, check it out.


Category: programming Time: 2005-05-02 Views: 1

Related post

  • How mature is the Firebird database when compared with PostgreSQL and MySQL? 2011-07-24

    I have used PostgreSQL with small projects and MySQL is running in production environment. No issues with them. I have been hearing of Firebird which is again a solid RDBMS in the open-source area. How reliable, ANSI-SQL compliant and stable it is wh

  • Installing mysql server with postgresql 2016-03-06

    I'm using backbox 4.4 which it was built-in with postgresql. Yesterday i think about "can i installing mysql database along side postgresql database ? ", i want to learn database connection but i so unfamiliar with postgresql, what i want to ask

  • Install MediaWiki with PostgreSQL instead of MySQL 2011-12-21

    I need to install MediaWiki with PostgreSQl as database backend on an 10.04 server. I would prefer to install MediaWiki via apt-get/aptitude but I don't know how to configure the installation not to install the unneeded MySQL. Is it possible to chang

  • multi-master to single-slave replication at table level with PostgreSQL or MySQL 2013-02-25

    Here is my scenario Master1 hosting DB1 Master2 hosting DB2 ... MasterN hosting DBN replicate to: Slave1 hosting DB1,DB2... DBN I've read similar questions and they recommend to start different instances at Slave1 and simply do MasterN-Slave1(instanc

  • How to convert a MySQL database to PostgreSQL? 2012-03-29

    Is there any command line tool for converting the MySQL database to PostgreSQL? I'd also like to know if there is a way to convert the database using the normal mysqldump command. --------------Solutions------------- have you tried: mysqldump --compa

  • How to search a MySQL database with encrypted fields 2012-09-07

    Suppose I need to encrypt certain table-fields of a MySQL database. Additionally, I need to search some of those fields I did encrypt. How would one search those fields anyway? Decrypting each record step by step is no option: Suppose I have multiple

  • Beginning Databases with PostgreSQL - Chapter 15: Accessing PostgreSQL from PHP 2001-11-21

    This article is an excerpt of the book, Beginning Databases with PostgreSQL (Wrox Press, 2001), and is reprinted here by permission. Recently, there has been a strong trend towards providing web-based interfaces to online databases. There are a numbe

  • Joomla 1.5 with Postgresql 8.4 2011-02-07

    can anybody guide me to get to work Joomla 1.5.X with a postgres 8.4 database ? Thanks --------------Solutions------------- Postgresql is not supported by Joomla. Joomla 1.5 has no support for PostgreSQl, only MySQL. PostgreSQL support has been start

  • MySql DB with ext3 and XFS 2011-05-23

    Is there any advantage for XFS file system compared with ext3, With MYSQL DB ? Which is safest file system for hosting MYSQL DB ? --------------Solutions------------- XFS was designed to handle large files efficiently. This could be an advantage if y

  • Can't get Dell PE T420 (Perc H710) perform better than a MacMini with PostgreSQL 2015-03-27

    It's months that I'm trying to solve a performance issue with PostgreSQL. SYSTEM CONFIGURATION Our deployment machine is a Dell PowerEdge T420 with a Perc H710 RAID controller configured in this way: VD0: two 15k SAS disks (ext4, OS partition, WAL pa

  • How to Install Gitlab with PostgreSQL and Nginx on Ubuntu 15.04 2015-08-28

    Gitlab is a web-based git repository management application written on Ruby. It is similar to GitHub and includes features like a project wiki and issue tracking system. The Gitlab project was started by Dmitriy Zaporozhets and the software is used b

  • To get PHP communicate with PostgreSQL 2009-08-05

    My PHP code which I try to use in Firefox <?php // Connecting, selecting database $dbconn = pg_connect("host=localhost dbname=masi user=postgres password=abc") or die('Could not connect'); ?> I get Warning: pg_connect() [

  • install mysql client and mysql-server with default charset utf8 to fedora 11 2009-09-01

    I only have utf8 characters to put into my db so like everything in the db is utf8. I tried 'yum install mysql mysql-server -with-charset=utf8' but it is not right. if i install using ''yum install mysql mysql-server' i got defaut latin1 charset. Any

  • Monitoring MySQL clusers with Nagios 2009-10-09

    I'm trying to figure out how to monitor MySQL clusters with Nagios. I have found the following information at, however I have got nowhere. How exactly do I install plugins? -

  • Replicate MySQL database with "non-permanent" write 2010-02-23

    I'm working with a production MySQL database and I would like to: Create a read-only slave copy of the database that gets updates from the master. The master is the only one that can be written onto. Have "non-permanent write" access to the slav

  • what is the advantage of using Linux compared with Windows OS? 2010-06-08

    Hi what is the advantage of using Linux server compared with Windows .. except secure and open source answer. --------------Solutions------------- you're cool some stuff doesn't work on windows, I'm currently trying to find a C-- compiler for the win

  • Bash command not found (trying to integrate Beyond Compare with Mercurial and using it within Cygwin) 2010-09-30

    I'm trying to integrate beyond compare with mercurial and I've copy & pasted the necessary lines from the Using Beyond Compare with Version Control Systems page for mercurial into my .hgrc file located in C:\cygwin\home\jerickson (my cygwin home dir)

  • Comparator with two noninverting inputs? 2010-11-13

    On page 7 of the LTC3631 datasheet, the diagram shows a comparator with two noninverting inputs. What does such a comparator do? --------------Solutions------------- In this context, it means that the comparator can be triggered by comparison of the

  • How can I convert from Double Precision to Bigint with PostgreSQL? 2011-06-22

    I need to convert a value of Double Precision to Bigint with PostgreSQL. How can I do that? I have tried with to_bigint(myvalue) but that function didn't exist. --------------Solutions------------- There are two ways to typecast in Postgres: You eith

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 1.266 (s). 13 q(s)