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
350
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
59
Embrace the Grind
Avatar for Shrayas Rajagopal shrayasr
0
140
The programmers guide to timestamps and timezones - PyCon India 2023
Avatar for Shrayas Rajagopal shrayasr
0
190
A gentle introduction to types
Avatar for Shrayas Rajagopal shrayasr
1
190
The beauty that is PostgreSQL
Avatar for Shrayas Rajagopal shrayasr
2
340
Python, Imap & Gmail
Avatar for Shrayas Rajagopal shrayasr
2
260
Hylang - A Python powered Lisp AND a Lisp powered Python
Avatar for Shrayas Rajagopal shrayasr
2
820
My journey with the world of Open Source
Avatar for Shrayas Rajagopal shrayasr
1
240
Intro to Mac OSX
Avatar for Shrayas Rajagopal shrayasr
2
220

Other Decks in Technology

See All in Technology
ホームラボ紹介
Avatar for 世良泰明 y_sera15
0
190
Apache Icebergインフラストラクチャ: ストレージ・カタログ・エンジンの選択肢と Clouderaプラットフォームでの実装
Avatar for tsugiyama-cloudera tsugiyama
0
110
20260804_Q4AzureUpdateBite_FabricDataAgentの精度を高める設計.pdf
Avatar for matayuuu matayuuu
1
140
え？フロントエンドエンジニアの ワイがインフラも！？
Avatar for puku0x puku0x
1
620
モバイルアプリ開発概論2026
Avatar for Recruit recruitengineers
PRO
6
620
ボトムアップ文化が強い組織で セキュリティをどう根付かせていくかの現在進行形の話 / Making Security Stick in a Bottom-Up Organization
Avatar for Takashi Yamaguchi yamaguchitk333
0
230
MulticaとPi Coding Agentで、小規模OSSを30本同時運用した流れ
Avatar for eiei114 eiei114
0
130
生成 AI の基礎 〜 サンプル実装で学ぶ基本原理
Avatar for Etsuji Nakai enakai00
7
4.4k
私がブラウザを自作したくなった理由
Avatar for Miyamoto Naoyuki supurazako
1
240
Bits AI を制するものは Datadog を制す / The player that controls  Bits AI, controls Datadog
Avatar for 株式会社カミナシ kaminashi
0
110
Webアクセシビリティ入門 2026
Avatar for Recruit recruitengineers
PRO
3
590
ハーレムエンジニアリング
Avatar for yamachan kazuma777777
0
170

Featured

See All Featured
No one is an island. Learnings from fostering a developers community.
Avatar for Antonio thoeni
21
3.8k
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
3.9k
A designer walks into a library…
Avatar for Paul Jervis Heath pauljervisheath
211
24k
What's in a price? How to price your products and services
Avatar for Michael Herold michaelherold
247
13k
We Have a Design System, Now What?
Avatar for Morgane Peng morganepeng
55
8.3k
Improving Core Web Vitals using Speculation Rules API
Avatar for Sergey Chernyshev sergeychernyshev
21
1.6k
Un-Boring Meetings
Avatar for Sebastian Deterding codingconduct
0
390
The innovator’s Mindset - 
Leading Through an Era of Exponential Change - McGill University 2025
Avatar for Jean-Marc De Jonghe jdejongh
PRO
1
240
<Decoding/> the Language of Devs - We Love SEO 2024
Avatar for Nikki Halliwell nikkihalliwell
1
290
DBのスキルで生き残る技術 - AI時代におけるテーブル設計の勘所
Avatar for soudai sone soudai
PRO
68
56k
Beyond borders and beyond the search box: How to win the global "messy middle" with AI-driven SEO
Avatar for David Carrasco davidcarrasco
3
210
Visual Storytelling: How to be a Superhuman Communicator
Avatar for David Neal reverentgeek
2
610

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]