MongoDB and Mongoose Tutorial

2014/05/08 @ NTU CCSP
https://github.com/NTU-CCSP/mongoose-tutorial

Transcript

1. Cloud Computing-Based Service Design and Programming Andy Kuo @andikan 1
2. DB = DataBase (n.) 資料庫 A database is an organized collection of data. 2
4. Hello DB! 4
5. SQL Relational Database 5
6. NoSQL http://nosql-database.org/ Not Only SQL 6
7. Volume • Velocity • Variety 7
8. Key / Value Column Graph Document 8
9. MongoDB scalable, high-performance, open source NoSQL database • document store • full index support • replication • querying • map / reduce 9
10. MongoDB implemented in C++ drivers are available in many language http://docs.mongodb.org/manual/applications/drivers/ MongoDB Drivers and Client Libraries 10
11. BSON Binary JSON BSON = JSON + a few additions • ObjectID • Timestamp • Date 11
12. MongoDB Terminology Relational DBs MongoDB database database table collection row (tuple) document (BSON) column field index index primary key _id foreign key 12
13. Collection Document 13
14. Download : http://www.mongodb.org/downloads Installation : http://docs.mongodb.org/manual/installation/ Getting Started 14
15. http://docs.mongodb.org/manual/tutorial/install-mongodb-on-windows/ https://speakerdeck.com/xpsteven/ntu-ccsp-2012fall-node-dot-js-number-3-mongoose Install MongoDB on Windows 15
16. mongod The primary daemon process for the MongoDB system It handles data requests, manages data format, and performs background management operations 16
17. Default dbpath /data/db Can use your custom directory 17
18. Listen on localhost : 27017 18
19. admin web console localhost : 28017 19
20. Connect to mongod By default, mongo looking for a database server listening on port 27017 on the localhost 20
21. Welcome to the MongoDB shell Session will use the test database by default Access with the Javascript Language 21
22. http://try.mongodb.org/ 22
23. Name of the current database Display the list of databases Switch to a new database named cooldb 23
24. Insert a document into a collection 24
25. Traverse documents in a collection 25
26. Methods to create documents 26
27. Methods to update documents 27
28. Methods to delete documents 28
29. Methods to query documents 29
30. Methods to query documents Query Operators Comparison: $gt, $gte, $in, $lt, $lte, $ne, $nin Logical: $or, $and, $not, $nor Array: $all, $size, $eleMatch More: http://docs.mongodb.org/manual/reference/operator/query/ 30
31. Create / Read / Update / Delete CRUD http://docs.mongodb.org/manual/ More about MongoDB 31
32. http://docs.mongodb.org/ecosystem/tools/administration-interfaces/ Admin UIs MongoHub RoboMongo Mac OS X Cross-platform 32
33. ORM Object-relational Mapper ( Relational DB ) ODM Object-document Mapper ( MongoDB ) validations, associations, and other high-level data modeling functions 33
34. Mongoose Officially supported ODM for Node.js Advanced schema-based features Object life-cycle management Mongoose http://mongoosejs.com/ 34
35. Install Mongoose Or install in your express project directory 35
36. Create Schema - models/user.js Schema Types - String - Number - Date - Buffer - Boolean - Mixed - ObjectId - Array 36
37. Connect DB - db.js 37
38. Require db.js - app.js 38
39. Routes - app.js 39
40. Require model - routes/user.js 40
41. Postman Chrome extension A powerful HTTP Client to test web services http://www.getpostman.com/ 41
42. Get all users - routes/user.js GET /users 42
43. Create a user - routes/user.js POST /users 43
44. Show a user - routes/user.js GET /users/:id 44
45. Update a user - routes/user.js POST /users/:id 45
46. Delete a user - routes/user.js Delete /users/:id 46
47. https://github.com/NTU-CCSP/mongoose-tutorial Sample Code 47
48. The versionKey is a property set on each document when first created by Mongoose. This keys value contains the internal revision of the document. __v http://mongoosejs.com/docs/guide.html#versionKey 48
49. Query with Mongoose 49
50. Query with Mongoose 50
51. Population Pseudo-joins Reference to documents in other collections 51
52. Population - Schema 52
53. Population - Saving refs 53
54. Population - Query 54
55. Population - Refs to children 55
56. Population - Query 56
57. page.fans ? CCSP Facebook Page https://www.facebook.com/ntu.ccsp 57
58. Mongoose Plugins Re-use schema functionality in your own project - Auto increment https://github.com/codetunnel/mongoose-auto-increment - Timestamp https://github.com/drudge/mongoose-timestamp 58
59. Callback Hell - Promises - Async.js https://github.com/caolan/async - Step.js https://github.com/creationix/step http://callbackhell.com/ 59
60. Cloud Computing-Based Service Design and Programming Andy Kuo @andikan Thanks 60