How Canner integrates with MySQL & PostgreSQL

In this talk, William, CTO & co-founder of Canner, will share how Canner integrates with MySQL & PostgreSQL, and a brief introduction of GraphQL & Apollo GraphQL & Prisma.

Transcript

1. How Canner integrates with MySQL & PostgreSQL William Chang (CTO @CannerIO) wwwy3y3@canner.io 1
2. Who am I 2 Github: @wwwy3y3 CTO & Co-founder @ canner.io William
3. Adaptive CMS
4. CMS History 4
5. Adaptive CMS 5
6. We need a interface to connect it all
7. GraphQL
8. GraphQL - A Query Language for APIs 8 GraphQL Restful API
9. GraphQL - Load data from anywhere 9
10. GraphQL -Architecture
11. Canner data model
12. Canner data model 12 GraphQL on Client (Firebase, BaaS…) Browser GraphQL on Server (MySQL, PostgreSQL…) Browser GraphQL Server
13. GraphQL on Client: Apollo 13 Build a universal GraphQL API on top of your existing REST APIs, so you can ship new application features fast without waiting on backend changes.
14. Why Apollo 14
15. How Canner implement GraphQL server?
16. Prisma 16
17. What is Prisma? 17 Prisma is a performant open-source GraphQL ORM-like layer doing the heavy lifting in your GraphQL server.
18. Prisma 18 • Define your data model • GraphQL Schema Definition Language (SDL) • Really alike Canner schema
19. Prisma 19 • OpenCRUD: OpenCRUD is a GraphQL CRUD API specification for databases • Query: filter, pagination, sort, relation • Mutation: create, update, delete, nested mutations
20. Prisma 20 Pagination Relay connection
21. Prisma 21 Create Nested Mutation
22. Blog Demo Let’s Prisma!