The Beauty of Simplicity: Mastering Database Design with Redis

Transcript

1. The Beauty of Simplicity Mastering Database Design with Redis

2. None

3. Who has used Redis before?

4. user_count user:next_id user:8:email_address user:8:friend_ids [email protected] 293 {1,5,29,222} 292 Key-Value Store

5. Data in RAM Persisted to Disk

6. and more! Slave Replication Publish-Subscribe Basic Transactions Features!

7. Data Types

8. 0 1 2 3 4 5 6 7 8 9

   10 11 12 13 Lists

9. Sets 1 2 ∩ ∪ ∆

10. Sorted Sets n0 n1 n2 n3 n4 n5 n6 n7

    n8 n9 n10 n11 n12 n13

11. foo bar baz buz a b c d Hashes

12. Use-case Specific

13. Use-case Specific the heart of NoSQL

14. None
15. None

16. Emergent Design test-driven architecture VS ActiveRecord/Migrations

17. SQL SQLite

18. SQL SQLite Emergent Design Redis?

19. None

20. User - email_address - password

21. INCR users:next_id SET users:1:email_address "[email protected]" SET users:1:password "d3b07384d113edec49eaa6238ad5ff00" Storing a

    User

22. GET ...?

23. INCR users:next_id SET users:1:email_address "[email protected]" SET users:1:password "d3b07384d113edec49eaa6238ad5ff00" SET “users:by_email:[email protected]”

    1 Storing a User

24. GET “user:by_email:[email protected]” GET user:1:password # compare against provided, hashed password

    Login

25. INCR widgets:next_id SET widgets:1:name “Foo Widget” ... INCR widgets:next_id SET

    widgets:2:name “Bar Widget” Storing Widgets

26. GET *?

27. KEYS widgets:*

28. GET *?

29. INCR widgets:next_id SET widgets:1:name “Foo Widget” RPUSH widgets:all 1 ...

    INCR widgets:next_id SET widgets:2:name “Bar Widget” RPUSH widgets:all 2 Storing Widgets

30. LRANGE widgets:all 0 -1 GET widgets:1:name GET widgets:2:name Getting Widgets

31. SELECT * FROM users

32. SELECT LAME FROM users

33. INCR widgets:next_id SET widgets:1:name “Foo Widget” RPUSH widgets:all 1 ...

    INCR widgets:next_id SET widgets:2:name “Bar Widget” RPUSH widgets:all 2

34. INCR widgets:next_id SET widgets:1:name “Foo Widget” SET widgets:1:due_date 1339762363 RPUSH

    widgets:all 1 ZADD widgets:all_by_due_date 1 1339762590 ... INCR widgets:next_id SET widgets:2:name “Bar Widget” SET widgets:2:due_date 1339762363 RPUSH widgets:all 2 ZADD widgets:all_by_due_date 2 1339762363 Preparing to Query

35. ZRANGE widgets:all_by_due_date 0 -1 GET widgets:2:name GET widgets:2:due_date GET widgets:1:name

    GET widgets:1:due_date Getting Widgets
36. None

37. Secondary I ndexes

38. None
39. None

40. Graph Databases Inverse Indexes GIS Extra Credit

41. The Beauty of Simplicity Mastering Database Design with Redis @ryanbriones