Skip to content

Latest commit

 

History

History
130 lines (59 loc) · 2.85 KB

databases.md

File metadata and controls

130 lines (59 loc) · 2.85 KB

Databases

Table of Contents

MySql vs PostgreSql

What is MySql?

MySQL is an open-source relational database management system. Uses SQL a query language.It is also available in commercial version. MySQL is currently maintained by the Oracle Corporation.

What is PostgreSql?

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

Syntax

Both Databases use SQL(Structured Query Language). So syntaxes are identical across both databases. MySQL Query

SELECT * FROM users;

PostgreSQL query:

SELECT * FROM users;

MySql vs MongoDb

What is MySql?

MySQL is an open-source relational database management system. Uses SQL a query language.It is also available in commercial version. MySQL is currently maintained by the Oracle Corporation.

What is MongoDb?

MongoDB is a cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas.

Syntax

Mysql uses SQL(Structured Query Language). So syntaxes are very different across both databases. MySQL Query

SELECT * FROM users;

MongoDb query:

MongoDb vs DynamoDb

What is MongoDb?

MongoDB is a cross-platform document-oriented database program. Classified as a NoSQL database program, MongoDB uses JSON-like documents with optional schemas.

What is DynamoDb?

Amazon DynamoDB is a fully managed proprietary NoSQL database service that supports key-value and document data structures and is offered by Amazon.com as part of the Amazon Web Services portfolio.

Syntax

Redis vs Memcached

What is Redis?

Redis is an open source (BSD licensed), in-memory data structure store, used as a database, cache, and message broker.

What is Memcached?

Free & open source, high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load.

Syntax

Dgraph vs Neo4j

What is Dgraph?

Dgraph is the most popular graph database out there with over 15k stars on github. Dgraph comes with out of the box support to Graphql.

What is Neo4j?

Neo4j is popular open source Graph Database developed using java programming language.

Syntax