Databases: Difference between revisions
From wikinotes
No edit summary |
|||
| (3 intermediate revisions by the same user not shown) | |||
| Line 16: | Line 16: | ||
| [[cassandra]] || Db with strong focus on clustering, high availability, safety | | [[cassandra]] || Db with strong focus on clustering, high availability, safety | ||
|- | |- | ||
| [[prestodb]] || | | [[prestodb]] || | ||
|} | |} | ||
</blockquote><!-- Server --> | </blockquote><!-- Server --> | ||
| Line 42: | Line 42: | ||
| [[couchbase]] || NoSQL document db with multi-master bidirectional replication | | [[couchbase]] || NoSQL document db with multi-master bidirectional replication | ||
|- | |- | ||
| [[ | | [[mongodb]] || | ||
|} | |} | ||
</blockquote><!-- Server --> | </blockquote><!-- Server --> | ||
| Line 57: | Line 57: | ||
</blockquote><!-- Embeddable --> | </blockquote><!-- Embeddable --> | ||
</blockquote><!-- NoSQL --> | </blockquote><!-- NoSQL --> | ||
== Time-Series == | |||
<blockquote> | |||
{| | |||
|- | |||
| [[influxdb]] || a FOSS timeseries database | |||
|- | |||
|} | |||
</blockquote><!-- Time-Series --> | |||
== Abstractions == | == Abstractions == | ||
Latest revision as of 00:53, 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!)
