com presentations: Added PHP Dorset talk.: nonscalar-phpdorset17.xml slides/mongodb/scalar-postgresql-jsonb-example.xml

Commit:    c6b71cf138f441a6819fc61e16e82c1bb8f9723e
Author:    Derick Rethans <[email protected]>         Mon, 7 Aug 2017 21:24:30 +0100
Parents:   05d8e7804319ed6bfe828cf101e3449a8ba7d778
Branches:  master

Link:       http://git.php.net/?p=presentations.git;a=commitdiff;h=c6b71cf138f441a6819fc61e16e82c1bb8f9723e

Log:
Added PHP Dorset talk.

Changed paths:
  A  nonscalar-phpdorset17.xml
  M  slides/mongodb/scalar-postgresql-jsonb-example.xml


Diff:
diff --git a/nonscalar-phpdorset17.xml b/nonscalar-phpdorset17.xml
new file mode 100644
index 0000000..15604d7
--- /dev/null
+++ b/nonscalar-phpdorset17.xml
@@ -0,0 +1,141 @@
+<?xml version="1.0" encoding="utf-8"?>
+<presentation css="10gen-strict.css">
+<topic>MongoDB</topic>
+<title>Storing Non-Scalar Data</title>
+<event>PHP Dorset</event>
+<location>Bournemouth, UK</location>
+<date>August 7th, 2017</date>
+<speaker>Derick Rethans</speaker>
+<email>[email protected]</email>
+<twitter>derickr</twitter>
+<url>http://derickrethans.nl/talks.html</url>
+<joindin></joindin>
+<slide>slides/mongodb/title.xml</slide>
+<slide>slides/mongodb/me.xml</slide>
+
+<slide>slides/mongodb/scalar-non-scalar-examples.xml</slide>
+<slide>slides/mongodb/scalar-non-scalar-example-vector.xml</slide>
+<slide>slides/mongodb/scalar-non-scalar-example-tag-cloud.xml</slide>
+<slide>slides/mongodb/scalar-non-scalar-example-product-properties.xml</slide>
+<!-- <slide>slides/mongodb/scalar-non-scalar-example-addresses.xml</slide> -->
+<slide>slides/mongodb/scalar-what-is-it-not.xml</slide>
+
+<slide>slides/mongodb/scalar-agenda.xml</slide>
+
+Intro into DB types and their data types
+<slide>slides/mongodb/scalar-section-dbs-and-types.xml</slide>
+
+    Key/Value:
+        Redis
+            LISTS
+            SETS
+            HASHES
+            Sorted SET
+<slide>slides/mongodb/scalar-key-value.xml</slide>
+<slide>slides/mongodb/scalar-redis.xml</slide>
+<!-- <slide>slides/mongodb/scalar-redis-lists.xml</slide> -->
+<slide>slides/mongodb/scalar-redis-sets.xml</slide>
+<slide>slides/mongodb/scalar-redis-hashses.xml</slide>
+<!-- <slide>slides/mongodb/scalar-redis-sorted-set.xml</slide> -->
+
+    Document:
+        MongoDB
+        CouchDB
+        Elastic Search
+<slide>slides/mongodb/scalar-document.xml</slide>
+<slide>slides/mongodb/scalar-mongodb.xml</slide>
+<slide>slides/mongodb/document-complex.xml</slide>
+<slide>slides/mongodb/phplib-crud-insert.xml</slide>
+<slide>slides/mongodb/scalar-couchdb.xml</slide>
+<slide>slides/mongodb/scalar-couchdb-example.xml</slide>
+<slide>slides/mongodb/scalar-couchdb-insert.xml</slide>
+<slide>slides/mongodb/scalar-elasticsearch.xml</slide>
+<slide>slides/mongodb/scalar-elasticsearch-example.xml</slide>
+<slide>slides/mongodb/scalar-elasticsearch-insert.xml</slide>
+
+    Relational:
+        MySQL
+            JSON
+        PostgreSQL
+            HSTORE
+            JSON
+            JSONB
+<slide>slides/mongodb/scalar-relational.xml</slide>
+<slide>slides/mongodb/scalar-mysql.xml</slide>
+<slide>slides/mongodb/scalar-mysql-json.xml</slide>
+<slide>slides/mongodb/scalar-mysql-json-example.xml</slide>
+<slide>slides/mongodb/scalar-postgresql.xml</slide>
+<slide>slides/mongodb/scalar-postgresql-hstore.xml</slide>
+<slide>slides/mongodb/scalar-postgresql-jsonb.xml</slide>
+<slide>slides/mongodb/scalar-postgresql-jsonb-example.xml</slide>
+
+<slide>slides/mongodb/scalar-storage-overview.xml</slide>
+
+<slide>slides/mongodb/scalar-section-query.xml</slide>
+
+Manipulation
+
+    Query
+        Query operators for $in, $elemMatch, etc
+        Query operations on nested fields
+
+<slide>slides/mongodb/scalar-query-redis.xml</slide>
+<slide>slides/mongodb/scalar-query-couchdb.xml</slide>
+<slide>slides/mongodb/scalar-query-mongodb.xml</slide>
+<slide>slides/mongodb/scalar-query-mongodb-aggregation.xml</slide>
+<slide>slides/mongodb/scalar-query-elasticsearch.xml</slide>
+<slide>slides/mongodb/scalar-query-mysql.xml</slide>
+<slide>slides/mongodb/scalar-query-postgresql-hstore.xml</slide>
+<!-- <slide>slides/mongodb/scalar-query-postgresql-jsonb.xml</slide> -->
+
+    Indexes
+        Redis
+        MongoDB
+        CouchDB
+        ElasticSearch
+        MySQL
+            only through virtual columns
+            Not on arrays
+        PostgreSQL
+            GIN/GIST 
+        Geospatial from GeoJSON sources (not PostGIS)
+
+<slide>slides/mongodb/scalar-index-redis.xml</slide>
+<slide>slides/mongodb/scalar-index-couchdb.xml</slide>
+<slide>slides/mongodb/index.xml</slide>
+<slide>slides/mongodb/scalar-index-elasticsearch.xml</slide>
+<slide>slides/mongodb/scalar-index-postgresql.xml</slide>
+<slide>slides/mongodb/scalar-index-mysql.xml</slide>
+
+
+<slide>slides/mongodb/scalar-section-manipulation.xml</slide>
+    Storing/Update
+        Atomicity
+            ACID
+            Single document with update specifiers
+        Partitioning on JSON data
+        Manipulation of JSON data
+<slide>slides/mongodb/scalar-atomicity.xml</slide>
+<!-- <slide>slides/mongodb/acid.xml</slide> -->
+<slide>slides/mongodb/scalar-nosql-acid.xml</slide>
+<slide>slides/mongodb/scalar-atomic-redis.xml</slide>
+<slide>slides/mongodb/scalar-atomic-couchdb.xml</slide>
+<slide>slides/mongodb/update-atomicity.xml</slide>
+
+    Schema validation
+        None can do that, besides MongoDB
+
+<slide>slides/mongodb/scalar-validate.xml</slide>
+<slide>slides/mongodb/document-validation.xml</slide>
+
+<slide>slides/mongodb/scalar-conclusion.xml</slide>
+
+
+Conclusion
+
+
+
+<slide>slides/mongodb/questions.xml</slide>
+<slide>slides/mongodb/resources.xml</slide>
+
+</presentation>
diff --git a/slides/mongodb/scalar-postgresql-jsonb-example.xml b/slides/mongodb/scalar-postgresql-jsonb-example.xml
index 4159121..abacc87 100644
--- a/slides/mongodb/scalar-postgresql-jsonb-example.xml
+++ b/slides/mongodb/scalar-postgresql-jsonb-example.xml
@@ -8,7 +8,7 @@ CREATE TABLE users (jdoc *JSONB*);
 
 <blurb>Insert document:</blurb>
 <example inline="2">
-INSERT INTO users VALUES(*'*
+INSERT INTO users VALUES(*'*{
     "_id" : "derick@localhost",
     "email" : "derick@localhost",
     "fullname" : "Derick Rethans",