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
280

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
100
The programmers guide to timestamps and timezones - PyCon India 2023
Avatar for Shrayas Rajagopal shrayasr
0
150
A gentle introduction to types
Avatar for Shrayas Rajagopal shrayasr
1
140
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
740
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
130

Other Decks in Technology

See All in Technology
実践アプリケーション設計 ②トランザクションスクリプトへの対応
Avatar for Recruit recruitengineers
PRO
4
440
帳票Vibe Coding
Avatar for terurou terurou
0
140
あなたの知らない OneDrive
Avatar for Murachi Akira murachiakira
0
240
JuniorからSeniorまで: DevOpsエンジニアの成長ロードマップ
Avatar for yuriemori yuriemori
0
240
開発と脆弱性と脆弱性診断についての話
Avatar for su3158 su3158
1
1.1k
攻撃と防御で実践するプロダクトセキュリティ演習～導入パート～
Avatar for Recruit recruitengineers
PRO
3
350
ZOZOTOWNフロントエンドにおけるディレクトリの分割戦略
Avatar for ZOZO Developers zozotech
PRO
18
5.5k
TypeScript入門
Avatar for Recruit recruitengineers
PRO
24
7.6k
フルカイテン株式会社 エンジニア向け採用資料
Avatar for FULL KAITEN fullkaiten
0
8.6k
MySQL HeatWave：サービス概要のご紹介
Avatar for oracle4engineer oracle4engineer
PRO
4
1.7k
株式会社ARAV 採用案内
Avatar for ARAV maqui
0
360
AIドリブンのソフトウェア開発 - うまいやり方とまずいやり方
Avatar for Riotaro OKADA okdt
PRO
9
650

Featured

See All Featured
VelocityConf: Rendering Performance Case Studies
Avatar for Addy Osmani addyosmani
332
24k
We Have a Design System, Now What?
Avatar for Morgane Peng morganepeng
53
7.7k
Writing Fast Ruby
Avatar for Erik Berlin sferik
628
62k
[RailsConf 2023] Rails as a piece of cake
Avatar for Vladimir Dementyev palkan
56
5.8k
How To Stay Up To Date on Web Technology
Avatar for Chris Coyier chriscoyier
790
250k
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
338
57k
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
33
8.8k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
Avatar for Dan Newman danielanewman
229
22k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
Avatar for Eileen M. Uchitelle eileencodes
26
3k
Statistics for Hackers
Avatar for Jake VanderPlas jakevdp
799
220k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
Avatar for soudai sone soudai
PRO
185
54k
How GitHub (no longer) Works
Avatar for Zach Holman holman
315
140k

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]