diff options
Diffstat (limited to 'day1/no-sql.txt')
| -rw-r--r-- | day1/no-sql.txt | 52 |
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 |