Databases

This article is a Draft. Help us to complete it.

wikipedia:Database

Relational (SQL):

• MariaDB (2009) C, C++
• Microsoft SQL Server (1989)
• MySQL (1995) C, C++
• Oracle Database (1979)
• PostgreSQL (1996) C
• RocksDB (library) (2012) C++
• SingleStore (2013)
• Amazon Aurora (2014)

Key-value:

• Redis (2009) C
• RocksDB (2012) C++
• etcd
• Infinispan

Document-oriented:

• MongoDB (JSON) (2009)

Wide column store

• Apache Cassandra (2008)

Cloud

• AWS RDS
• InfluxDB

Other databases: Derby DB, Memcached, ClickHouse (2016)

Timeline

2015

• ScyllaDB
• CockroachDB

2005

• H2

2000

• SQLite

1996

• PostgreSQL

1995

• MySQL

1989

• Microsoft SQL Server

1979

• Oracle Database

Related terms

• ClickHouse
• Views
• OLTP, OLAP
• ACID: WAL
• SQL: EXPLAIN
• MemSQL
• Google trends: https://trends.google.com/trends/explore?date=today%205-y&q=PostgreSQL,MySQL,MariaDB
• Connect to a database
• Show databases
• Create database
• Delete database
• Create user
• List users
• List databases
• List tables: show tables
• GRANT

See also

• NoSQL: Graph database, document-oriented database, Couchbase, Amazon DynamoDB, Amazon DocumentDB, MongoDB, FoundationDB
• Key-value databases: Berkeley DB, Redis, etcd, leveldb, RocksDB (MyRocks), Infinispan, Amazon DynamoDB, Apache Zookeeper, LevelDB
• Databases: Database management, SQL, NoSQL, Wide column, PostgreSQL, MariaDB, MySQL, Derby DB, MongoDB, Cassandra, SQLite, HSQL2, H2, RocksDB, Microsoft SQL Server, DB2, Oracle Database, Memcached, Berkeley DB, Collation, SingleStore, Amazon Aurora, Graph database, Amazon DynamoDB, PrestoDB, Cache hit ratio, ACID, WAL, ARIES, DBMS, OLTP, OLAP, Database Schema, CockroachDB, Tables, Views, Apache Druid
• SQL, NewSQL: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint