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

2000

• SQLite

1995

• MySQL

1979

• Oracle Database

Related terms

• OLTP
• ACID
• SQL
• Connect to a database
• Show databases
• Create database
• Delete database
• Create user
• List users
• List databases
• List tables: show tables
• GRANT

See also

• Key-value databases: Berkeley DB, Redis, etcd, leveldb, RocksDB (MyRocks), Infinispan, Amazon DynamoDB, Apache Zookeeper, LevelDB, RocksDB, Pebble
• 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, RDMS
• SQL, NewSQL, RDMS: 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