Databases

From wikinotes
Revision as of 16:51, 11 October 2021 by Will (talk | contribs)

NOTE:

See Also Programming: databases

Databases

Relational

Server

MySQL Tried tested and True, one of the kings of relational databases.
postgresql Combined Relational/NoSQL database
cassandra Db with strong focus on clustering, high availability, safety
prestodb

Embeddable

sqlite Lightweight, Single-User, file-based database.
rqlite fault tolerant sqlite, replicated across several nodes for fault tolerance
indexeddb abstraction over sqlite, for replication/offline mode

NoSQL

Server

couchdb NoSQL document db with multi-master bidirectional replication
couchbase NoSQL document db with multi-master bidirectional replication
monbodb

Embeddable

pouchdb embeddable/replicatable couchdb
couchbase lite embeddable/replicatable couchbase

Abstractions

symmertricDS OpenSource translation layer to allow replication between different types of SQL databases

Database Clients

couchdb

cdbcli interactive python interface for couchdb

SQL

dbext vim SQL interface

MySQL

mycli interactive mysql interface (with tab completion/syntax highlighting (prompt_toolkit!))

Postgress

pgcli interactive postgresql interface (prompt_toolkit!)