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
310

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
39
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
Databricks （と気合い）で頑張るAI Agent 運用
Avatar for camay kameitomohiro
0
340
Eight Engineering Unit 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
1
6.8k
三菱UFJ銀行におけるエンタープライズAI駆動開発のリアル / Enterprise AI_Driven Development at MUFG Bank: The Real Story
Avatar for 三菱UFJインフォメーションテクノロジー株式会社 muit
10
20k
1 年間の育休から時短勤務で復帰した私が、 AI を駆使して立ち上がりを早めた話
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
200
インシデント対応入門
Avatar for gr1m0h grimoh
7
5.6k
オンプレとGoogle Cloudを安全に繋ぐための、セキュア通信の勘所
Avatar for Yuta Ozaki waiwai2111
3
1k
生成AI活用によるPRレビュー改善の歩み
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
4
1.8k
Claude Cowork Plugins を読む - Skills駆動型業務エージェント設計の実像と構造
Avatar for 西岡 賢一郎 (Kenichiro Nishioka) knishioka
0
210
APMの世界から見るOpenTelemetryのTraceの世界 / OpenTelemetry in the Java
Avatar for soudai sone soudai
PRO
0
210
Data Hubグループ 紹介資料
Avatar for Sansan, Inc. sansan33
PRO
0
2.8k
Master Dataグループ紹介資料
Avatar for Sansan, Inc. sansan33
PRO
1
4.4k
失敗できる意思決定とソフトウェアとの正しい歩き方_-_変化と向き合う選択肢/ Designing for Reversible Decisions
Avatar for soudai sone soudai
PRO
8
1.4k

Featured

See All Featured
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
52
3.6k
Unsuck your backbone
Avatar for Amy Palamountain ammeep
672
58k
[SF Ruby Conf 2025] Rails X
Avatar for Vladimir Dementyev palkan
2
800
Visual Storytelling: How to be a Superhuman Communicator
Avatar for David Neal reverentgeek
2
460
Put a Button on it: Removing Barriers to Going Fast.
Avatar for kastner kastner
60
4.2k
Product Roadmaps are Hard
Avatar for C. Todd Lombardo iamctodd
PRO
55
12k
The Curious Case for Waylosing
Avatar for Cassini Nazir cassininazir
0
260
What’s in a name? Adding method to the madness
Avatar for The Alliance productmarketing
PRO
24
3.9k
StorybookのUI Testing Handbookを読んだ
Avatar for Shingo Yamazaki zakiyama
31
6.6k
SEO Brein meetup: CTRL+C is not how to scale international SEO
Avatar for Linda Hogenes lindahogenes
0
2.4k
Conquering PDFs: document understanding beyond plain text
Avatar for Ines Montani inesmontani
PRO
4
2.4k
Ethics towards AI in product and experience design
Avatar for Skipper Chong Warson skipperchong
2
210

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]