Nonficionado Sale
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores


    Recently Viewed clear list


    Q&A | May 20, 2015

    Michael Perry: IMG Powell's Q&A: Michael Perry



    Describe your latest book. On Christmas Eve itself, the bachelor Harley Jackson stepped into his barn and beheld there illuminated in the straw a... Continue »
    1. $18.19 Sale Hardcover add to wish list

      The Jesus Cow

      Michael Perry 9780062289919

    spacer
Qualifying orders ship free.
$14.95
List price: $34.99
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton COMP- DATA SQL

More copies of this ISBN

Essential SQLAlchemy

by

Essential SQLAlchemy Cover

 

Synopses & Reviews

Publisher Comments:

Essential SQLAlchemy introduces a high-level open-source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLite. SQLAlchemy has become increasingly popular since its release, but it still lacks good offline documentation. This practical book fills the gap, and because a developer wrote it, you get an objective look at SQLAlchemy's tools rather than an advocate's description of all the "cool" features.

SQLAlchemy includes both a database server-independent SQL expression language and an object-relational mapper (ORM) that lets you map "plain old Python objects" (POPOs) to database tables without substantially changing your existing Python code. Essential SQLAlchemy demonstrates how to use the library to create a simple database application, walks you through simple queries, and explains how to use SQLAlchemy to connect to multiple databases simultaneously with the same Metadata. You also learn how to:

  • Create custom types to be used in your schema, and when it's useful to use custom rather than built-in types
  • Run queries, updates, and deletes with SQLAlchemy's SQL expression language
  • Build an object mapper with SQLAlchemy, and understand the differences between this and active record patterns used in other ORMs
  • Create objects, save them to a session, and flush them to the database
  • Use SQLAlchemy to model object oriented inheritance
  • Provide a declarative, active record pattern for use with SQLAlchemy using the Elixir extension
  • Use the SQLSoup extension to provide an automatic metadata and object model based on database reflection

In addition, you'll learn how and when to use other extensions to SQLAlchemy, including AssociationProxy, OrderingList, and more.

Essential SQLAlchemy is the much-needed guide for every Python developer using this code library. Instead of a feature-by-feature documentation, this book takes an "essentials" approach that gives you exactly what you need to become productive with SQLAlchemy right away.

Book News Annotation:

For Python programmers, this guide describes how the SQLAlchemy open source code library can map objects to database tables without substantially changing the Python code. The library bridges the gap between relational databases and traditional object-oriented programming. The book covers the 0.4 release series and installation, engines, running queries and updates, building an object mapper, querying and updating, and extensions. Intermediate to advanced Python skills are assumed, as is moderate exposure to SQL databases. Copeland is a software engineer with a retail analytics firm. Annotation ©2008 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

"Essential SQLAlchemy" introduces a high-level open source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLLite.

About the Author

Rick Copeland is a Florida Department of Environmental Protection hydrogeologist at the Florida Geological Survey and president of the Southeastern Geological Society.

Table of Contents

PrefaceChapter 1: Introduction to SQLAlchemyChapter 2: Getting StartedChapter 3: Engines and MetaDataChapter 4: SQLAlchemy Type EnginesChapter 5: Running Queries and UpdatesChapter 6: Building an Object MapperChapter 7: Querying and Updating at the ORM LevelChapter 8: Inheritance MappingChapter 9: Elixir: A Declarative Extension to SQLAlchemyChapter 10: SqlSoup: An Automatic Mapper for SQLAlchemyChapter 11: Other SQLAlchemy ExtensionsColophon

Product Details

ISBN:
9780596516147
Author:
Copeland, Rick
Publisher:
O'Reilly Media
Subject:
Database Management - General
Subject:
Python (Computer program language)
Subject:
Sql (computer program language)
Subject:
Database design
Subject:
Pylons;Python;SQLAlchemy;SQLObject;TurboGears
Subject:
CourseSmart Subject Description
Copyright:
Edition Description:
Print PDF
Publication Date:
20080631
Binding:
TRADE PAPER
Language:
English
Pages:
240
Dimensions:
9.24x7.08x.57 in. .86 lbs.

Other books you might like

  1. Twisted Network Programming Essentials Used Trade Paper $17.95
  2. Beautiful Code: Leading Programmers... Used Trade Paper $31.00
  3. jQuery in Action Used Trade Paper $27.50
  4. The CSS Anthology: 101 Essential... Used Trade Paper $10.50
  5. On Intelligence Used Trade Paper $7.50
  6. Hot Commodities: How Anyone Can... Used Hardcover $6.50

Related Subjects

Computers and Internet » Computer Languages » Python
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » General
Computers and Internet » Software Engineering » Software Management
Health and Self-Help » Health and Medicine » General
Health and Self-Help » Health and Medicine » General Medicine
Metaphysics » Healing

Essential SQLAlchemy Used Trade Paper
0 stars - 0 reviews
$14.95 In Stock
Product details 240 pages O'Reilly Media - English 9780596516147 Reviews:
"Synopsis" by ,
"Essential SQLAlchemy" introduces a high-level open source code library that makes it easier for Python programmers to access relational databases such as Oracle, DB2, MySQL, PostgreSQL, and SQLLite.
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.