Databases: Difference between revisions
From wikinotes
(→Server) |
No edit summary |
||
Line 1: | Line 1: | ||
{{ SEEALSO || | |||
[[Programming: databases]] }} | |||
= Databases = | = Databases = | ||
<blockquote> | <blockquote> |
Revision as of 16:50, 11 October 2021
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!)