EdgeDB–PyBay 2022

Transcript

2. Problem Software development is hard
3. Hm…but maybe Databases are hard?
5. Forever in the 70s Install Connect SQL vs. ORM
6. SELECT title, Actors.name AS actor_name, (SELECT avg(score) FROM Movie_Reviews WHERE movie_id = Movie.id) AS rating FROM Movie LEFT JOIN Movie_Actors ON Movie.id = Movie_Actors.movie_id LEFT JOIN Person AS Actors ON Movie_Actors.person_id = Person.id WHERE 'Zendaya' IN ( SELECT Person.name FROM Movie_Actors INNER JOIN Person ON Movie_Actors.person_id = Person.id WHERE Movie_Actors.movie_id = Movie.id)
7. SELECT title, Actors.name AS actor_name, (SELECT avg(score) FROM Movie_Reviews WHERE movie_id = Movie.id) AS rating FROM Movie LEFT JOIN Movie_Actors ON Movie.id = Movie_Actors.movie_id LEFT JOIN Person AS Actors ON Movie_Actors.person_id = Person.id WHERE 'Zendaya' IN ( SELECT Person.name FROM Movie_Actors INNER JOIN Person ON Movie_Actors.person_id = Person.id WHERE Movie_Actors.movie_id = Movie.id) select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name; select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name;
9. “Stockholm syndrome” was fi rst used by the media in 1973 when four hostages were taken during a bank robbery in Stockholm, Sweden. The hostages defended their captors after being released and would not agree to testify in court against them.
10. “Async” Python Core Dev Yury Selivanov
11. uvloop & asyncpg
12. Co-founder and CEO EdgeDB
13. Make you want to learn
 about EdgeDB Goal
14. EdgeDB Install & deploy Data model Schema Query language Client APIs
15. $ curl 
 ––proto '=https' ––tlsv1.2 –sSf 
 https://sh.edgedb.com | sh A FEW SECONDS LATER $ edgedb ––help Install
16. Python Design principles Flexibility Expressiveness
17. EdgeDB Design principles Flexibility Expressiveness
18. EdgeDB A “Pythonic”
 database
19. Data model
20. Data model
21. Data model
22. Data model
23. Data model
24. Data model
25. Schema
26. Schema
31. 😨
32. Schema
33. Schema
34. Schema Strict First-class Indexes, constraints,
 annotations, introspection
35. Query language SELECT title, Actors.name AS actor_name, (SELECT avg(score) FROM Movie_Reviews WHERE movie_id = Movie.id) AS rating FROM Movie LEFT JOIN Movie_Actors ON Movie.id = Movie_Actors.movie_id LEFT JOIN Person AS Actors ON Movie_Actors.person_id = Person.id WHERE 'Zendaya' IN ( SELECT Person.name FROM Movie_Actors INNER JOIN Person ON Movie_Actors.person_id = Person.id WHERE Movie_Actors.movie_id = Movie.id) select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name; select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name;
36. select Movie { title } SELECT title FROM Movie EdgeQL SQL 36 Query Example
37. select Movie { title, actors: { name }, } SELECT title FROM Movie EdgeQL SQL 37 Query Example
38. select Movie { title, actors: { name }, } SELECT title, Actors.name AS actor_name FROM Movie LEFT JOIN Movie_Actors ON Movie.id = Movie_Actors.movie_id LEFT JOIN Person AS Actors ON Movie_Actors.person_id = Person.id EdgeQL SQL 38 [ { "title": "The Matrix", "actors": [ {"name": "Keanu Reeves"}, {"name": "Hugo Weaving"}, ] } ] [ { "title": "The Matrix", "actor_name": "Keanu Reeves", }, { "title": "The Matrix", "actor_name": "Hugo Weaving", }, ... ] Query Example
39. select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } SELECT title, Actors.name AS actor_name FROM Movie LEFT JOIN Movie_Actors ON Movie.id = Movie_Actors.movie_id LEFT JOIN Person AS Actors ON Movie_Actors.person_id = Person.id EdgeQL SQL 39 Query Example
40. select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } SELECT title, Actors.name AS actor_name, (SELECT avg(score) FROM Movie_Reviews WHERE movie_id = Movie.id) AS rating FROM Movie LEFT JOIN Movie_Actors ON Movie.id = Movie_Actors.movie_id LEFT JOIN Person AS Actors ON Movie_Actors.person_id = Person.id EdgeQL SQL 40 Query Example
41. select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name EdgeQL SQL 41 SELECT title, Actors.name AS actor_name, (SELECT avg(score) FROM Movie_Reviews WHERE movie_id = Movie.id) AS rating FROM Movie LEFT JOIN Movie_Actors ON Movie.id = Movie_Actors.movie_id LEFT JOIN Person AS Actors ON Movie_Actors.person_id = Person.id Query Example
42. select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name SELECT title, Actors.name AS actor_name, (SELECT avg(score) FROM Movie_Reviews WHERE movie_id = Movie.id) AS rating FROM Movie LEFT JOIN Movie_Actors ON Movie.id = Movie_Actors.movie_id LEFT JOIN Person AS Actors ON Movie_Actors.person_id = Person.id WHERE 'Zendaya' IN ( SELECT Person.name FROM Movie_Actors INNER JOIN Person ON Movie_Actors.person_id = person.id 
 WHERE Movie_Actors.movie_id = Movie.id ) EdgeQL SQL 42 Query Example
43. EdgeQL SQL 43 select Movie { title, actors: { name } order by @credits_order limit 5, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name SELECT title, Actors.name AS actor_name, (SELECT avg(score) FROM Movie_Reviews WHERE movie_id = Movie.id) AS rating FROM Movie LEFT JOIN Movie_Actors ON Movie.id = Movie_Actors.movie_id LEFT JOIN Person AS Actors ON Movie_Actors.person_id = Person.id WHERE 'Zendaya' IN ( SELECT Person.name FROM Movie_Actors INNER JOIN Person ON Movie_Actors.person_id = person.id 
 WHERE Movie_Actors.movie_id = Movie.id ) Query Example
44. SELECT title, Actors.name AS actor_name, (SELECT avg(score) FROM Movie_Reviews WHERE movie_id = Movie.id) AS rating FROM Movie CROSS JOIN LATERAL ( SELECT name FROM Movie_Actors INNER JOIN Person ON Movie_Actors.person_id = Person.id WHERE Movie_Actors.movie_id = Movie.id ORDER BY Movie_Actors.credits_order FETCH FIRST 5 ROWS ONLY ) AS Actors WHERE 'Zendaya' IN ( SELECT Person.name FROM Movie_Actors INNER JOIN Person ON Movie_Actors.person_id = person.id WHERE Movie_Actors.movie_id = Movie.id ) EdgeQL SQL 44 select Movie { title, actors: { name } order by @credits_order limit 5, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name Query Example
45. EdgeQL with movie_actor_names := {"Robert Downey Jr.", "Chris Evans"}, actors := (select Person filter .name in movie_actor_names), avengers := (insert Movie { title := "Avengers", actors := actors }), endgame := (insert Movie { title := "Avengers: Endgame", actors := actors }), account := (select Account filter .login = <str>$login) update 
 account 
 set { 
 watch_list += {avengers, endgame} 
 }
46. EdgeQL Strict Composable Easy to pick up GraphQL+SQL on steroids
48. Client APIs select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name; Fast Safe Zero-con fi g Easy Async or Sync
49. Client APIs
50. Client APIs
51. Client APIs
52. Client APIs
53. WHY select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name; So that you write
 fast code fast
 while having 
 fun.
54. select Movie { title, actors: { name }, rating := math::mean(.reviews.score) } filter "Zendaya" in .actors.name; @1st1 on twitter edgedb.com We are hiring.