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
Sponsored
·
Ship Features Fearlessly
Turn features on and off without deploys. Used by thousands of Ruby developers.
→
Shrayas Rajagopal
November 29, 2014
Technology
1
310
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
Know Thy Packets - PyCon India 2025
shrayasr
0
31
Embrace the Grind
shrayasr
0
120
The programmers guide to timestamps and timezones - PyCon India 2023
shrayasr
0
160
A gentle introduction to types
shrayasr
1
160
The beauty that is PostgreSQL
shrayasr
2
330
Python, Imap & Gmail
shrayasr
2
230
Hylang - A Python powered Lisp AND a Lisp powered Python
shrayasr
2
790
My journey with the world of Open Source
shrayasr
1
210
Intro to Mac OSX
shrayasr
2
190
Other Decks in Technology
See All in Technology
フロントエンド開発者のための「厄払い」
optim
0
180
変化するコーディングエージェントとの現実的な付き合い方 〜Cursor安定択説と、ツールに依存しない「資産」〜
empitsu
4
860
SREの仕事を自動化する際にやっておきたい5つのポイント
jacopen
6
1.2k
Introduction to Sansan for Engineers / エンジニア向け会社紹介
sansan33
PRO
6
66k
生成AI時代にこそ求められるSRE / SRE for Gen AI era
ymotongpoo
4
850
Deno・Bunの標準機能やElysiaJSを使ったWebSocketサーバー実装 / ラーメン屋を貸し切ってLT会! IoTLT 2026新年会
you
PRO
0
190
SREじゃなかった僕らがenablingを通じて「SRE実践者」になるまでのリアル / SRE Kaigi 2026
aeonpeople
6
630
M&A 後の統合をどう進めるか ─ ナレッジワーク × Poetics が実践した組織とシステムの融合
kworkdev
PRO
1
140
ファシリテーション勉強中 その場に何が求められるかを考えるようになるまで / 20260123 Naoki Takahashi
shift_evolve
PRO
3
420
【5分でわかる】セーフィー エンジニア向け会社紹介
safie_recruit
0
41k
Amazon S3 Vectorsを使って資格勉強用AIエージェントを構築してみた
usanchuu
3
340
入社1ヶ月でデータパイプライン講座を作った話
waiwai2111
1
200
Featured
See All Featured
How to train your dragon (web standard)
notwaldorf
97
6.5k
Highjacked: Video Game Concept Design
rkendrick25
PRO
1
280
30 Presentation Tips
portentint
PRO
1
200
<Decoding/> the Language of Devs - We Love SEO 2024
nikkihalliwell
1
120
Getting science done with accelerated Python computing platforms
jacobtomlinson
1
110
Intergalactic Javascript Robots from Outer Space
tanoku
273
27k
A Modern Web Designer's Workflow
chriscoyier
698
190k
Bioeconomy Workshop: Dr. Julius Ecuru, Opportunities for a Bioeconomy in West Africa
akademiya2063
PRO
1
52
Are puppies a ranking factor?
jonoalderson
1
2.7k
Fight the Zombie Pattern Library - RWD Summit 2016
marcelosomers
234
17k
Darren the Foodie - Storyboard
khoart
PRO
2
2.3k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
9
1.1k
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]