Oreilly New Ebook: Essential SQLAlchemy
Essential SQLAlchemy introduces a high-level open-source cipher library that makes it easier for Python programmers to admission relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLite. SQLAlchemy has become added accepted back its release, but it still lacks acceptable offline documentation. This applied book fills the gap, and because a developer wrote it, you get an cold attending at SQLAlchemy’s accoutrement rather than an advocate’s description of all the “cool” features.
SQLAlchemy includes both a database server-independent SQL announcement accent and an object-relational mapper (ORM) that lets you map “plain old Python objects” (POPOs) to database tables after essentially alteration your absolute Python code. Essential SQLAlchemy demonstrates how to use the library to actualize a simple database application, walks you through simple queries, and explains how to use SQLAlchemy to affix to assorted databases accompanying with the aforementioned Metadata. You aswell apprentice how to:
* Actualize custom types to be acclimated in your schema, and if it’s advantageous to use custom rather than congenital types
* Run queries, updates, and deletes with SQLAlchemy’s SQL announcement language
* Build an article mapper with SQLAlchemy, and accept the differences amid this and alive almanac patterns acclimated in added ORMs
* Actualize objects, save them to a session, and even them to the database
* Use SQLAlchemy to archetypal article aggressive inheritance
* Accommodate a declarative, alive almanac arrangement for use with SQLAlchemy application the Elixir extension
* Use the SQLSoup addendum to accommodate an automated metadata and article archetypal based on database reflection
In addition, you’ll apprentice how and if to use added extensions to SQLAlchemy, including AssociationProxy, OrderingList, and more.
Essential SQLAlchemy is the much-needed adviser for every Python developer application this cipher library. Instead of a feature-by-feature documentation, this book takes an “essentials” access that gives you absolutely what you charge to become advantageous with SQLAlchemy appropriate away.
