Skip to content

Details

This month, Michael Brown will discuss Simplified Data Access with SQLAlchemy.

SQLAlchemy is a robust Object/Relational Mapper (O/RM) that allows you as a developer to focus on building a functioning application without allowing the details of storage to leak into your application. It supports a highly advanced framework for mapping your business objects to your database and a powerful query language that practically allows you to perform most queries that a native query language would allow. For those creating applications that need to integrate with multiple databases depending on the client environment, SQLAlchemy provides that abstraction for you.

This talk will demonstrate the basics of SQLAlchemy, showing how to use it to:

  • map to an existing database
  • generate a new database from code
  • use migration tools to automatically change the DB to keep in sync with code
  • create basic and advanced queries for displaying data
  • design advanced domain object graphs and leverage the capabilities of SQLAlchemy to manage the mapping between your domain and storage.

Resources:
http://SQLAlchemy.org (http://sqlalchemy.org/)­ (Official SQLAlchemy site)
Essential SQLAlchemy by Oreilly.

Our meetup is located at the Black Labrador Pub, near Richmond and Montrose. Please enjoy their menu and drink offerings, so they continue to enjoy hosting us! Lastly, please RSVP (even if you're a "Maybe"!) to assist us with capacity planning.

Share your Lightning Talks! A "lightning talk" is a quick mini-presentation (5 minutes maximum) on any Python topic you'd like. We'll save time for 2-3 of these each month: to save a spot, post a comment with your talk's title/topic. Beginner topics are always welcome!

Presentations Wanted: If you'd like to share a topic with the group at an upcoming, let's talk!

Related topics

Sponsors

Improving

Improving

Trust changes everything

PyTexas

PyTexas

Supporting the Python community in Texas

You may also like