Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

Introduction to SQLAlchemy ORMs

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for Shrayas Rajagopal Shrayas Rajagopal
November 29, 2014
Technology
360
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
68
Embrace the Grind
Avatar for Shrayas Rajagopal shrayasr
0
150
The programmers guide to timestamps and timezones - PyCon India 2023
Avatar for Shrayas Rajagopal shrayasr
0
200
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
270
Hylang - A Python powered Lisp AND a Lisp powered Python
Avatar for Shrayas Rajagopal shrayasr
2
830
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
230

Other Decks in Technology

See All in Technology
Claude Codeから見る、エンジニアの世界の変容とその先
Avatar for Oikon oikon48
8
5.3k
複雑な業務システムを高速でつくるため、チーム全員をつくれる人へ
Avatar for AyaKurabuchi ayakurabuchi
0
130
仕様駆動開発の、その先へ。決める力と確かめる仕組み
Avatar for Riku INADA inariku
1
170
re:Inventで、人生は変わったのか？ / growth-builders-hub-1-reinvent-2026
Avatar for 株式会社みずほ銀⾏ 情報数理⼯学研究所 デジタル技術開発部 mhrtech
2
300
20261031_IoTLT_vol140_kitazaki_v1.pdf
Avatar for Zakkiea kitazaki
0
160
コードレビューをなくして見えたもの
Avatar for henteko henteko
0
130
AI時代のエンジニアの情報発信〜個人の発信を組織の力に変える〜
Avatar for かわまた ryo_kawamata
1
7.2k
FinOpsを導入してマルチプロダクトのコスト最適化を実現する
Avatar for KNOWLEDGE WORK / 株式会社ナレッジワーク kworkdev
PRO
0
120
[General] 개발자로 해외 기업에서 일하기
Avatar for Jaewoong skydoves
1
290
続・ソフトウェアアーキテクトのための意思決定術: Decision Readiness, Revisited — When AI Changes the Economics of Software Architecture
Avatar for Koji SHIMADA snoozer05
PRO
4
1.1k
In-Context Learning再入門。ICLの勾配降下的解釈の研究動向を追ってみる。
Avatar for Fukushima Daisuke dai08srhg
1
140
詳解 never 型 - ボトム型の性質を深掘り
Avatar for Nealle nealle
0
140

Featured

See All Featured
The Invisible Side of Design
Avatar for Vitaly Friedman smashingmag
301
52k
Impact Scores and Hybrid Strategies: The future of link building
Avatar for Tamara Novitovic tamaranovitovic
0
480
State of Search Keynote: SEO is Dead Long Live SEO
Avatar for Ryan Jones ryanjones
0
350
Faster Mobile Websites
Avatar for Dean Hume deanohume
310
32k
Introduction to Domain-Driven Design and Collaborative software design
Avatar for Kenny Baas-Schwegler baasie
1
1.1k
Claude Code どこまでも/ Claude Code Everywhere
Avatar for nwiizo nwiizo
68
60k
Self-Hosted WebAssembly Runtime for Runtime-Neutral Checkpoint/Restore in Edge–Cloud Continuum
Avatar for Yuki Nakata chikuwait chikuwait
0
920
The Art of Delivering Value - GDevCon NA Keynote
Avatar for David Neal reverentgeek
16
2.2k
Effective software design: The role of men in debugging patriarchy in IT @ Voxxed Days AMS
Avatar for Kenny Baas-Schwegler baasie
1
600
My Coaching Mixtape
Avatar for mlcsv mlcsv
0
380
Building Experiences: Design Systems, User Experience, and Full Site Editing
Avatar for Michelle Schulp Hunt marktimemedia
1
650
The Web Performance Landscape in 2024 [PerfNow 2024]
Avatar for Tammy Everts tammyeverts
12
1.4k

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]