Difference between revisions of "Databases"
Jump to navigation
Jump to search
| (13 intermediate revisions by one other user not shown) | |||
| Line 4: | Line 4: | ||
{{Databases TOC}} | {{Databases TOC}} | ||
| − | Other databases: [[Derby DB]], [[Memcached]] | + | Other databases: [[Derby DB]], [[Memcached]], [[ClickHouse]] ([[2016]]) |
| − | == Timeline == | + | == [[Timeline]] == |
| + | |||
| + | [[2015]] | ||
| + | * [[ScyllaDB]] | ||
| + | * [[CockroachDB]] | ||
| + | |||
| + | [[2005]] | ||
| + | * [[H2]] | ||
[[2000]] | [[2000]] | ||
* [[SQLite]] | * [[SQLite]] | ||
| + | |||
| + | [[1996]] | ||
| + | * [[PostgreSQL]] | ||
[[1995]] | [[1995]] | ||
* [[MySQL]] | * [[MySQL]] | ||
| + | [[1989]] | ||
| + | * [[Microsoft SQL Server]] | ||
[[1979]] | [[1979]] | ||
| Line 21: | Line 33: | ||
== Related terms == | == Related terms == | ||
| − | * [[OLTP]] | + | * [[ClickHouse]] |
| − | * [[ACID]] | + | * [[Views]] |
| − | * [[SQL]] | + | * [[OLTP]], [[OLAP]] |
| + | * [[ACID]]: [[WAL]] | ||
| + | * [[SQL]]: [[EXPLAIN]] | ||
| + | * [[MemSQL]] | ||
| + | * [[Google trends]]: https://trends.google.com/trends/explore?date=today%205-y&q=PostgreSQL,MySQL,MariaDB | ||
{{TOC operation databases}} | {{TOC operation databases}} | ||
== See also == | == See also == | ||
| + | * {{NoSQL}} | ||
* {{Key-value databases}} | * {{Key-value databases}} | ||
* {{DBs}} | * {{DBs}} | ||
Latest revision as of 12:00, 19 February 2023
This article is a Draft. Help us to complete it.
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)
- Apache Cassandra (2008)
Other databases: Derby DB, Memcached, ClickHouse (2016)
Timeline[edit]
Related terms[edit]
- 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[edit]
- 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, 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,.sql
Advertising:
