The beauty that is PostgreSQL

Transcript

1. JULY 2015 select * from meetups where name = ‘chennaipy’
2. The beauty that is PostgreSQL
3. The beauty that is PostgreSQL PART 1
4. Shrayas Karthik
5. Shrayas Karthik
6. “ World’s most advanced open source database
8. INSERT statements 1
9. JSON support 2
10. Application
11. UI
12. API UI
13. DATA API UI
14. DATA API UI
15. API UI Structured Unstructured
16. API UI Structured Unstructured
17. API UI Unstructured Structured
18. API UI Data Data
19. History
20. 9.2
21. 9.2 JSON
22. 9.2 JSON TEXT Format
23. 9.2 JSON TEXT Format OK
24. 9.2 JSON TEXT Format OK row_to_json array_to_json
25. 9.2 JSON TEXT Format row_to_json array_to_json
26. 9.4
27. 9.4 JSONB
28. 9.4 JSONB BINARY Format
29. 9.4 JSONB BINARY Format row_to_jsonb array_to_jsonb ++
30. Demo
31. { "notificationType": "Bounce", "bounce": { "bounceType": "", "bounceSubType": "", "bouncedRecipients": [ { "emailAddress": "" } ], "timestamp": "", "feedbackId": "" }, "mail": { "timestamp": "", "messageId": "", "source": "", "sourceArn": "", "sendingAccountId": "", "destination": [] } } Bounce
32. { "notificationType": "Delivery", "mail": { "timestamp": "", "messageId": "", "source": "", "sourceArn": "", "sendingAccountId": "", "destination": [] }, "delivery": { "timestamp": "", "recipients": [], "processingTimeMillis": 546, "reportingMTA": "", "smtpResponse": "" } } Delivery
33. Conclusion
34. JAI HO PostgreSQL
35. TRY IT.
36. Le Fin @shrayasr @argvk