CouchDB & Ruby - You're doing it wrong

by Tim Anglade

Transcript

1. COUCHDB&RubY YOU’RE DOING IT RONG A PRESENTATION BY @timangladE FROM YOUR FRIENDS AT @cloudant W
2. @timanglade
6. COUCHDB HOSTING + AD-HOC SOLUTIONS
7. Re: Identical nodes & Dist. Testing
8. Ruby: 10% OF our USERS 65% OF the I/O That’s called having a vested interest, my Friends
9. COUCHDB ➞ A SimplE REST STORE
10. tim$ curl -X GET https://localhost:5984/nosqlsummer/berlin tim$ { _id: "berlin" _rev: "87-d666a8e1176a068b343d7ccca7260141" name: "Berlin" lifeguards: "Tim Lossen" welcome: "What could be a better excuse to hang …" }
11. A match made in HEAVEN?
12. In Rubyland: COUCHREST github.com/couchrest
13. require 'couchrest' db = CouchRest.database!("https://tim.cloudant.com/nosqlsummer") db.get("berlin") => { "name" => "Berlin", "lifeguards" => "Tim Lossen", "_rev" => "87-d666a8e1176a068b343d7ccca7260141", "welcome" => "What could be a better excuse to hang out …" }
14. Looking Good, right?
15. 0 200 400 600 800 1k 10k 50k 100k MEDIAN TIME TO SAVE A DOC Time spent (ms) Document Size
16. MAN, COUCHDB IS SO SLOW…
17. WRONG WRONG WRONG
18. require 'couchrest' db = CouchRest.database!("https://tim.cloudant.com/nosqlsummer") db.get("berlin") => { "name" => "Berlin", "lifeguards" => "Tim Lossen", "_rev" => "87-d666a8e1176a068b343d7ccca7260141", "welcome" => "What could be a better excuse to hang out …" }
19. Warning #0 CouchREST#Database! VS. CouchREST#Database upgrade to Couchrest 1.1.3 now
20. Warning #1 Actually, don’t use Much of CouchREST AT ALL You’LL Thank me later.
21. Warning #2 Load a proper JSON LIBRARY MULTI_JSON = fail
22. Warning #3 LOCALITY
23. Warning #4 TO HTTPS… OR NOT?
24. require 'json/ext' require 'couchrest' @db = "http://tim-east.cloudant.com/mydb" def my_function CouchRest.put(@db, doc) end require 'couchrest' def my_function db = CouchRest.database!("https://tim-west.cloudant.com/mydb") db.save_doc(doc) def Before AFTER
25. 0 200 400 600 800 1k 10k 50k 100k Before Time spent (ms) Document Size Encoding HTTP Decoding
26. How Much? 10% ? 20% ? 30% ?
27. 0 200 400 600 800 1k 10k 50k 100k Before Time spent (ms) Document Size Encoding HTTP Decoding
28. 0 200 400 600 800 1k 10k 50k 100k Time spent (ms) Document Size Encoding HTTP Decoding AFTER
29. AFTER 0 8 15 23 30 1k 10k 50k 100k Time spent (ms) Document Size Encoding HTTP Decoding
30. Lol96% AND Guess what, we’re not done yet…
31. Warning #5 LOLJSON
32. MESSAGEPACK Say Hello to my little FRIEND
34. How complex? 10 lines of code
35. 0 8 15 23 30 1k 10k 50k 100k With MessagePACK Encoding HTTP Decoding JSON 3ms 6MS 9MS 3ms
36. COUCHDB ➞ A NOT-SO-SimplE REST STORE
37. I SHOULD USE COUCHREST_MODEL, RIGHT?
38. WRONG WRONG WRONG
39. ODMs are A BAD IDEA
40. COUCHREST_MODEL IS POORLY IMPLEMENTED File > Open > nightmare.RB
44. DoN’T USE COUCHREST_MODEL Or I will personally hunt you down and punch you in the neck
45. ➞ So WHAT?
46. GROUP INFO ONE HTTP CALL PER RUBY METHOD Write views as necessary IF you can’t ➡ Wrong DB?
47. { "_id": "berlin", "country": "Germany", "meetings": { "2010-10-17": { "location": "Beergarden", "description": "Initial meeting. Come say hi!" } "2010-12-27": { "location": "Alexanderplatz", "description": "Second meeting. Yes!" } } }
48. LEARN HOW TO USE BULK_DOCS A no-brainer if you do multiple updates inSIDE one ruby method
49. LEARN VIEWS THE HARD WAY
50. function(doc) { if (doc.type == 'city') { emit(doc.id, doc); } } MAP
51. function(doc) { if (doc.type == 'city') { emit(doc.id, doc['meetings'].length); } } MAP REDUCE _stats
52. LEARN VIEWS THE NOT-SO-HARD WAY github.com/candlerb/couchdb_ruby_view
53. LEARN TO PUT MORE APP LOGIC IN COUCHDB
54. LEARN WHEN TO USE FULL-TEXT SEARCH Don’t WRITE A VIEW PER COLUMN-EQUIVALENT…
55. LEARN STALE=OK COUCHDB VIEW ARE UPDATED on READS. YOU MAY WAIT A WHILE…
56. ➞ GOD MODE
57. Cloudant Softlayer users Sinatra APAC SINATRA US-EAST
58. LEARN TO LEVERAGE REPLICATION
59. Sinatra APAC Cloudant APAC SINATRA US-EAST Cloudant US-East Cloudant SOFTLAYER users
60. LEARN HOW TO TWEAK CONSISTENCY
61. Sinatra APAC Cloudant APAC SINATRA US-EAST Cloudant US-East Cloudant SOFTLAYER users
62. LEARN TO OFFLOAD TO FRONT-END JS
63. Sinatra APAC Cloudant APAC SINATRA US-EAST Cloudant US-East Cloudant SOFTLAYER users
64. LEARN TO CACHE SOME COUCHDB ROUTES
65. Sinatra APAC Cloudant APAC SINATRA US-EAST Cloudant US-East Cloudant SOFTLAYER CDN users
66. Recap! ! 1. ! NEVER USE COUCHREST_MODEL ! 2. ! Be WARY OF COUCHREST ! 3. ! LOAD A PROPER JSON LIBRARY ! 4. ! PAY ATTENTION TO LOCALITY ! 5. ! ONLY USE HTTPS WHEN NECESSARY ! 6. ! Don’t be afraid to extend
67. Go EXPERIMENT IMPLEMENT MEASURE IMPROVE HAVE FUN
68. Free plan BigCouch github.com /cloudant/bigcouch Open Source cloudant.com
69. github.com/timanglade cloudant.com tim@cloudant.com @timanglade ?