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
260

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
86
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
130
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
700
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
Aspire をカスタマイズしよう & Aspire 9.2
Avatar for neno nenonaninu
0
350
OPENLOGI Company Profile
Avatar for OPENLOGI hr01
0
63k
フルカイテン株式会社 エンジニア向け採用資料
Avatar for FULL KAITEN fullkaiten
0
5.4k
AWSの新機能検証をやる時こそ、Amazon Qでプロンプトエンジニアリングを駆使しよう
Avatar for k-kun duelist2020jp
1
330
DjangoCon Europe 2025 Keynote - Django for Data Science
Avatar for William S. Vincent wsvincent
0
370
MCPが変えるAIとの協働
Avatar for 西岡 賢一郎 (Kenichiro Nishioka) knishioka
1
120
AIコーディングの最前線 〜活用のコツと課題〜
Avatar for PharmaX（旧YOJO Technologies）開発チーム pharma_x_tech
4
2.9k
Azure Maps Visual in PowerBIで分析しよう
Avatar for なかしょ nakasho
0
190
ビジネスとデザインとエンジニアリングを繋ぐために 一人のエンジニアは何ができるか / What can a single engineer do to connect business, design, and engineering?
Avatar for 株式会社カミナシ kaminashi
2
860
genspark_presentation.pdf
Avatar for h.uriu haruki_uiru
0
140
AIと共に乗り越える、 入社後２ヶ月の苦労と学習の軌跡
Avatar for Sai Kaneko sai_kaneko
0
190
LINE 購物幕後推手
Avatar for LINE Developers Taiwan line_developers_tw
PRO
0
310

Featured

See All Featured
Design and Strategy: How to Deal with People Who Don’t "Get" Design
Avatar for Morgane Peng morganepeng
129
19k
Code Reviewing Like a Champion
Avatar for maltzj maltzj
523
40k
Gamification - CAS2011
Avatar for David Bonilla davidbonilla
81
5.3k
Done Done
Avatar for chrislema chrislema
184
16k
Bash Introduction
Avatar for André Augusto Costa Santos 62gerente
611
210k
The MySQL Ecosystem @ GitHub 2015
Avatar for Sam Lambert samlambert
251
12k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
Avatar for Eileen M. Uchitelle eileencodes
137
33k
Git: the NoSQL Database
Avatar for Brandon Keepers bkeepers
PRO
430
65k
A Tale of Four Properties
Avatar for Chris Coyier chriscoyier
158
23k
Side Projects
Avatar for Sacha Greif sachag
453
42k
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
68
11k
Distributed Sagas: A Protocol for Coordinating Microservices
Avatar for Caitie McCaffrey caitiem20
331
21k

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]