Results 1 to 5 of 5

Thread: Postgresql vs Mysql database

  1. #1
    Join Date
    Jul 2009
    Posts
    127

    Postgresql vs Mysql database

    I just wanted to know if you all can tell something on this topic.I am using Drupal 6.x on postgresql besides mysql database. Is there any major differences in terms of performance, module behavior, etc?It seems that in drupal 6 the database abstraction is termed to be able to handle postgres or other major dbms, some of the friend of mine talking the postgres support is going away for drupal 7.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,948

    Postgresql vs Mysql database

    PostgreSQL, is one of the database which is an object-relational database management system.It introduced with an MIT-style license and distributed under open source software.

    As the rule and functioning of the open source community,the PostgreSQL database is not controlled by a single company, but has a global community of developers and companies. It is developed under the object oriented environment.

    The postgreSQL database includes a lot of functionality like another databases as a relational database.

  3. #3
    Join Date
    May 2008
    Posts
    2,012

    Postgresql vs Mysql database

    There are so many things can be included in comparison of two or more than two databases,It is not so easy to tell but you can measure according to their provided functionality-

    The different thing are listed here through which you can choose appropriate back end database for your application.

    1- Features
    2- Support
    3- Ease-of-use
    4- Stability
    5- Speed
    6- Existing skills
    7- Licensing

    If you look for these properties for a database then you can decide which one would be better for you to use.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,005

    Postgresql vs Mysql database

    If we look for the features of both databases(PostgreSQL and MySQL) then we find that PostgreSQL has the upper hand where as the MySQL stable version is not able to support the sub-queries, stored procedures, sub-queries, cursors and views but the PostgreSQL database performs all this .

    There are some serious mistakes was committed by the developers of MySQL database .They didn't include some features which is related object oriented environment like referential integrity which is partially integrated with MySQL database and they claimed that it is not so much necessary feature for this database.

  5. #5
    Join Date
    May 2008
    Posts
    2,297

    Postgresql vs Mysql database

    You are confused about the performance of the database . MySQL provides fast accessing of the database.

    MySQL can be used in extremely heavy load and operational environments without problems. PostgreSQL's advanced facilities are much likely to be stable than the newer MySQL equivalents. However, replication is much newer in PostgreSQL than MySQL, so the reverse applies. But here again, the supposed commercialization of databases means that database stability is taken relatively for granted, and the software tends to be a lot more stable than the hardware it relies on.

Similar Threads

  1. How to connect to Postgresql database
    By Xziibit in forum Software Development
    Replies: 5
    Last Post: 05-08-2011, 02:01 PM
  2. How to connect PHP to mySQL Database
    By Nathen in forum Tips & Tweaks
    Replies: 2
    Last Post: 17-07-2011, 03:49 AM
  3. mysqldump in MySQL database
    By Caden Fernandes in forum Software Development
    Replies: 4
    Last Post: 04-03-2010, 11:02 PM
  4. Need MySQL database directory
    By Osman84 in forum Software Development
    Replies: 4
    Last Post: 27-02-2010, 05:18 AM
  5. Replies: 3
    Last Post: 07-11-2009, 09:36 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,720,873,086.98833 seconds with 17 queries