diff options
author | Tyler Davis <tyler@gluecode.net> | 2025-01-31 06:07:27 +0000 |
---|---|---|
committer | Tyler Davis <tyler@gluecode.net> | 2025-01-31 06:07:27 +0000 |
commit | 97842d43cc06cdd8e298d74ad6705af4348df49a (patch) | |
tree | 0c3f2393c03824968ed16128135ca743f1353286 /docs/datastores.md | |
parent | 509fe00d541ce769c4423a072318ad47294b7763 (diff) | |
download | standards-main.tar.gz standards-main.zip |
Diffstat (limited to 'docs/datastores.md')
-rw-r--r-- | docs/datastores.md | 33 |
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 |