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
63
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
200
The beauty that is PostgreSQL
Avatar for Shrayas Rajagopal shrayasr
2
350
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
250
Intro to Mac OSX
Avatar for Shrayas Rajagopal shrayasr
2
220

Other Decks in Technology

See All in Technology
Sony-DroidKaigi2026
Avatar for ソニー株式会社 sony
1
300
リージョンの壁を越える、 ちょっと変わったAWSサービスの話
Avatar for Michael Tedder falken
PRO
0
150
指示待ちから変化に応じるClaude Codeへ！~環境からAgentへの帰り道を作る~
Avatar for Gota gotalab555
9
1.8k
Instana&Bob トラブルシュートハンズオン
Avatar for 山崎政憲 mayamasaki68
0
110
Point Cloud as a Foreign Language for Multi-modal Large Language Model
Avatar for Takuya MINAGAWA takmin
0
360
V8コントリビュート超入門
Avatar for Riya Amemiya riyaamemiya
0
120
Genie Code ワークショップ 基礎編 / Genie-Code-Workshop-fundamental
Avatar for Databricks Japan databricksjapan
PRO
0
310
DGX Sparkを2台使って いろいろ動かす話
Avatar for そのだ sonoda_mj
1
120
Introduction to Sansan for Engineers / エンジニア向け会社紹介
Avatar for Sansan, Inc. sansan33
PRO
6
77k
いかに伝えるか　〜新卒エンジニアの教育のための、ライトノベル活用の一例
Avatar for Akira Ikeda（池田 暁） ikedon
1
170
PM領域でのAI Agentの活用
Avatar for LINEヤフーTech (LY Corporation Tech) lycorptech_jp
PRO
0
240
Hub & Spoke 環境のネットワークルーティングを分解してみる
Avatar for Tsuyataku tsuyataku
1
510

Featured

See All Featured
How To Stay Up To Date on Web Technology
Avatar for Chris Coyier chriscoyier
790
250k
A Guide to Academic Writing Using Generative AI - A Workshop
Avatar for Kenji Saito ks91
PRO
1
410
Un-Boring Meetings
Avatar for Sebastian Deterding codingconduct
0
410
Building a Scalable Design System with Sketch
Avatar for Laura Van Doore lauravandoore
463
34k
Are puppies a ranking factor?
Avatar for Jono Alderson jonoalderson
2
3.9k
BBQ
Avatar for Matthew Crist matthewcrist
89
10k
Discover your Explorer Soul
Avatar for Emna emna__ayadi
2
1.3k
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
3
1.2k
Rails Girls Zürich Keynote
Avatar for Gregor Martynus gr2m
96
14k
Navigating the Design Leadership Dip - Product Design Week Design Leaders+ Conference 2024
Avatar for Andy Polaine apolaine
2
410
Digital Projects Gone Horribly Wrong (And the UX Pros Who Still Save the Day) - Dean Schuster
Avatar for UX Y'all uxyall
1
2.7k
How STYLIGHT went responsive
Avatar for nonsquared nonsquared
100
6.3k

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]