Nation.js - Making Relational Cool Again?

Transcript

1. Making Relational Cool Again?
2. @tgriesser
7. Node.js® is a platform built on Chrome's JavaScript runtime for easily building fast, scalable network applications. Node.js uses an event- driven, non-blocking I/O model that makes it lightweight and efficient, perfect for data-intensive real-time applications that run across distributed devices.
8. …really great for web apps
10. But what about RDBMS??
11. node- node- node- node-
12. Adapter Specific Config? Different APIs?? VANILLA SQL?
13. Existing SQL Libs? • Database specific • Mix of ORM layer and query layer • No transaction api!! • "Jack of All Trades" • DIY: gets you most of the way there, but…
14. late 2012-ish
16. Query builder Eloquent Promises Models, Collections, Events
18. FUN TO USE
19. Simple Configuration
20. SQL, as you would write it
21. SQL, as you would write it
22. SQL, as you would write it
23. Joins
24. Joins with multiple clauses
25. Subqueries?
26. Subqueries?
27. Complex Queries
28. Complex Queries
29. Complex Queries
30. Composable Queries
31. Raw Queries?
32. Other Builder features • Aggregate queries (min, max, sum) • Column, subquery aliasing ".as()" • Normalizes missing data in inserts • Tries hard to not let you screw up
33. TRANSACTIONS
34. Transactions • Snapshot state of the world • Ability to ROLLBACK • Prevent others from altering data as you’re working with it (Locks) • A little trickier to pull off in Node
39. SCHEMA BUILDING
40. Schema Building • Code to help create and edit the database structure • Maintains consistency between datatypes in different query dialects • Used in combination with migrations to keep database properly structured
42. Batteries Included • Query Building • Pooling • Schema • Migrations • Seeding
43. • Query Building • Pooling • Schema • Migrations • Seeding Awesome! Batteries Included
44. Adapters • Promises • then • map • reduce • tap (.then, for side-effects)
45. Adapters • Callbacks (.exec) • Streams (.pipe, .stream) • Events • .toString()
48. Builds on Knex
49. Object Relational Mapper • Rows -> Objects • Models common patterns of relational DB’s • One-to-One • One-to-Many • Many-to-Many
50. • Takes care of standard SQL queries for you, especially for common CRUD operations • model.fetch() • model.fetchAll() • model.save() • model.destroy() Object Relational Mapper
52. Eager Loading • Avoids the N+1 Query Problem • Find an account with associated posts, the comments on those posts, and the accounts that made the comments.
54. Eager Loading • Avoids the N+1 Query Problem • Find an account with "approved" associated posts, the comments on those posts, and the accounts that made the comments.
55. Dynamically constrain relations
56. Eager Loading
57. "Tapping into" the query chain Allows for adding additional query parameters dynamically to the model's query
58. Custom Errors
59. Next Steps: • Better debuggability, error types • Built-in support for Postgres- specific features • Continue to refine Bookshelf’s API • 1.0 by year end, or shortly after
60. In the Wild
61. PhilWaldmann/openrecord
62. Takeaway of the Talk: Relational databases work with Node
63. Questions? knexjs.org bookshelfjs.org IRC: #bookshelf