Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Introduction to SQLAlchemy ORMs

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
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
31
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
160
A gentle introduction to types
Avatar for Shrayas Rajagopal shrayasr
1
160
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
790
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
190

Other Decks in Technology

See All in Technology
フロントエンド開発者のための「厄払い」
Avatar for OPTiM optim
0
180
変化するコーディングエージェントとの現実的な付き合い方 〜Cursor安定択説と、ツールに依存しない「資産」〜
Avatar for empitsu empitsu
4
860
SREの仕事を自動化する際にやっておきたい5つのポイント
Avatar for Kazuto Kusama jacopen
6
1.2k
Introduction to Sansan for Engineers / エンジニア向け会社紹介
Avatar for Sansan, Inc. sansan33
PRO
6
66k
生成AI時代にこそ求められるSRE / SRE for Gen AI era
Avatar for ymotongpoo ymotongpoo
4
850
Deno・Bunの標準機能やElysiaJSを使ったWebSocketサーバー実装 / ラーメン屋を貸し切ってLT会! IoTLT 2026新年会
Avatar for you（@youtoy） you
PRO
0
190
SREじゃなかった僕らがenablingを通じて「SRE実践者」になるまでのリアル / SRE Kaigi 2026
Avatar for AEON aeonpeople
6
630
M&A 後の統合をどう進めるか ─ ナレッジワーク × Poetics が実践した組織とシステムの融合
Avatar for KNOWLEDGE WORK / 株式会社ナレッジワーク kworkdev
PRO
1
140
ファシリテーション勉強中 その場に何が求められるかを考えるようになるまで / 20260123 Naoki Takahashi
Avatar for SHIFT EVOLVE shift_evolve
PRO
3
420
【５分でわかる】セーフィー エンジニア向け会社紹介
Avatar for Safie safie_recruit
0
41k
Amazon S3 Vectorsを使って資格勉強用AIエージェントを構築してみた
Avatar for usanchuu usanchuu
3
340
入社1ヶ月でデータパイプライン講座を作った話
Avatar for Yuta Ozaki waiwai2111
1
200

Featured

See All Featured
How to train your dragon (web standard)
Avatar for Monica Dinculescu notwaldorf
97
6.5k
Highjacked: Video Game Concept Design
Avatar for Ryan Kendrick rkendrick25
PRO
1
280
30 Presentation Tips
Avatar for Ian Lurie portentint
PRO
1
200
<Decoding/> the Language of Devs - We Love SEO 2024
Avatar for Nikki Halliwell nikkihalliwell
1
120
Getting science done with accelerated Python computing platforms
Avatar for Jacob Tomlinson jacobtomlinson
1
110
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
273
27k
A Modern Web Designer's Workflow
Avatar for Chris Coyier chriscoyier
698
190k
Bioeconomy Workshop: Dr. Julius Ecuru, Opportunities for a Bioeconomy in West Africa
Avatar for AKADEMIYA2063 akademiya2063
PRO
1
52
Are puppies a ranking factor?
Avatar for Jono Alderson jonoalderson
1
2.7k
Fight the Zombie Pattern Library - RWD Summit 2016
Avatar for Marcelo Somers marcelosomers
234
17k
Darren the Foodie - Storyboard
Avatar for Kevinho.art khoart
PRO
2
2.3k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
Avatar for Addy Osmani addyosmani
9
1.1k

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]