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/no-sql.txt | 57 --------------------------------------------------------- 1 file changed, 57 deletions(-) delete mode 100644 day1/no-sql.txt (limited to 'day1/no-sql.txt') diff --git a/day1/no-sql.txt b/day1/no-sql.txt deleted file mode 100644 index ccb6a4a..0000000 --- a/day1/no-sql.txt +++ /dev/null @@ -1,57 +0,0 @@ -# Non-Scalar Data - -## 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