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

Introduction to SQLAlchemy ORMs

Introduction to SQLAlchemy ORMs

A talk at the November ChennaiPy meetup about getting started with SQLAlchemy ORMs

Shrayas Rajagopal

November 29, 2014
Tweet

More Decks by Shrayas Rajagopal

Other Decks in Technology

Transcript

  1. CHENNAIPY
    NOV 2014

    View full-size slide

  2. shrayasr
    Twitter / Github / Gmail

    View full-size slide

  3. shrayasr
    Logic Soft

    View full-size slide

  4. shrayasr
    Logic Soft (1986)

    View full-size slide

  5. SQL
    Alchemy
    An Introduction to ORMs

    View full-size slide

  6. What are ORMs ?
    What is SQLAlchemy ?
    Getting started with SQLAlchemy ORMs

    View full-size slide

  7. ORMs ?
    What are

    View full-size slide

  8. Express DB Entities
    as Language Constructs

    View full-size slide

  9. Objects > Schema

    View full-size slide

  10. Easier to READ

    View full-size slide

  11. Easier to WRITE

    View full-size slide

  12. Easier to WRITE
    Lesser

    View full-size slide

  13. DISADVANTAGES

    View full-size slide

  14. Too Abstracted

    View full-size slide

  15. SQL
    Alchemy ?
    What is

    View full-size slide

  16. Not JUST an ORM

    View full-size slide

  17. Database Toolkit

    View full-size slide

  18. Façade on dbapi

    View full-size slide

  19. Transactions!

    View full-size slide

  20. Make adapters
    consistent

    View full-size slide

  21. Very Pythonic

    View full-size slide

  22. SQL
    Alchemy
    ORMs

    View full-size slide

  23. ? iPython Notebook URL:
    http://goo.gl/JO2GVY

    View full-size slide