Making Relational Cool Again (or: JavaScript on ACID)

JSConf 2015

Transcript

1. Making Relational Cool Again @tgriesser
2. Making Relational Cool Again @tgriesser or: JavaScript on ACID
3. sequel
4. SQL
11. Functional, (prototypal) OO Loose, duck Static, strong Declarative, Procedural
12. Operators? + -
13. Operators? 0.1 + 0.2 // 0.30000000000000004
15. –Me “Languages that will probably never die.”
20. 42-
27. –Matthew Daly, Stack Overflow User “A degree of antipathy toward relational databases”
28. “Poorly supported compared to non- relational databases” –Matthew Daly, Stack Overflow User
29. node- node- node- node- mysql postgres mariasql sqlite3
30. Existing SQL Libs? Common DBAPI? Higher level abstractions
31. 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…
34. Query builder Eloquent Promises Models, Collections, Events
45. Connection Pooling Grammar Schema (DDL) Builder Migrations Seeding Expression Builder DB Client Transactions
46. Simple Configuration
47. Simple Configuration WebSQL
48. Simple Configuration WebSQL
49. SQL, as you would write it
50. Joins
51. Joins with multiple clauses
52. Subqueries
53. Subqueries
54. Other Builder Features • Raw queries • Aggregate queries (min, max, sum) • Column, subquery aliasing ".as()" • Normalizes missing data in inserts • Tries hard to not let you screw up
55. …or: JavaScript on ACID
57. Atomicity Consistency Isolation Durability
58. 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
59. 1. Register a user, giving them an ID 2. Send that to a third party service, registering the user 3. Create additional account rows 4. Return response to the user
61. 1. Register a user, giving them an ID 2. Send that to a third party service, registering the user catch, rollback 1 3. Create additional account rows catch, rollback 1, 3? 4. Return response to the user
67. Nesting Transactions SAVEPOINT ROLLBACK TO _____
68. "Batteries Included" • Pooling • Schema Building • Migrations • Seeding • Callbacks (.asCallback) • Streams (.pipe, .stream) • Events • .toString()
70. Object Relational Mapper
71. Object Relational Mapper • Takes care of standard SQL queries for you, especially for common CRUD operations • model.fetch() • model.fetchAll() • model.save() • model.destroy()
72. • One-To-One • hasOne • belongsTo • One-To-Many • hasMany • Many-To-Many • belongsToMany Association Types
73. • One-To-One • hasOne • belongsTo • One-To-Many • hasMany • Many-To-Many • belongsToMany Association Types
74. • One-To-One • hasOne • belongsTo • One-To-Many • hasMany • Many-To-Many • belongsToMany Association Types
75. • Mapping a single model to multiple model types • Picture for employees, for products Polymorphic Associations
76. Builds on Knex
79. 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.
81. 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.
82. Dynamically constrain relations
83. Eager Loading
84. "Tapping into" the query chain Allows for adding additional query parameters dynamically to the model's query
85. Transactions In Bookshelf, each async call (fetch, save, create, load, destroy), takes an “options” object which may optionally take a {transacting: t} - where “t” is the object in the transaction closure
89. Shared models: Sounds great, not as great in practice
92. …not the first to do this
93. …not the last to do this
104. Just some of what's out there…
105. …this still isn't enough
106. Don't Reinvent the wheel
107. Don't Reinvent the wheel
108. ! Reinvent the wheel
109. ! Reinvent the wheel*
110. ! Reinvent the wheel* * just not on the client side…
111. ! Reinvent the wheel* * just not on the client side…
112. ! Reinvent the wheel
113. Take a look at other libraries
114. Take a look at other languages
115. Node: a target for traditional "CRUD" web applications
116. Thanks! @tgriesser