# 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/