Fun with Django and Databases

Transcript

1. Django and Databases Fun with

2. ""Andrew speaks English like a machine gun speaks bullets."" Reinout

   van Rees

3. Introduction

4. from django.db import models

5. First, an aside

6. ""When all you have is a hammer, everything looks like

   a nail"" Abraham Manslow (paraphrased)

7. Also, "NoSQL"? Really?

8. queryset.raw()

9. qs = Teacher.objects.raw(""" SELECT t.name, COUNT(s.id) FROM school_teacher AS t

   INNER JOIN school_student AS s ON t.id = s.teacher_id GROUP BY t.name HAVING COUNT(s.id) > 2 """)

10. queryset.aggregate()

11. qs = Teacher.objects.annotate( num_students = models.Count('student') ).filter(num_students__gt=2)

12. Search haystack __search=

13. Schema Changes

14. Changing Requirements

15. Dynamic/Unknown Data

16. Document Databases MongoDB CouchDB

17. Key-Value Stores Redis Cassandra

18. Redis Sets Sorted Sets Hashes Pub/Sub Atomicity

19. Message Queues AMQP Celery

20. Various Others Graph databases Filesystems VCSs

21. Conclusion

22. Thanks. Andrew Godwin @andrewgodwin http://aeracode.org