Thanks!
Thanks for attending my talk "Storing Non-Scalar Data" at PHP UK Conference that I gave on February 21st, 2019. Here you can find some extra information about the talk if they are available. For this talk we have:
Questions?
If you have any questions about the talk, feel free to contact me. My details are on the contact page.
Slides
The talks slides can be downloaded at nonscalar-phpuk19.pdf
Resources
- CouchDB: Curl: http://docs.couchdb.org/en/2.0.0/intro/curl.html
- CouchDB: Finding Your Data with Views: http://guide.couchdb.org/draft/views.html
- CouchDB: HTTP Document API: https://wiki.apache.org/couchdb/HTTP_Document_API
- Elasticsearch: Intorducing the Query Language: https://www.elastic.co/guide/en/elasticsearch/reference/current/_introducing_the_query_language.html
- Elasticsearch: PHP: https://github.com/elastic/elasticsearch-php
- Elasticsearch: Query DSL: https://www.elastic.co/guide/en/elasticsearch/reference/5.2/query-dsl.html
- JSON Schema: http://json-schema.org/
- MongoDB: Document Validation: https://docs.mongodb.com/manual/core/document-validation/
- MySQL: Functions That Modify JSON Values: https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
- MySQL: Indexes on the JSON Data Type: https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html#json-column-indirect-index
- MySQL: JSON Data Type: https://dev.mysql.com/doc/refman/5.7/en/json.html
- MySQL: JSON Function Reference: https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html
- PostgreSQL: GIN and GiST Index Types: https://www.postgresql.org/docs/9.6/static/textsearch-indexes.html
- PostgreSQL: HSTORE: https://www.postgresql.org/docs/9.6/static/hstore.html
- PostgreSQL: JSON Types: https://www.postgresql.org/docs/9.6/static/datatype-json.html
- Redis: Data types: https://redis.io/topics/data-types
- Redis: Introduction into data types: https://redis.io/topics/data-types-intro
(add your own comment
Comments (through joind.in)
Great overview on JSONB and similar data types. Well delivered.
Really interesting overview to storing different data types. Immediately started thinking what we could (should) be doing different, so it did its job!
The talk was very interesting. I really liked the comparison of the various storage methods and the discussions of the pros and cons of each. It was way more helpful than the fanatical presentations about one particular product that claims it's a silver bullet. I learned a broad range about different data types in the different "databases", and how to query them.
A good presentation although for me specifically I didn't pick up any new learnings
The speaker spoke well. I wasn't a particular fan of the content this time round. I felt the talk spent too much time on how to store data rather than why you would store data with each method. I felt a better talk would have covered one or many use cases, the options available and why you may lean towards one more than another.