Docs menu
On this page

Type reference

Built-in types: data

Last updated

Databases, caches, search engines, warehouses and storage: the components that keep data, with the operations their clients send. Generated from data.proschi; component types explains how to read and extend them.

Data #

A component that keeps data: a database, cache, search index, warehouse or bucket.

Database #

A relational database queried with SQL, whose product does not matter.

PostgreSQL #

PostgreSQL, the open source relational database.

MySQL #

MySQL, the open source relational database.

MariaDB #

MariaDB, the community fork of MySQL.

SQLite #

SQLite, the embedded relational database in a single file.

Oracle #

Oracle Database, the commercial relational database.

SQL Server #

Microsoft SQL Server, the commercial relational database.

TimescaleDB #

TimescaleDB, PostgreSQL extended for time series.

Distributed SQL Database #

A relational database that shards and replicates itself across nodes, keeping transactions.

CockroachDB #

CockroachDB, a distributed SQL database that speaks the PostgreSQL protocol.

YugabyteDB #

YugabyteDB, a distributed SQL database compatible with PostgreSQL.

TiDB #

TiDB, a distributed SQL database compatible with MySQL.

Vitess #

Vitess, which shards MySQL behind one SQL endpoint.

NoSQL Database #

A non-relational database that partitions data by key, whose product does not matter.

DynamoDB #

DynamoDB, the managed key-value and document database: reads by key or partition, a Scan reads the whole table.

  • Extends: NoSQL Database › Data › Component
  • Extended by: AWS DynamoDB
  • Kind: database
  • Read: GetItem, BatchGetItem, Query, TransactGetItems, DescribeTable, Scan (latency ×10, cost ×25), plus 1 from NoSQL Database, 3 from Data
  • Write: PutItem, UpdateItem, DeleteItem, BatchWriteItem, TransactWriteItems, ExecuteStatement, CreateTable, UpdateTable, DeleteTable, plus 3 from NoSQL Database, 8 from Data

Document NoSQL Database #

A NoSQL database that stores JSON-like documents and queries their fields.

MongoDB #

MongoDB, the document database.

CouchDB #

Apache CouchDB, a document database with an HTTP API and multi-primary replication.

Couchbase #

Couchbase, a document database with a built-in cache.

Wide-Column NoSQL Database #

A NoSQL database of rows with many columns, partitioned by key and sorted within a partition.

Cassandra #

Apache Cassandra, the wide-column database queried with CQL.

ScyllaDB #

ScyllaDB, a Cassandra-compatible database written in C++.

HBase #

Apache HBase, the wide-column database on HDFS.

Graph NoSQL Database #

A graph database: nodes and relationships, queried by pattern.

Neo4j #

Neo4j, the graph database queried with Cypher.

Coordination Store #

A small, strongly consistent store for configuration, leader election and locks.

  • Abstract. A node uses a type that extends it.
  • Extends: Data › Component
  • Extended by: etcd, ZooKeeper
  • Kind: database
  • Read: GET, WATCH, plus 3 from Data
  • Write: PUT, DELETE, plus 8 from Data

etcd #

etcd, the consistent key-value store behind Kubernetes.

ZooKeeper #

Apache ZooKeeper, the coordination service of znodes and watches.

Cache #

An in-memory key-value cache, whose product does not matter.

Redis #

Redis, the in-memory data store, used as a cache.

  • Extends: Cache › Data › Component
  • Extended by: Valkey, KeyDB, Dragonfly, AWS ElastiCache, GCP Memorystore, Azure Cache for Redis
  • Kind: cache
  • Protocol: RESP
  • Read: GETRANGE, STRLEN, EXISTS, TTL, PTTL, TYPE, KEYS, SCAN, HGET, HMGET, HGETALL, HEXISTS, HKEYS, HVALS, HLEN, HSCAN, LRANGE, LLEN, LINDEX, SMEMBERS, SISMEMBER, SMISMEMBER, SCARD, SRANDMEMBER, SINTER, SUNION, SDIFF, SSCAN, ZRANGE, ZREVRANGE, ZRANGEBYSCORE, ZREVRANGEBYSCORE, ZRANGEBYLEX, ZSCORE, ZMSCORE, ZRANK, ZREVRANK, ZCARD, ZCOUNT, ZSCAN, GETBIT, BITCOUNT, BITPOS, PFCOUNT, GEOSEARCH, GEODIST, GEOPOS, GEOHASH, GEORADIUS, GEORADIUSBYMEMBER, SUBSCRIBE, PSUBSCRIBE, UNSUBSCRIBE, PUNSUBSCRIBE, SSUBSCRIBE, XREAD, XREADGROUP, XRANGE, XREVRANGE, XLEN, XPENDING, XINFO, MULTI, EXEC, DISCARD, WATCH, UNWATCH, PING, plus 2 from Cache, 3 from Data
  • Write: SETNX, SETEX, PSETEX, GETSET, GETDEL, GETEX, MSET, MSETNX, APPEND, SETRANGE, INCR, INCRBY, INCRBYFLOAT, DECR, DECRBY, DEL, UNLINK, PEXPIRE, EXPIREAT, PEXPIREAT, PERSIST, RENAME, COPY, HSET, HSETNX, HMSET, HDEL, HINCRBY, HINCRBYFLOAT, LPUSH, RPUSH, LPUSHX, RPUSHX, LPOP, RPOP, BLPOP, BRPOP, LSET, LREM, LTRIM, LINSERT, LMOVE, BLMOVE, SADD, SREM, SPOP, SMOVE, SINTERSTORE, SUNIONSTORE, SDIFFSTORE, ZADD, ZREM, ZINCRBY, ZPOPMIN, ZPOPMAX, BZPOPMIN, BZPOPMAX, ZREMRANGEBYSCORE, ZREMRANGEBYRANK, ZUNIONSTORE, ZINTERSTORE, ZRANGESTORE, SETBIT, BITOP, PFADD, PFMERGE, GEOADD, GEOSEARCHSTORE, PUBLISH, SPUBLISH, XADD, XACK, XCLAIM, XAUTOCLAIM, XDEL, XTRIM, XGROUP, EVAL, EVALSHA, FCALL, plus 3 from Cache, 8 from Data

Valkey #

Valkey, the open source fork of Redis.

KeyDB #

KeyDB, a multithreaded fork of Redis.

Dragonfly #

Dragonfly, an in-memory store compatible with Redis.

Memcached #

Memcached, the simple distributed in-memory cache.

  • Extends: Cache › Data › Component
  • Kind: cache
  • Read: GETS, plus 2 from Cache, 3 from Data
  • Write: ADD, REPLACE, APPEND, PREPEND, CAS, INCR, DECR, TOUCH, GAT, GATS, FLUSH_ALL, plus 3 from Cache, 8 from Data

Hazelcast #

Hazelcast, the in-memory data grid.

Aerospike #

Aerospike, the key-value store tuned for memory and flash.

Search Engine #

A full-text search index, whose product does not matter.

Elasticsearch #

Elasticsearch, the distributed search engine on Lucene.

OpenSearch #

OpenSearch, the open source fork of Elasticsearch.

Solr #

Apache Solr, the search server on Lucene.

Meilisearch #

Meilisearch, a fast search engine for search-as-you-type.

Typesense #

Typesense, an in-memory search engine that tolerates typos.

Algolia #

Algolia, the hosted search API.

Data Warehouse #

A column store for analytical SQL over large data, whose product does not matter.

Snowflake #

Snowflake, the cloud data warehouse.

ClickHouse #

ClickHouse, the column-oriented OLAP database.

Apache Druid #

Apache Druid, the real-time analytics database.

Apache Pinot #

Apache Pinot, the real-time OLAP store for user-facing analytics.

Databricks #

Databricks, the lakehouse platform on Spark.

Time Series Store #

A database of timestamped measurements, queried over time ranges.

  • Abstract. A node uses a type that extends it.
  • Extends: Data › Component
  • Extended by: InfluxDB, Prometheus
  • Kind: analytics
  • Read: QUERY, SELECT, plus 3 from Data
  • Write: INSERT, plus 8 from Data

InfluxDB #

InfluxDB, the time series database.

Prometheus #

Prometheus, the monitoring system and its time series store.

Object Storage #

A bucket of objects (files) by key, whose product does not matter.

MinIO #

MinIO, the self-hosted object storage with the S3 API.

Ceph #

Ceph, the distributed object, block and file storage.

Shared File System #

A file system many machines mount at once.

HDFS #

HDFS, the Hadoop distributed file system.

Block Storage #

A disk attached to one machine.

Edit this page on GitHub