1 / 13

MySQL Vs. PostgreSQL comparison from a layman’s perspective

This comparison delves into MySQL and PostgreSQL from a non-technical perspective, focusing on key criteria such as ease of installation, administration, user community support, and application implementation possibilities. Both databases are noted for their installation simplicity and thorough documentation. MySQL generally has better support and administration tools, making it a more favorable choice for certain applications. This analysis is particularly aimed at public libraries, schools, and individuals considering which database to adopt.

noe
Télécharger la présentation

MySQL Vs. PostgreSQL comparison from a layman’s perspective

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. By: Bhalchandra MySQL Vs. PostgreSQLcomparison froma layman’s perspective

  2. Agenda Understand application. Comparison Criteria Ease of installation. Ease of administration. User Community / Other support. Demo

  3. Not on Agenda Database storage Vs. file storage. Application implementation possibilities.

  4. xyz.com Animated books for kids. Interactive content. Targeted market Public Libraries Schools Individuals

  5. Comparison Criteria Ease of installation. Both data bases were easy to install. Complete documentation is available separately.

  6. Comparison CriteriaUser community/Other Support. http://lists.mysql.com/ http://forums.mysql.com/

  7. Comparison CriteriaUser community/Other Support. http://www.postgresql.org/community/lists/ http://www.postgresqlforums.com/forums/

  8. Comparison CriteriaUser community/Other Support. MySQL PostgreSQL Google Search results 168,000 for PostgreSQL forums 108,000 for PostgreSQL lists Amazon.com Books › “PostgreSQL" 880 Results Milner Library (PostgreSQL)[in Title Words] 3 entries.   • Google Search results 1,030,000 for MySQL forums 293,000 for MySQL lists • Amazon.com Books › "MySQL" 2,782 Results • Milner Library (MySQL)[in Title Words] 35 entries.

  9. Comparison Criteria Ease of administration. DEMO

  10. Conclusion Installation was easy for both. Support wise MySQL is better. Administration wise MySQL is better. All in all for this application MySQL is a better alternative.

  11. References MySQL Deserves a Double Take, Reuven Learner,  Linux Journal Archive, Volume 2007, Issue 156 (April 2007) P.18 Open-source databases, Part II: PostgreSQL,  Reuven Learner, Linux Journal archive, Volume 2007 ,  Issue 157  (May 2007) P.16

  12. References Open-source databases,Part3;choosing a database,  Reuven Learner,  Linux Journal Archive,Volume 2007, Issue 158 (June 2007) P.17 www.postgresql.org. www.mysql.com

  13. Thank You…

More Related