db system list

Supported DB systems

• PostgreSQL
  • CockroachDB
    • PostgreSQL wire protocol: https://www.cockroachlabs.com/docs/stable/frequently-asked-questions.html
    • compatibility: https://www.cockroachlabs.com/blog/why-postgres/
  • Timescale -- built on postgresql
    • compatible: https://docs.timescale.com/v1.2/faq
• MySQL
  • MariaDB
• SQLite3
• Cassandra
  • Scylla
    • uses CQL binary protocol v3: https://docs.scylladb.com/getting-started/scylla_drivers/

Other DB systems

• MongoDB -- document db
• RethinkDB -- document db
• Redis -- in-memory "store" w/ rich values
  • protocol: https://redis.io/topics/protocol
• Apache CouchDB -- JSON document?
  • protocol: HTTP+JSON, http://docs.couchdb.org/en/stable/api/index.html
  • nearly just store + retrieve?
  • guide: http://guide.couchdb.org/
• Google BigQuery
  • protocols: REST/HTTP vs gRPC: https://cloud.google.com/apis/docs/client-libraries-explained
• Firebird -- relational
• Amazon DynamoDB -- nosql
  • protocol: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Programming.LowLevelAPI.html
• Apache Hive -- SQL-like?
  • protocol: Thrift-based
• Neo4j -- graph db
  • protocols https://neo4j.com/developer/language-guides/
    • Bolt: https://boltprotocol.org/
    • HTTP? (deprecated?)
• PrestoDB
  • protocol: HTTP: https://github.com/prestodb/presto/wiki/HTTP-Protocol
• Apache Impala
  • protocol: compatible with Apache Hive?
• Apache Accumulo
  • protocol: Thrift-based
• Bedrock
  • protocol: speaks MySQL protocol, also has text/json-based custom protocol

---

References

• https://geekflare.com/open-source-database/