Level Up! Taking your ColdFusion apps to the next level with MongoDB

These are the slides from a 60-minute presentation I gave at CFCAMP in Munich, Germany on 15th October, 2013.

The blurb for the presentation was: "The new generation of NoSQL databases offer unprecedented flexibility and ease-of-use when compared to their more traditional, relational rivals. Discover how adding the powerful features of market-leading NoSQL database MongoDB to your skill set can make your ColdFusion development both more productive and more enjoyable."

The presentation was made to a group of ColdFusion developers with little to no experience of MongoDB or other NoSQL database. After a brief introduction to MongoDB, the product and company, the emphasis was on the practicalities of using MongoDB to perform the everyday CRUD (Create, Retrieve, Update, Delete) operations.

A lot of these slides will not make much sense without the talk to go with them but there you go - it was a presentation not a book reading.

As may be apparent, I am a developer not a designer.

Transcript

1. LEVEL UP! Taking your ColdFusion apps to the next level with MongoDB
2. ME David Waterston david@davidwaterston.com http://dvolvr.davidwaterston.com http://www.mongodbnews.com
3. FUD Fear. Uncertainty. Doubt.
4. WHAT? What is MongoDB?
5. NOSQL
6. NOSQL Not Only SQL
7. NOSQL Not Only SQL Cassandra
8. NOSQL Not Only SQL Cassandra CouchBase
9. NOSQL Not Only SQL Cassandra CouchBase Redis
10. NOSQL Not Only SQL Cassandra CouchBase Redis Hadoop
11. NOSQL Not Only SQL Cassandra CouchBase Redis Hadoop SimpleDB
12. NOSQL Not Only SQL Cassandra CouchBase Redis Hadoop SimpleDB RethinkDB
13. NOSQL Not Only SQL Cassandra CouchBase Redis Hadoop SimpleDB RethinkDB ElasticSearch
14. NOSQL Not Only SQL Cassandra CouchBase Redis Hadoop SimpleDB RethinkDB ElasticSearch Riak
15. 150+ MORE Source: nosql-database.org
16. NON- RELATIONAL DATASTORE
17. JSON DOCUMENTS
18. “SCHEMA-LESS”
19. MONGODB, INC Formerly “10Gen”
20. 2007 Development began
21. 2009 First release
22. 2010 Production-ready release
23. 5,000,000+ downloads 600+ customers 250+ partners 100,000+ developers trained
24. $1.2 BILLION $150 million funding in October, 2013
25. $1.2 BILLION $231 million funding since 2007
26. “Business is fantastic,” 10gen President Max Schireson told me. “We keep outperforming every goal that we set for ourselves and the market just feels like it’s huge.” In fact, he said, new sales people pay for themselves almost immediately upon joining the company.” – GigaOm, May, 2012
27. WHY? What problem is MongoDB trying to solve?
28. Scalability & Performance Depth of Functionality
29. Scalability & Performance Depth of Functionality MemCached Key/Value Stores
30. Scalability & Performance Depth of Functionality MemCached Key/Value Stores Oracle DB2
31. Scalability & Performance Depth of Functionality MemCached Key/Value Stores Oracle DB2 MongoDB
32. HOW? What approach does MongoDB take to solve these problems?
33. NO JOINS
34. NO TRANSACTIONS
35. CHOICE RELATIONAL IS NOT ALWAYS THE BEST CHOICE POLYGLOT PERSISTENCE
36. AGILITY
37. FLEXIBILITY
38. QUICK START Up and running in less than 60 seconds
39. http://try.mongodb.org
40. http://www.mongolab.com
41. http://www.mongohq.com
42. SLOW START Up and running in less than 10 minutes
43. DOWNLOAD http://www.mongodb.org/downloads
44. ENTERPRISE & COMMUNITY 32 & 64 Bit Windows, Mac, Linux, Solaris
45. The MongoDB Shell
46. ROBOMONGO http://www.robomongo.com
47. ROBOMONGO http://www.robomongo.com Multiple Shells
48. ROBOMONGO http://www.robomongo.com Multiple Shells Autocompletion
49. ROBOMONGO http://www.robomongo.com Multiple Shells Autocompletion RoboSQL
52. StaffId FirstName LastName 49678 Mark Wilson 10234 John Anderson 76726 Tina Lane
53. { { “StaffId”: 49678, “FirstName”: “Mark”, “LastName”: “Wilson” }, { “StaffId”: 10234, “FirstName”: “John”, “LastName”: “Anderson” }, { “StaffId”: 76726, “FirstName”: “Tina”, “LastName”: “Lane” } }
54. StaffId FirstName LastName 49678 Mark Wilson 10234 John Anderson 76726 Tina Lane StaffId Hobby 49678 Swimming 49678 Reading
55. { { “StaffId”: 49678, “FirstName”: “Mark”, “LastName”: “Wilson”, “Hobbies”: [“Swimming”, “Reading”] }, { “StaffId”: 10234, “FirstName”: “John”, “LastName”: “Anderson” }, { “StaffId”: 76726, “FirstName”: “Tina”, “LastName”: “Lane” } }
56. { “StaffId”: 49678, “FirstName”: “Mark”, “LastName”: “Wilson”, “HomeAddress”: { “Street”: “123 High Street”, “City”: “Anytown”, “PostCode”: “AB1 2DW”, “Country”: “England” }, “Hobbies”: [“Swimming”, “Reading”] }
57. IFUR is CRUD Insert, Find, Update, Remove Create, Read, Update, Delete
58. SQL Database Table Row Column MONGODB Database Collection Document Field
59. INSERT
60. var staffMember = { "StaffId": 49678, "FirstName": "Mark", "LastName": "Wilson", "HomeAddress": { "Street": "123HighStreet", "City": "Anytown", "PostCode": "AB12DW", "Country": "England" }, "Hobbies": [ "Swimming", "Reading" ] }
61. var staffMember = { "StaffId": 49678, "FirstName": "Mark", "LastName": "Wilson", "HomeAddress": { "Street": "123HighStreet", "City": "Anytown", "PostCode": "AB12DW", "Country": "England" }, "Hobbies": [ "Swimming", "Reading" ] } db.Staff.insert(staffMember)
62. db.Staff.insert({"StaffId":345678, "FirstName": "Silvia", "LastName": "Easton"})
63. FIND
64. db.Staff.find()
65. db.Staff.find() { "_id" : ObjectId("525bddef0b11b9f6614c2ad6"), "StaffId" : 49678, "FirstName" : "Mark", "LastName" : "Wilson", "HomeAddress" : { "Street" : "123HighStreet", "City" : "Anytown", "PostCode" : "AB12DW", "Country" : "England" }, "Hobbies" : [ "Swimming", "Reading" ] } { "_id" : ObjectId("525bded60b11b9f6614c2ad7"), "StaffId" : 345678, "FirstName" : "Silvia", "LastName" : "Easton" }
66. db.Staff.getIndexes() [ { "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.Staff", "name" : "_id_" } ]
67. var query = {"LastName": "Wilson"} db.Staff.find(query)
68. var query = {"LastName": "Wilson"} db.Staff.find(query) var query = {"LastName": "Wilson", "FirstName": "Mark"} db.Staff.find(query)
69. var query = {"LastName": "Wilson"} db.Staff.find(query) var query = {"LastName": "Wilson", "FirstName": "Mark"} db.Staff.find(query) var query = { $or: [ {"LastName": "Wilson" }, {"LastName": "Easton"} ] } db.Staff.find(query)
70. var query = {"LastName": "Wilson"} db.Staff.find(query) var query = {"LastName": "Wilson", "FirstName": "Mark"} db.Staff.find(query) var query = { $or: [ {"LastName": "Wilson" }, {"LastName": "Easton"} ] } db.Staff.find(query) var query = { "FirstName":"Silvia", $or: [ {"LastName": "Wilson" }, {"LastName": "Easton"} ] } db.Staff.find(query)
71. var query = {"LastName": "Wilson"} db.Staff.find(query) var query = {"LastName": "Wilson", "FirstName": "Mark"} db.Staff.find(query) var query = { $or: [ {"LastName": "Wilson" }, {"LastName": "Easton"} ] } db.Staff.find(query) var query = { "FirstName":"Silvia", $or: [ {"LastName": "Wilson" }, {"LastName": "Easton"} ] } db.Staff.find(query) Operators: $in, $gt, $gte, $lt, $lte, $exists... and many more
72. { “StaffId”: 49678, “FirstName”: “Mark”, “LastName”: “Wilson”, “HomeAddress”: { “Street”: “123 High Street”, “City”: “Anytown”, “PostCode”: “AB1 2DW”, “Country”: “England” }, “Hobbies”: [“Swimming”, “Reading”] }
73. var query = {"Hobbies": "Swimming"} db.Staff.find(query)
74. var query = {"Hobbies": "Swimming"} db.Staff.find(query) var query = {"Hobbies.0": "Swimming"} db.Staff.find(query)
75. var query = {"Hobbies": "Swimming"} db.Staff.find(query) var query = {"Hobbies.0": "Swimming"} db.Staff.find(query) var query = {"Hobbies": ["Swimming", "Reading"]} db.Staff.find(query)
76. var query = {"Hobbies": "Swimming"} db.Staff.find(query) var query = {"Hobbies.0": "Swimming"} db.Staff.find(query) var query = {"Hobbies": ["Swimming", "Reading"]} db.Staff.find(query) var query = {"Hobbies": ["Swimming", "Reading", “Running”]} db.Staff.find(query)
77. var query = {"Hobbies": "Swimming"} db.Staff.find(query) var query = {"Hobbies.0": "Swimming"} db.Staff.find(query) var query = {"Hobbies": ["Swimming", "Reading"]} db.Staff.find(query) var query = {"Hobbies": ["Swimming", "Reading", “Running”]} db.Staff.find(query)
78. var query = {"Hobbies": "Swimming"} db.Staff.find(query) var query = {"Hobbies.0": "Swimming"} db.Staff.find(query) var query = {"Hobbies": ["Swimming", "Reading"]} db.Staff.find(query) var query = {"Hobbies": ["Swimming", "Reading", “Running”]} db.Staff.find(query)
79. var query = {"Hobbies": "Swimming"} db.Staff.find(query) var query = {"Hobbies.0": "Swimming"} db.Staff.find(query) var query = {"Hobbies": ["Swimming", "Reading"]} db.Staff.find(query) var query = {"Hobbies": ["Swimming", "Reading", “Running”]} db.Staff.find(query) var query = {"Hobbies": ["Reading", "Swimming"]} db.Staff.find(query)
80. { “StaffId”: 49678, “FirstName”: “Mark”, “LastName”: “Wilson”, “HomeAddress”: { “Street”: “123 High Street”, “City”: “Anytown”, “PostCode”: “AB1 2DW”, “Country”: “England” }, “Hobbies”: [“Swimming”, “Reading”] }
81. var query = {"HomeAddress.City": "Anytown"} db.Staff.find(query)
82. GOTCHAS Case Sensitivity db.Staff.insert(staffMember) is not db.staff.insert(staffMember)
83. GOTCHAS Case Sensitivity db.Staff.find(“LastName”: ”Wilson”) is not db.Staff.find(“LastName”: ”wilson”)
84. GOTCHAS A collection need not exist to be read from or written to!
85. GOTCHAS A collection need not exist to be read from or written to! db.staff.insert(staffMember)
86. GOTCHAS A collection need not exist to be read from or written to! db.Stiff.find()
87. GOTCHAS A field need not exist to be used in a query db.Staff.find({"FirstNames": "Mark"})
88. db.Staff.find({"LastName":"Wilson"}, {"FirstName":1, "StaffId":1})
89. db.Staff.find({"LastName":"Wilson"}, {"FirstName":1, "StaffId":1}) { "_id" : ObjectId("525bddef0b11b9f6614c2ad6"), "StaffId" : 49678, "FirstName" : "Mark" }
90. db.Staff.find({"LastName":"Wilson"}, {"FirstName":1, "StaffId":1}) { "_id" : ObjectId("525bddef0b11b9f6614c2ad6"), "StaffId" : 49678, "FirstName" : "Mark" } db.Staff.find({"LastName":"Wilson"}, {"FirstName":1, "StaffId":1, "_id":0})
91. db.Staff.find({"LastName":"Wilson"}, {"FirstName":1, "StaffId":1}) { "_id" : ObjectId("525bddef0b11b9f6614c2ad6"), "StaffId" : 49678, "FirstName" : "Mark" } db.Staff.find({"LastName":"Wilson"}, {"FirstName":1, "StaffId":1, "_id":0})
92. db.Staff.find({"LastName":"Wilson"}, {"FirstName":1, "StaffId":1}) { "_id" : ObjectId("525bddef0b11b9f6614c2ad6"), "StaffId" : 49678, "FirstName" : "Mark" } db.Staff.find({"LastName":"Wilson"}, {"FirstName":1, "StaffId":1, "_id":0}) { "StaffId" : 49678, "FirstName" : "Mark" }
93. db.Staff.find().limit(20)
94. db.Staff.find().limit(20) db.Staff.find().sort({“FirstName”:1})
95. db.Staff.find().limit(20) db.Staff.find().sort({“FirstName”:1}) db.Staff.find().sort({"LastName":1, "FirstName":1, "StaffId":-1})
96. db.Staff.find().limit(20) db.Staff.find().sort({“FirstName”:1}) db.Staff.find().sort({"LastName":1, "FirstName":1, "StaffId":-1}) db.Staff.find().sort({"LastName":1, "FirstName":1}).limit(10).skip(100)
97. db.Staff.find().limit(20) db.Staff.find().sort({“FirstName”:1}) db.Staff.find().sort({"LastName":1, "FirstName":1, "StaffId":-1}) db.Staff.find().sort({"LastName":1, "FirstName":1}).limit(10).skip(100) db.Staff.count({"LastName": "Wilson"})
98. REMOVE
99. db.Staff.remove()
100. db.Staff.remove() db.Staff.remove({"LastName": "Wilson"})
101. db.Staff.remove() db.Staff.remove({"LastName": "Wilson"}) db.Staff.remove({"LastName": "Wilson"}, true)
102. UPDATE
103. db.Staff.update({"LastName": "Easton"}, {“FirstName”: “Susan”})
104. db.Staff.update({"LastName": "Easton"}, {“FirstName”: “Susan”}) { "_id" : ObjectId("525bded60b11b9f6614c2ad7"), "FirstName" : "Susan" }
105. db.Staff.update({"LastName": "Easton"}, {“FirstName”: “Susan”}) { "_id" : ObjectId("525bded60b11b9f6614c2ad7"), "FirstName" : "Susan" } db.Staff.update({"FirstName": "Susan"}, {$set: {"LastName": "Easton"}})
106. db.Staff.update({"LastName": "Easton"}, {“FirstName”: “Susan”}) { "_id" : ObjectId("525bded60b11b9f6614c2ad7"), "FirstName" : "Susan" } db.Staff.update({"FirstName": "Susan"}, {$set: {"LastName": "Easton"}}) db.Staff.update({"FirstName": "Susanne"}, {$set: {"LastName": "Easton"}})
107. db.Staff.update({"LastName": "Easton"}, {“FirstName”: “Susan”}) { "_id" : ObjectId("525bded60b11b9f6614c2ad7"), "FirstName" : "Susan" } db.Staff.update({"FirstName": "Susan"}, {$set: {"LastName": "Easton"}}) db.Staff.update({"FirstName": "Susanne"}, {$set: {"LastName": "Easton"}}) db.Staff.update({"FirstName": "Susanne"}, {$set: {"LastName": "Easton"}}, true) { "_id" : ObjectId("525c7edb3aafe4a7fc6894eb"), "FirstName" : "Susanne", "LastName" : "Easton" }
108. { "FirstName" : "Susan", "LastName" : "Easton", "_id" : ObjectId("525bded60b11b9f6614c2ad7") } { "_id" : ObjectId("525c7edb3aafe4a7fc6894eb"), "FirstName" : "Susanne", "LastName" : "Easton" }
109. { "FirstName" : "Susan", "LastName" : "Easton", "_id" : ObjectId("525bded60b11b9f6614c2ad7") } { "_id" : ObjectId("525c7edb3aafe4a7fc6894eb"), "FirstName" : "Susanne", "LastName" : "Easton" } db.Staff.update({"LastName": "Easton"}, {$set: {"LastName": "Susanne"}}, false, true)
110. COLDFUSION? How can we take advantage of MongoDB in ColdFusion?
111. <cfsavecontent variable=”StaffJSON”> { “StaffId”: 49678, “FirstName”: “Mark”, “LastName”: “Wilson”, “HomeAddress”: { “Street”: “123 High Street”, “City”: “Anytown”, “PostCode”: “AB1 2DW”, “Country”: “England” }, “Hobbies”: [“Swimming”, “Reading”] } </cfsavecontent> <cfset Staff = DeserializeJSON(StaffJSON)>
112. { “StaffId”: 49678, “FirstName”: “Mark”, “LastName”: “Wilson”, “HomeAddress”: { “Street”: “123 High Street”, “City”: “Anytown”, “PostCode”: “AB1 2DW”, “Country”: “England” }, “Hobbies”: [“Swimming”, “Reading”] }
113. CFMONGODB https://github.com/marcesher/cfmongodb
114. <cfset StaffMember = StructNew()> <cfset StaffMember.StaffId = 49678> <cfset StaffMember.FirstName = “Mark”> <cfset StaffMember.LastName = “Wilson”> <cfset Staff = mongo.getDbCollection(“Staff”)> <cfset response = Staff.save(StaffMember)>
115. <cfscript> StaffMember = {StaffId=49678, FirstName="Mark", LastName="Wilson"}; Staff = mongo.getDbCollection(“Staff”); Staff.save(StaffMember)> </cfscript>
116. <cfscript> newStaff = []; arrayAppend (newStaff, {StaffId=49678, FirstName="Mark", LastName="Wilson"}); arrayAppend (newStaff, {StaffId=76726, FirstName="Tina", LastName="Lane"}); Staff = mongo.getDbCollection(“Staff”); Staff.saveAll(newStaff)> </cfscript>
117. MONGOCFC https://github.com/henry2rock/MongoCFC
118. GO NATIVE http://cflove.org/2013/06/playing-around- with-coldfusion-and-mongodb.cfm
119. TAKE AWAY MongoDB has a short learning curve and, in some situations, may just be the best tool for the job
120. START HERE http://dvo.lv/startmongodb