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
270

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
Embrace the Grind
Avatar for Shrayas Rajagopal shrayasr
0
93
The programmers guide to timestamps and timezones - PyCon India 2023
Avatar for Shrayas Rajagopal shrayasr
0
130
A gentle introduction to types
Avatar for Shrayas Rajagopal shrayasr
1
140
The beauty that is PostgreSQL
Avatar for Shrayas Rajagopal shrayasr
2
320
Python, Imap & Gmail
Avatar for Shrayas Rajagopal shrayasr
2
220
Hylang - A Python powered Lisp AND a Lisp powered Python
Avatar for Shrayas Rajagopal shrayasr
2
720
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
Android, A premiere
Avatar for Shrayas Rajagopal shrayasr
1
120

Other Decks in Technology

See All in Technology
PHP開発者のためのSOLID原則再入門 #phpcon / PHP Conference Japan 2025
Avatar for shogogg shogogg
4
930
Lambda Web Adapterについて自分なりに理解してみた
Avatar for Makky12 smt7174
5
140
Oracle Cloud Infrastructure：2025年6月度サービス・アップデート
Avatar for oracle4engineer oracle4engineer
PRO
2
310
Claude Code Actionを使ったコード品質改善の取り組み
Avatar for Katsunori Kanda potix2
PRO
6
2.6k
AWS Summit Japan 2025 Community Stage - App workflow automation by AWS Step Functions
Avatar for matsuihidetoshi matsuihidetoshi
1
310
変化する開発、進化する体系時代に適応するソフトウェアエンジニアの知識と考え方（JaSST'25 Kansai）
Avatar for みずのり mizunori
1
260
CursorによるPMO業務の代替 / Automating PMO Tasks with Cursor
Avatar for Motoyoshi Kosei motoyoshi_kakaku
2
780
AI導入の理想と現実～コストと浸透〜
Avatar for oprst oprstchn
0
150
Amazon S3標準/ S3 Tables/S3 Express One Zoneを使ったログ分析
Avatar for ShigeruOda shigeruoda
5
590
Node-RED × MCP 勉強会 vol.1
Avatar for 1ft-seabass 1ftseabass
PRO
0
180
2025-06-26 GitHub CopilotとAI駆動開発：実践と導入のリアル
Avatar for 河内崇 fl_kawachi
1
240
ドメイン特化なCLIPモデルとデータセットの紹介
Avatar for tattaka tattaka
1
440

Featured

See All Featured
Building an army of robots
Avatar for Kyle Neath kneath
306
45k
[RailsConf 2023] Rails as a piece of cake
Avatar for Vladimir Dementyev palkan
55
5.6k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
35
2.4k
Mobile First: as difficult as doing things right
Avatar for Swwweet swwweet
223
9.7k
A better future with KSS
Avatar for Kyle Neath kneath
239
17k
Understanding Cognitive Biases in Performance Measurement
Avatar for Philip Tellis bluesmoon
29
1.8k
YesSQL, Process and Tooling at Scale
Avatar for Rocio Delgado rocio
173
14k
Become a Pro
Avatar for Speaker Deck speakerdeck
PRO
28
5.4k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
30
2.1k
A Tale of Four Properties
Avatar for Chris Coyier chriscoyier
160
23k
For a Future-Friendly Web
Avatar for Brad Frost brad_frost
179
9.8k
Large-scale JavaScript Application Architecture
Avatar for Addy Osmani addyosmani
512
110k

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]