diff options
| author | Phil Burton <phil@d3r.com> | 2019-02-22 15:32:18 +0000 |
|---|---|---|
| committer | Phil Burton <phil@d3r.com> | 2019-02-22 15:32:18 +0000 |
| commit | 4e8368f4d847e5c1352302fc53658dfab2c72a9b (patch) | |
| tree | fe66e708ef51272bea4a0a9de2b4b0f78b711d64 /day1/no-sql.txt | |
| parent | 5bace29545690e364f9748b8232b93f7933abb88 (diff) | |
second and third talk
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 |