Blastoff Rails: Powerful Data

Transcript

1. P O W E R F U L D A T A D B G O B R R R R R R R R M A K I N G R A I L S A P P S F A S T E R W I T H A G G R E G A T I O N
5. AGGREGATION
7. D D
8. AGGREGATION: DATACEPTION D D
9. AGGREGATION: DATACEPTION D D
10. AGGREGATE MODEL
11. AGGREGATE MODEL What questions are you answering
12. AGGREGATE MODEL What questions are you answering Groupings
13. AGGREGATE MODEL What questions are you answering Groupings How do you want to view the data
14. AGGREGATE MODEL What questions are you answering Groupings How do you want to view the data Reduce calculations
15. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S
16. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S 150 TIMES FASTER
17. C O S T
18. S P A C E C O S T
19. S P A C E F L E X I B I L I T Y C O S T
20. S P A C E F L E X I B I L I T Y D A T A F R E S H N E S S C O S T
21. MATH
22. .GROUP_BY
23. .GROUP_BY
24. .GROUP_BY Generates a `SELECT` query, ActiveRecord::Relation
25. .GROUP_BY Generates a `SELECT` query, ActiveRecord::Relation Loads ActiveRecord objects into memory
26. .GROUP_BY Generates a `SELECT` query, ActiveRecord::Relation Rails does the grouping based on the block passed Loads ActiveRecord objects into memory
27. .GROUP
28. .GROUP
29. .GROUP Generates a `SELECT SUM` query, summing done on the DB level
30. .GROUP Generates a `SELECT SUM` query, summing done on the DB level Model objects not instantiated in memory
31. .GROUP Generates a `SELECT SUM` query, summing done on the DB level Returns a hash Model objects not instantiated in memory
32. CHAINING METHODS
33. CHAINING METHODS
34. CHAINING METHODS
35. CHAINING METHODS
36. CHAINING METHODS
37. CHAINING METHODS
38. C O S T
39. N O M O D E L S C O S T
40. N O M O D E L S N O R E L A T I O N S C O S T
41. N O M O D E L S N O R E L A T I O N S C O M P L E X I T Y C O S T
42. SQL SQL SQL SQL
43. SQL SQL SQL SQL
44. SQL SQL SQL SQL Use for complex subqueries, CTEs, custom joins Use find_by_sql if you want model instances
45. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S R A I L S W AY S Q L W AY BENCHMARK
46. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S R A I L S W AY S Q L W AY BENCHMARK
47. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S
48. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S 2,143% HOLY SMOKES, BATMAN!
49. C O S T
50. V A L I D A T I O N S C O S T
51. V A L I D A T I O N S C A L L B A C K S C O S T
52. V A L I D A T I O N S C A L L B A C K S M A I N T E N A N C E C O S T
53. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S INDEXES
54. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S INDEXES G R O U P I N G
55. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S INDEXES G R O U P I N G E X P L A I N
56. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S INDEXES G R O U P I N G E X P L A I N U P D A T E
57. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S INDEXES G R O U P I N G E X P L A I N U P D A T E O V E R - I N D E X I N G
58. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S INDEXES G R O U P I N G E X P L A I N U P D A T E O V E R - I N D E X I N G A L L T A B L E S
59. W H Y ?
60. G O O D C I T I Z E N W H Y ?
61. G O O D C I T I Z E N R E S O U R C E S W H Y ?
62. G O O D C I T I Z E N R E S O U R C E S F A I L U R E S W H Y ?
63. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S W T F S
64. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S S P E C S F U C K I N G T H E W R I T E W T F S
65. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S L E T T H E D A T A B A S E D O T H E W O R K
66. THANK YOU
67. P O W E R H O M E R E M O D E L I N G O U R W O R K S H O W S