Front-end only web applications powered by CartoDB

An overview of how CartoDB makes it easy to build apps on the web but also a preview of using CartoDB plus Security Definers to act as a data posting endpoint for your forms or apps.

Transcript

1. Front-end only web applications powered by CartoDB @ANDREWXHILL
2. Deploying code on the web has never been easier remember when...
3. Bl.ocks
4. Gists
5. GitHub Pages
6. GitHub
7. Ec2
8. Dropbox
9. S3
10. If you want to put HTML+Javascript online you can... easily the fact is
11. That is where CartoDB comes in in more than one way
12. http://cdb.io/176ij9j
13. http://aitor.is/iceland-contour/
18. http://mwcimpact.com/
19. A lot of people still associate CartoDB with maps not wrong, but not complete
20. CartoDB can maps for your applications
21. But, what about just data? a growing ecosystem of services
22. CartoDB now makes the data part easier than ever with beautiful results
23. SQL API
24. Data out
25. Data in
26. CartoDB becomes really powerful when your data grows let’s take a look
27. Barcelona
28. Barcelona
30. Barcelona
31. But we still built a backend application not really proxy free
32. http://bit.ly/YVZRjG
33. https://vimeo.com/channels/cartodb
35. The power of dynamic data exploit both the SQL API and the maps for live data
37. http://bit.ly/YVZRjG
38. There is still the missing link... collecting data without a proxy
39. Let’s build a data editing app that runs on a GitHub Gist! so beta!
40. CartoDB Table for Data A special PostgreSQL function Public Gist with HTML + JS A risk taking attitude (jk jk) How we can do it today
41. Creating a table
45. Writing the PostgreSQL Function
46. The public, the private, and the security definer
47. Public - everyone reads
48. Private - admin only
49. The security definer lets us play in the gray area
51. Type constraints to our advantage caution
52. cmd = "update people set name= %s where id=%s" pythonic
53. A geometry is a geometry but in SQL A string is a string A number is a number
54. http://bit.ly/11daLSh
55. Some HTML + Javascript just cut and pasts from various tutorials etc...
57. SELECT AXH_NewMinneapolis(parent_id, geometry) id GET Request from client Returns new unique ID On ‘Save’
58. A risk taking attitude* * beta
59. http://bit.ly/12w021T
60. The uses of a proxyless app?
65. Where is it going?
66. Security review
67. User interface
68. Server variables
69. Production!
71. THANKS! @ANDREWXHILL