Working with Databases (Part-1)

CouchDB

Developed by: Apache

Features

  • Implementation
  • Conflicts
  • Distributed Updates and Replication
  • Security and Validation
  • Compaction
  • JavaScript View Functions
  • ACID Properties

Written in

Pros of CouchDB

  • Serialized objects can be stored as unstructured data in JSON formatted documents highly desirable for Web and Mobile Applications.
  • RESTful HTTP API provides flexible and seamless database operations.
  • Scalable distributed high availability solution with replication capability for redundant data storage.

Cons of CouchDB

  • NoSQL DB can become a challenge for seasoned RDBMS users.
  • The map-reduce paradigm can be very demanding for first-time users.
  • JSON format documents with Key-Value pairs are somewhat verbose and consume more storage.

MySQL
Developed by: Oracle Corporation

Written in C, C++

  • Latest version: 8.0.2121
  • Download: MySql

FEATURES

  • Scalable
  • Easy to use
  • High Security
  • Supports Novell Cluster Services
  • Fast
  • Runs on many operating systems

PROS OF MYSQL

  • supports large databases, up to 50 million rows or more in a table
  • open-source
  • Implement a variety of user interfaces

CONS OF MYSQL

  • No built-in support for XML or OLAP
  • Support is available for the free version
  • Take a lot of time and effort to create incremental backups

PostgreSQL

Developed by: PostgreSQL Global Development Group

Written in C

Latest version: 12.3

Blog: PostgreSQL

Download: PostgreSQL

FEATURES

  • Support for tablespaces, as well as for stored procedures, joins, views, triggers, etc.
  • Multi-version concurrency control (MVCC)
  • Point-in-time recovery
  • Foreign keys
  • Asynchronous replication

PROS OF POSTGRESQL

  • Predefined functions
  • A number of interfaces
  • Scalable
  • Supports JSON

CONS OF POSTGRESQL

  • Less-mature replication software
  • Configuration can be confusing

MariaDB

Latest Version: 10.5.8GA

Written in: C , C++ , Perl

Pros and Cons

  • High availability through the MariaDB TX Cluster.
  • Performance improvement with proxy for MariaDB, MaxScale.
  • Great support, respond quickly to questions.
  • Constant evolution of the product.
  • Improving the migration of databases from MySQL to Maria DB, by default they are done easily but as there is an error it is costly to solve it.
  • Some minor bugs in MariaDB version updates.

Download : MariaDB

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store