From 3431e667a5c6475043ebfd97b43a3fdc4b078596 Mon Sep 17 00:00:00 2001 From: Phil Burton Date: Mon, 25 Feb 2019 13:37:59 +0000 Subject: Refactor and clean up notes --- day1/non-scalar-data.txt | 59 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 59 insertions(+) create mode 100644 day1/non-scalar-data.txt (limited to 'day1/non-scalar-data.txt') diff --git a/day1/non-scalar-data.txt b/day1/non-scalar-data.txt new file mode 100644 index 0000000..908cf84 --- /dev/null +++ b/day1/non-scalar-data.txt @@ -0,0 +1,59 @@ +# Non-Scalar Data +https://joind.in/event/php-uk-conference-2019/storing-non-scalar-data +Derick Rethans + +## Redis sets SSAD + +- key binding - safe string +- sets of data +- taggable + +## Document data stores +- Usually JSON +- Richer +- MongoDB - single master +- CouchDB - multi master +- ES - text search index + +## MongoDB +- pecl/mongodb +- mongodb/mongodb + +docs are PHP objects or assoc arrays + +## Relational Database +- normalisation + +- postgres + - HSTORE + - JSON/JSONB + + +# Querying data + +Sets - SISMEMBER and SMEMBER +- Aggregations +- buckets +- postgres - non standard + +## Redis +- Can add to sets +- Atomic +- fast +- counters + +DONT: RETRIVE MANIPULATE STORE + + Do we do this at d3R? + + redis bad at scaling + + joned.in/25887 + + +# Useful links +https://redis.io/commands/sadd +https://www.postgresql.org/docs/9.1/hstore.html +https://wiki.openstreetmap.org/wiki/PostgreSQL +https://en.m.wikipedia.org/wiki/Benford%27s_law +https://php-ml.readthedocs.io/en/latest/machine-learning/workflow/pipeline/ -- cgit v1.2.3