Downloaded 397 times
![Standard Conventions Objects/records accessible by /table/id /Product/12 GET, PUT, and DELETE this resource Sub object URLs determined by object identity properties GET /Product/ [{“id”:”11”, “name”:”Dérailleur”}, {“id”:”12”, “name”:”Handle Bar”}]](https://image.slidesharecdn.com/jsonrest-1223059309115313-9/75/RESTful-JSON-web-databases-7-2048.jpg)
![JSONPath http://goessner.net/articles/JsonPath/ XPath like query language for JSON Filters - [?expr] Properties/paths (like JS) - .prop Recursive descent - ..prop Slice operator – [3:10:2] Union operator - [3,4,5]](https://image.slidesharecdn.com/jsonrest-1223059309115313-9/75/RESTful-JSON-web-databases-15-2048.jpg)
![JSONPath querying in requests REST URLs + JSONPath = Web querying /Table/ - All the objects in a table /Table/[?@.price < 10] – all items with a price under $10 /Table/..name – A list of the name property values /Table/.length – A count of the items in the table](https://image.slidesharecdn.com/jsonrest-1223059309115313-9/75/RESTful-JSON-web-databases-16-2048.jpg)
![JSONQuery http://www.sitepen.com/blog/2008/07/16/jsonquery-data-querying-beyond-jsonpath/ Lenient Syntax - ?price<10 Sorting - [/price, \rating] Mapping - [=firstName+' '+lastName] Wildcarding [?description='*fun*'] Recursive object filter - ..[?name='Bar'] Example URL: /Table/[?price<10] [={name:name, rating: rating}] [\rating]](https://image.slidesharecdn.com/jsonrest-1223059309115313-9/75/RESTful-JSON-web-databases-17-2048.jpg)
![JSON Referencing http://www.sitepen.com/blog/2008/07/16/jsonquery-data-querying-beyond-jsonpath/ { “ name”:”Kris Zyp”, “ id”:”kriszyp”, “children”:[{“id”:”jennikazyp”,“name”:”Jennika Zyp”}], “ spouse”:{ “ name”:”Nicole Zyp”, “spouse”:{“$ref”:”kriszyp”}, “ children”:[{“$ref”:”jennikazyp”}] } }](https://image.slidesharecdn.com/jsonrest-1223059309115313-9/75/RESTful-JSON-web-databases-19-2048.jpg)
![JSON Referencing http://www.sitepen.com/blog/2008/07/16/jsonquery-data-querying-beyond-jsonpath/ { “ name”:”Kris Zyp”, “children”:[{“name”:”Jennika Zyp”}], “ spouse”:{ “ name”:”Nicole Zyp”, “spouse”:{“$ref”:”#”}, “ children”:{“$ref”:”#.children”} } }](https://image.slidesharecdn.com/jsonrest-1223059309115313-9/75/RESTful-JSON-web-databases-20-2048.jpg)
![JSON Referencing http://www.sitepen.com/blog/2008/07/16/jsonquery-data-querying-beyond-jsonpath/ { “ name”:”Kris Zyp”, “ id”:”kriszyp”, “children”:[{“name”:”Jennika Zyp”}], “ friends”:[{“$ref”:”jesse#.spouse”}] }](https://image.slidesharecdn.com/jsonrest-1223059309115313-9/75/RESTful-JSON-web-databases-21-2048.jpg)
RESTful JSON web databases
- 1. JSON Web DatabasesApplied JSON: HTTP REST, Ajax databases and beyond Kris Zyp
- 2.
- 3. HTTP/REST + JSON= Database interaction for the web
- 4. Overview Interoperability BasicsTools/Frameworks Beyond simple CRUD
- 5. Interoperability Basics HTTPREST GET - query and get by id PUT - update an object POST - create an object DELETE - delete an object
- 6. Tools/Frameworks Client SidePersevere Jester Dojo Server Side ActiveResource CouchDB Persevere GrassyKnoll ...
- 7. Standard Conventions Objects/recordsaccessible by /table/id /Product/12 GET, PUT, and DELETE this resource Sub object URLs determined by object identity properties GET /Product/ [{“id”:”11”, “name”:”Dérailleur”}, {“id”:”12”, “name”:”Handle Bar”}]
- 8.
- 9. Schemas DB definedschema - ActiveRecord Schema free - CouchDB
- 10.
- 11. JSON Schema basedevolutionary schema Start without a schema Add constraints as application evolves
- 12. JSON Schema schema:{"description":"A person", "type":"object", "properties": {"name": {"type":"string"}, "age" : {"type":"integer", "maximum":125}} } instance: {“name”:”Kris”, “ age”:30}
- 13. JSON Schema drivenUI Start with schema and simple form
- 14. Querying Web-safe portabilityimportant SQL extremely hard to make secure and too complicated in the browser JSONPath JavaScript-style syntax Language agnostic Easy to secure http://goessner.net/articles/JsonPath/
- 15. JSONPath http://goessner.net/articles/JsonPath/ XPathlike query language for JSON Filters - [?expr] Properties/paths (like JS) - .prop Recursive descent - ..prop Slice operator – [3:10:2] Union operator - [3,4,5]
- 16. JSONPath querying inrequests REST URLs + JSONPath = Web querying /Table/ - All the objects in a table /Table/[?@.price < 10] – all items with a price under $10 /Table/..name – A list of the name property values /Table/.length – A count of the items in the table
- 17. JSONQuery http://www.sitepen.com/blog/2008/07/16/jsonquery-data-querying-beyond-jsonpath/ LenientSyntax - ?price<10 Sorting - [/price, \rating] Mapping - [=firstName+' '+lastName] Wildcarding [?description='*fun*'] Recursive object filter - ..[?name='Bar'] Example URL: /Table/[?price<10] [={name:name, rating: rating}] [\rating]
- 18. JSON Referencing Hyperlinking+ JSON Cyclic Multiple references Cross-message references Cross-site references http://www.sitepen.com/blog/2008/06/17/json-referencing-in-dojo/
- 19. JSON Referencing http://www.sitepen.com/blog/2008/07/16/jsonquery-data-querying-beyond-jsonpath/{ “ name”:”Kris Zyp”, “ id”:”kriszyp”, “children”:[{“id”:”jennikazyp”,“name”:”Jennika Zyp”}], “ spouse”:{ “ name”:”Nicole Zyp”, “spouse”:{“$ref”:”kriszyp”}, “ children”:[{“$ref”:”jennikazyp”}] } }
- 20. JSON Referencing http://www.sitepen.com/blog/2008/07/16/jsonquery-data-querying-beyond-jsonpath/{ “ name”:”Kris Zyp”, “children”:[{“name”:”Jennika Zyp”}], “ spouse”:{ “ name”:”Nicole Zyp”, “spouse”:{“$ref”:”#”}, “ children”:{“$ref”:”#.children”} } }
- 21. JSON Referencing http://www.sitepen.com/blog/2008/07/16/jsonquery-data-querying-beyond-jsonpath/{ “ name”:”Kris Zyp”, “ id”:”kriszyp”, “children”:[{“name”:”Jennika Zyp”}], “ friends”:[{“$ref”:”jesse#.spouse”}] }
- 22. Server side JavaScript+ web storage http://sitepen.com/labs/persevere.php "schema":{ “ name”:”Friend”, “ properties”:{ “ firstName”:{“type”:”string”}, “age”:{“type”:”integer”}, } "staticCreateMethod":function(arg1){ var friend = new Friend; friend.age = 0; }, "prototype":{ “ myMethod”:function(){ return this.firstName + ‘ ‘ + this.lastName; } } "extends":{"$ref":"../Person"} }
- 23. Security with webaccessible data storage Typical databases behind the application Web DBs are directly accessible User authorization becomes integrated with data Allows separation of application and security concerns
- 24. Security with PersevereData-centric Capability-based Logic/code based security possible as well
- 25.
- 26. Live Data Notificationswith REST Channels http://cometdaily.com/2008/05/13/http-channels-2/
- 27. Other Features Filestorage/alternate resource representations Utilize existing SQL tables SMD support Class/Table Inheritance
- 28. Persevere JSONQuery/JSONPath JSONReferencing Comet Live Data Notifications JSON Schema with evolutionary constraints JSON-RPC Built-in Security Standards based REST interface http://sitepen.com/labs/persevere.php
- 29. REST/ Ajax databasesDevelop for the future
- 30.