Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Introduction to SQLAlchemy ORMs
Search
Shrayas Rajagopal
November 29, 2014
Technology
1
250
Introduction to SQLAlchemy ORMs
A talk at the November ChennaiPy meetup about getting started with SQLAlchemy ORMs
Shrayas Rajagopal
November 29, 2014
Tweet
Share
More Decks by Shrayas Rajagopal
See All by Shrayas Rajagopal
The programmers guide to timestamps and timezones - PyCon India 2023
shrayasr
0
82
A gentle introduction to types
shrayasr
1
130
The beauty that is PostgreSQL
shrayasr
2
310
Python, Imap & Gmail
shrayasr
2
210
Hylang - A Python powered Lisp AND a Lisp powered Python
shrayasr
2
580
My journey with the world of Open Source
shrayasr
1
190
Intro to Mac OSX
shrayasr
2
160
Android, A premiere
shrayasr
1
110
SeeQuaL
shrayasr
1
140
Other Decks in Technology
See All in Technology
Data and AI Governance: Existing Challenges and Emerging Trends
scotthsieh825
0
160
Tableau事例紹介 / Tableau Case Study of Eureka
kazuya_araki_tokyo
1
170
Oracle Cloud Infrastructure:2024年4月度サービス・アップデート
oracle4engineer
PRO
1
110
AWS を使う上で知っておきたいオンプレミス知識/aws-on-premise-essentials
emiki
1
4.2k
Vertex AI を中心に 生成AIのアップデートを共有します
kaz1437
0
150
TransitGatewayの基礎
toru_kubota
0
230
巨大なテーブルのテーブル定義を無停止で安全に誰でも変更できるようにする / Table-definitions-for-huge-tables-can-be-modified-by-anyone-safely-and-non-disruptively
freee
1
740
テストプロセスで大事にしていること #jasstnano
makky_tyuyan
0
130
PHPカンファレンス小田原2024
ysknsid25
3
660
Algyan イベント振り返り
linyixian
0
190
コードを書く隙間を見つけて生きていく技術/Findy 思考の現在地
fujiwara3
24
5.2k
「ふりかえりのふりかえり」をふりかえり、実のあるふりかえりにする
naitosatoshi
0
220
Featured
See All Featured
Understanding Cognitive Biases in Performance Measurement
bluesmoon
6
990
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
39
4.4k
What’s in a name? Adding method to the madness
productmarketing
PRO
15
2.6k
Ruby is Unlike a Banana
tanoku
96
10k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
226
16k
Building Better People: How to give real-time feedback that sticks.
wjessup
354
18k
Designing for humans not robots
tammielis
247
25k
Why You Should Never Use an ORM
jnunemaker
PRO
50
8.6k
The MySQL Ecosystem @ GitHub 2015
samlambert
242
12k
The Cult of Friendly URLs
andyhume
74
5.7k
The World Runs on Bad Software
bkeepers
PRO
61
6.7k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
eileencodes
124
32k
Transcript
CHENNAIPY NOV 2014
shrayas
shrayasr
shrayasr Twitter / Github / Gmail
shrayasr Logic Soft
shrayasr Logic Soft (1986)
SQL Alchemy An Introduction to ORMs
AGENDA
What are ORMs ? What is SQLAlchemy ? Getting started
with SQLAlchemy ORMs
ORMs ? What are
Express DB Entities as Language Constructs
Objects > Schema
ADVANTAGES
Easier to READ
Easier to WRITE
Easier to WRITE Lesser
DISADVANTAGES
Too Abstracted
SQL Alchemy ? What is
Not JUST an ORM
Database Toolkit
Façade on dbapi
Transactions!
ADVANTAGES
Make adapters consistent
Very Pythonic
SQL Alchemy ORMs
DEMO
? iPython Notebook URL: http://goo.gl/JO2GVY
Fin @shrayasr
[email protected]