search

idrice24 / School-Management-Software

The repository is to present the admin side of a school management system
Apache License 2.0
28 stars 20 forks source link

Postgres VS. MySQL #63

Closed Ghislain1 closed 4 years ago

Ghislain1 commented 4 years ago

Create a table to compare thoses technologies Table should gets:

  1. 2 Columns and many rows
  2. Each rows should contains Pro or Contra according to technologie
  3. Table should be in your wiki page
Examples of rows in table: Postgres MySQL
less popular more popular
highly extensible low extensible
idrice24 commented 4 years ago

PostgreSQL VS MySQL

DBMS MySQL PostgreSQL
Maintainer Oracle Corpoartion PostrateSQL Global Development Group
Max Database Size Theoretical Unlimited(256TB) Unlimited
Max Table Size MySAM: 256 TB; InnoDB: 64 TB 32 TB
Support OS YES YES
Usage Small to medium sized Database Medium sized Database
Full-Text Indexes Full-text indexes can be used only with MyISAM tables PostgreSQL support full text search with index.
Popularity More Popular les Popular
Extensibility low extensible highly extensible