Experiments

Database_Types_SQL

1 min read

SQL Databases

Types

  • MySQL
  • PostgresQL
  • SQLite
  • MSSQL
  • MariaDB
  • Oracle

MySQL

  • open source and also acquired/owned by Oracle
  • pros
    • portable and lightweight
    • easy and simple to use
  • cons
    • not SQL standards compliant
    • not scalable

PostgresQL

  • open source
  • pros:
    • compliant with SQL standards
    • deal with JSON and XML
  • cons:
    • lacks advanced monitoring and auditing

SQLite

  • open source
  • embedded database
  • pros:
    • highly portable
    • CRUD on SQLite are faster than file system
  • cons:
    • unsuitable for large data
    • limits multi-user capability

MSSQL

  • developed by Microsoft
  • pros
    • suitable for large businesses
    • wide community and good documentation
    • integrated with Azure SQL Databases
  • cons
    • not free, follows pay-as-you-go model
    • dynamic licensing model

MariaDB

  • open source fork of MySQL
  • pros
    • performs better than MySQL
    • remarkable performance in flash data
    • advanced security features
  • cons
    • small community

Oracle

  • developed by Oracle
  • pros
    • global community and good documentation
    • store massive amounts of data
  • cons
    • not beginner friendly
    • requires external infrastructure

Backlinks