Thanks!
Thanks for attending my talk "Storing Non-Scalar Data" at Midwest PHP that I gave on March 18th, 2017. 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-midwestphp17.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)
Very information-rich presentation. I think you did as well as possible while trying to cover so many different database options. I think it may have helped to have more examples in one or two of the database types and just cursory coverage of the others. Delivery style was adequate, though a more expressive tone would have helped me stay engaged in the material more.
This was a great talk! I wasn't aware of json format support in the different relational databases and I was glad to learn about the different ways nosql databases handle things.
I was impressed by how thoroughly this topic was covered. A lot of good info.
Great overview! The talk covered a lot of ground quickly and provided great insight into how different databases handle non-scalar data. As someone relatively new to backend development, I came away from the talk feeling that I could make informed decisions about handling non-scalar data.
I found the noSQL solutions more interesting than how relational database are implementing non-scalar data storage. You've gotten me interested in researching Elasticsearch more.