Slide 1

Slide 1 text

CHENNAIPY NOV 2014

Slide 2

Slide 2 text

shrayas

Slide 3

Slide 3 text

shrayasr

Slide 4

Slide 4 text

shrayasr Twitter / Github / Gmail

Slide 5

Slide 5 text

shrayasr Logic Soft

Slide 6

Slide 6 text

shrayasr Logic Soft (1986)

Slide 7

Slide 7 text

SQL Alchemy An Introduction to ORMs

Slide 8

Slide 8 text

AGENDA

Slide 9

Slide 9 text

What are ORMs ? What is SQLAlchemy ? Getting started with SQLAlchemy ORMs

Slide 10

Slide 10 text

ORMs ? What are

Slide 11

Slide 11 text

Express DB Entities as Language Constructs

Slide 12

Slide 12 text

Objects > Schema

Slide 13

Slide 13 text

ADVANTAGES

Slide 14

Slide 14 text

Easier to READ

Slide 15

Slide 15 text

Easier to WRITE

Slide 16

Slide 16 text

Easier to WRITE Lesser

Slide 17

Slide 17 text

DISADVANTAGES

Slide 18

Slide 18 text

Too Abstracted

Slide 19

Slide 19 text

SQL Alchemy ? What is

Slide 20

Slide 20 text

Not JUST an ORM

Slide 21

Slide 21 text

Database Toolkit

Slide 22

Slide 22 text

Façade on dbapi

Slide 23

Slide 23 text

Transactions!

Slide 24

Slide 24 text

ADVANTAGES

Slide 25

Slide 25 text

Make adapters consistent

Slide 26

Slide 26 text

Very Pythonic

Slide 27

Slide 27 text

SQL Alchemy ORMs

Slide 28

Slide 28 text

DEMO

Slide 29

Slide 29 text

? iPython Notebook URL: http://goo.gl/JO2GVY

Slide 30

Slide 30 text

Fin @shrayasr [email protected]