Databases: Difference between revisions
From wikinotes
Line 59: | Line 59: | ||
== Time-Series == | == Time-Series == | ||
{| class="wikitable" | {| class="wikitable" | ||
|- | |- | ||
Line 65: | Line 64: | ||
|- | |- | ||
|} | |} | ||
== Abstractions == | == Abstractions == |
Revision as of 00:52, 7 April 2023
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 mongodb Embeddable
pouchdb embeddable/replicatable couchdb couchbase lite embeddable/replicatable couchbase Time-Series
influxdb a FOSS timeseries database 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!)