summaryrefslogtreecommitdiff
path: root/day1/no-sql.txt
diff options
context:
space:
mode:
Diffstat (limited to 'day1/no-sql.txt')
-rw-r--r--day1/no-sql.txt52
1 files changed, 52 insertions, 0 deletions
diff --git a/day1/no-sql.txt b/day1/no-sql.txt
index 5ce9723..ccb6a4a 100644
--- a/day1/no-sql.txt
+++ b/day1/no-sql.txt
@@ -1,3 +1,55 @@
+# 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