Step Away From That Database Andrew Godwin DjangoCon 2010 O HAI - - PowerPoint PPT Presentation

▶

Dec 30, 2023 129 likes •410 views

Step Away From That Database Andrew Godwin DjangoCon 2010 O HAI ""Andrew speaks English like a machine gun speaks bullets."" Reinout van Rees Databases Relational Databases PostgreSQL MySQL SQLite Document Databases

SLIDE 1

Step Away From That Database

Andrew Godwin

DjangoCon 2010

SLIDE 2

O HAI

SLIDE 3

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

Reinout van Rees

SLIDE 4

Databases

SLIDE 5

Relational Databases

PostgreSQL MySQL SQLite

SLIDE 6

Document Databases

MongoDB CouchDB

SLIDE 7

Key-Value Stores

Redis Cassandra

SLIDE 8

Message Queues

AMQP Celery

SLIDE 9

Various Others

Graph databases Filesystems VCSs

SLIDE 10

Just add Django

For best results,

SLIDE 11

Key/Value

import redis rdb = redis.Redis(host="localhost") rdb.set("somekey", "somevalue") print rdb.get("somekey")

SLIDE 12

Document Databases

Django itself (soon) Raw MongoEngine / django-nonrel

SLIDE 13

MongoEngine example

class Comment(EmbeddedDocument): content = StringField() class Page(Document): comments = ListField( EmbeddedDocumentField(Comment) )

SLIDE 14

Message Queues

Raw Celery

SLIDE 15

VCSs

Dulwich (git) Mercurial

SLIDE 16

NoSQL

SLIDE 17

NoSQL

“Not Only SQL” “Non-rel”

SLIDE 18

Schemaless Databases

The dark side of

SLIDE 19

Honey, I Changed The Schema

Database/Branch discord Conditional madness Data migrations

SLIDE 20

Relational Integrity

SLIDE 21

Relational Databases

The changing face of

SLIDE 22

Schemas ain't so rigid

SLIDE 23

JSON column types

SLIDE 24

LISTEN / NOTIFY

SLIDE 25

There's no single good solution.

SLIDE 26

There's no single good solution.

(and friends don't let friends use MySQL)

SLIDE 27

Thanks.

Andrew Godwin

@andrewgodwin http://aeracode.org