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
1
280

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
Tweet

More Decks by Shrayas Rajagopal

See All by Shrayas Rajagopal
Know Thy Packets - PyCon India 2025
Avatar for Shrayas Rajagopal shrayasr
0
5
Embrace the Grind
Avatar for Shrayas Rajagopal shrayasr
0
100
The programmers guide to timestamps and timezones - PyCon India 2023
Avatar for Shrayas Rajagopal shrayasr
0
150
A gentle introduction to types
Avatar for Shrayas Rajagopal shrayasr
1
140
The beauty that is PostgreSQL
Avatar for Shrayas Rajagopal shrayasr
2
330
Python, Imap & Gmail
Avatar for Shrayas Rajagopal shrayasr
2
230
Hylang - A Python powered Lisp AND a Lisp powered Python
Avatar for Shrayas Rajagopal shrayasr
2
740
My journey with the world of Open Source
Avatar for Shrayas Rajagopal shrayasr
1
200
Intro to Mac OSX
Avatar for Shrayas Rajagopal shrayasr
2
180

Other Decks in Technology

See All in Technology
JTCにおける内製×スクラム開発への挑戦〜内製化率95%達成の舞台裏/JTC's challenge of in-house development with Scrum
Avatar for AEON aeonpeople
0
270
dbt開発 with Claude Codeのためのガードレール設計
Avatar for 10xinc 10xinc
2
1.3k
20250905_MeetUp_Ito-san_s_presentation.pdf
Avatar for MagicPod magicpod
1
100
EncryptedSharedPreferences が deprecated になっちゃった！どうしよう！ / Oh no! EncryptedSharedPreferences has been deprecated! What should I do?
Avatar for Yuki Anzai yanzm
0
490
「全員プロダクトマネージャー」を実現する、Cursorによる仕様検討の自動運転
Avatar for Michiru Kato applism118
22
12k
COVESA VSSによる車両データモデルの標準化とAWS IoT FleetWiseの活用
Avatar for Yuto Osawa osawa
1
400
AWSで始める実践Dagster入門
Avatar for キタガワ kitagawaz
1
750
Generative AI Japan 第一回生成AI実践研究会「AI駆動開発の現在地──ブレイクスルーの鍵を握るのはデータ領域」
Avatar for KoheiOgawa shisyu_gaku
0
330
RSCの時代にReactとフレームワークの境界を探る
Avatar for uhyo uhyo
11
3.5k
Snowflake Intelligence × Document AIで“使いにくいデータ”を“使えるデータ”に
Avatar for Kosaku Ono kevinrobot34
1
120
Autonomous Database - Dedicated 技術詳細 / adb-d_technical_detail_jp
Avatar for oracle4engineer oracle4engineer
PRO
4
10k
エンジニアリングマネージャーの成長の道筋とキャリア / Developers Summit 2025 KANSAI
Avatar for KASUYA, Daisuke daiksy
3
1.1k

Featured

See All Featured
KATA
Avatar for Megan Lloyd mclloyd
32
14k
jQuery: Nuts, Bolts and Bling
Avatar for Doug Neiner dougneiner
64
7.9k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
Avatar for Eileen M. Uchitelle eileencodes
139
34k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
Avatar for Kevin Liebholz kevinliebholz
34
6k
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
231
18k
It's Worth the Effort
Avatar for 3n 3n
187
28k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
Avatar for Morgane Peng morganepeng
131
19k
Rails Girls Zürich Keynote
Avatar for Gregor Martynus gr2m
95
14k
Visualizing Your Data: Incorporating Mongo into Loggly Infrastructure
Avatar for mongodb mongodb
48
9.7k
Testing 201, or: Great Expectations
Avatar for Joseph Mastey jmmastey
45
7.7k
Easily Structure & Communicate Ideas using Wireframe
Avatar for Afnizar Nur Ghifari afnizarnur
194
16k
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
272
27k

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]