Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Introduction to SQLAlchemy ORMs

Avatar for Shrayas Rajagopal Shrayas Rajagopal
November 29, 2014
Technology
320
1

Introduction to SQLAlchemy ORMs

A talk at the November ChennaiPy meetup about getting started with SQLAlchemy ORMs

Avatar for Shrayas Rajagopal

Shrayas Rajagopal

November 29, 2014

More Decks by Shrayas Rajagopal

See All by Shrayas Rajagopal
Know Thy Packets - PyCon India 2025
Avatar for Shrayas Rajagopal shrayasr
0
40
Embrace the Grind
Avatar for Shrayas Rajagopal shrayasr
0
120
The programmers guide to timestamps and timezones - PyCon India 2023
Avatar for Shrayas Rajagopal shrayasr
0
170
A gentle introduction to types
Avatar for Shrayas Rajagopal shrayasr
1
170
The beauty that is PostgreSQL
Avatar for Shrayas Rajagopal shrayasr
2
340
Python, Imap & Gmail
Avatar for Shrayas Rajagopal shrayasr
2
240
Hylang - A Python powered Lisp AND a Lisp powered Python
Avatar for Shrayas Rajagopal shrayasr
2
800
My journey with the world of Open Source
Avatar for Shrayas Rajagopal shrayasr
1
210
Intro to Mac OSX
Avatar for Shrayas Rajagopal shrayasr
2
200

Other Decks in Technology

See All in Technology
QGISプラグイン CMChangeDetector
Avatar for Forestgeo.info naokimuroki
1
420
20260428_Product Management Summit_tadokoroyoshiro
Avatar for tadokoro_yoshiro tadokoro_yoshiro
4
2.5k
明日からドヤれる！超マニアックなAWSセキュリティTips10連発 / 10 Ultra-Niche AWS Security Tips
Avatar for Yuji Oshima yuj1osm
0
600
Keeping Ruby Running on Cygwin
Avatar for fd0 fd0
0
170
AndroidアプリとCopilot Studioの統合
Avatar for なかしょ nakasho
0
110
[最強DB講義]推薦システム | 基礎編
Avatar for RecSysLab recsyslab
PRO
1
180
自分のハンドルは自分で握れ！ ― 自分のケイパビリティを増やし、メンバーのケイパビリティ獲得を支援する ― / Take the wheel yourself
Avatar for TAKAKING22 takaking22
1
930
プラットフォームエンジニアリングの実践 - AWS コンテナサービスで構築する社内プラットフォーム / AWS Containers Platform Meetup #1
Avatar for Masatoshi Hayashi literalice
1
200
小説執筆のハーネスエンジニアリング
Avatar for osushi_cr yoshitetsu
0
720
20年前の「OSS革命」に学ぶ AI時代の生存戦略
Avatar for Sam Akada samakada
0
450
[OpsJAWS 40]リリースしたら終わり、じゃなかった。セキュリティ空白期間をAWS Security Agentで埋める
Avatar for sh_fk2 sh_fk2
3
240
Microsoft 365 / Microsoft 365 Copilot : 自分の状態を確認する「ラベル」について
Avatar for Taichi Nakamura taichinakamura
0
290

Featured

See All Featured
New Earth Scene 8
Avatar for Sydney Stone popppiees
3
2.1k
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
273
27k
Navigating the moral maze — ethical principles for Al-driven product design
Avatar for Skipper Chong Warson skipperchong
2
340
Building an army of robots
Avatar for Kyle Neath kneath
306
46k
A Tale of Four Properties
Avatar for Chris Coyier chriscoyier
163
24k
Fashionably flexible responsive web design (full day workshop)
Avatar for Andy Clarke malarkey
408
66k
Applied NLP in the Age of Generative AI
Avatar for Ines Montani inesmontani
PRO
4
2.2k
The Invisible Side of Design
Avatar for Vitaly Friedman smashingmag
303
52k
The innovator’s Mindset - 
Leading Through an Era of Exponential Change - McGill University 2025
Avatar for Jean-Marc De Jonghe jdejongh
PRO
1
160
Designing for Performance
Avatar for Lara Hogan lara
611
70k
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
340
58k
Jamie Indigo - Trashchat’s Guide to Black Boxes: Technical SEO Tactics for LLMs
Avatar for Tech SEO Connect techseoconnect
PRO
0
110

Transcript

  1. CHENNAIPY NOV 2014

  2. shrayas

  3. shrayasr

  4. shrayasr Twitter / Github / Gmail

  5. shrayasr Logic Soft

  6. shrayasr Logic Soft (1986)

  7. SQL Alchemy An Introduction to ORMs

  8. AGENDA

  9. What are ORMs ? What is SQLAlchemy ? Getting started

    with SQLAlchemy ORMs

  10. ORMs ? What are

  11. Express DB Entities as Language Constructs

  12. Objects > Schema

  13. ADVANTAGES

  14. Easier to READ

  15. Easier to WRITE

  16. Easier to WRITE Lesser

  17. DISADVANTAGES

  18. Too Abstracted

  19. SQL Alchemy ? What is

  20. Not JUST an ORM

  21. Database Toolkit

  22. Façade on dbapi

  23. Transactions!

  24. ADVANTAGES

  25. Make adapters consistent

  26. Very Pythonic

  27. SQL Alchemy ORMs

  28. DEMO

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

  30. Fin @shrayasr [email protected]