aboutsummaryrefslogtreecommitdiffstats
path: root/docs/datastores.md
diff options
context:
space:
mode:
authorTyler Davis <tyler@gluecode.net>2025-01-31 06:07:27 +0000
committerTyler Davis <tyler@gluecode.net>2025-01-31 06:07:27 +0000
commit97842d43cc06cdd8e298d74ad6705af4348df49a (patch)
tree0c3f2393c03824968ed16128135ca743f1353286 /docs/datastores.md
parent509fe00d541ce769c4423a072318ad47294b7763 (diff)
downloadstandards-main.tar.gz
standards-main.zip
reflow linesHEADmain
Diffstat (limited to 'docs/datastores.md')
-rw-r--r--docs/datastores.md33
1 files changed, 23 insertions, 10 deletions
diff --git a/docs/datastores.md b/docs/datastores.md
index ef22c72..5d1955b 100644
--- a/docs/datastores.md
+++ b/docs/datastores.md
@@ -2,16 +2,23 @@
## Scope
-This standard prescribes database and data storage technologies used to solve many related data-retention concerns.
-The solutions recommended below are designed to encourage deep expertise in a few stable and well-understood systems, rather than maximal "fit" for each distinct use case.
+This standard prescribes database and data storage technologies used to
+solve many related data-retention concerns. The solutions recommended
+below are designed to encourage deep expertise in a few stable and
+well-understood systems, rather than maximal "fit" for each distinct use
+case.
-As such, the solutions may not be the most optimal but their performance, maintenance, optimizations, and reliability requirements are understood and supported by the engineering community.
+As such, the solutions may not be the most optimal but their
+performance, maintenance, optimizations, and reliability requirements
+are understood and supported by the engineering community.
## Terms
-- _Database_: provides long-term, durable storage for data whose loss or unavailability would mean violating an application's Availability or Business requirements.
-- _Cache_: provides short-term, volatile storage which does not preserve data.
- Caches are not in the scope of this standard.
+- _Database_: provides long-term, durable storage for data whose loss or
+ unavailability would mean violating an application's Availability or
+ Business requirements.
+- _Cache_: provides short-term, volatile storage which does not preserve
+ data. Caches are not in the scope of this standard.
## Capability Matrix
@@ -22,21 +29,27 @@ As such, the solutions may not be the most optimal but their performance, mainte
| [Document-Oriented] | X | X | X |
| [Object-Based] | X | X | X |
-_O_: While KV-stores cannot store relational data, some KV-focused databases provide relational-like "tagging" and other attribute aggregations.
+_O_: While KV-stores cannot store relational data, some KV-focused
+databases provide relational-like "tagging" and other attribute
+aggregations.
## Selection Criteria
### PostgreSQL
-Applications SHOULD use PostgreSQL (Aurora in Cloud environments and the latest stable release in OnPrem environments.)
+Applications SHOULD use PostgreSQL (Aurora in Cloud environments and the
+latest stable release in OnPrem environments.)
-PostgreSQL across all environments supports all storage methods including:
+PostgreSQL across all environments supports all storage methods
+including:
- Simple [Key-Value] stores (via [hstore])
- [Document-Oriented] storage and queries (via [jsonb])
- [Large-object] storage directly within the database
-If the application is running in the Cloud environment and needs a total data size over [64TB (RDS)][1] or [128TB (Aurora)][2], then it MUST use another approved option.
+If the application is running in the Cloud environment and needs a total
+data size over [64TB (RDS)][1] or [128TB (Aurora)][2], then it MUST use
+another approved option.
### DynamoDB