Essential SQLAlchemy, 2nd Edition
Mapping Python to Databases
Publisher: O'Reilly Media
Final Release Date: November 2015
Pages: 208

Dive into SQLAlchemy, the popular, open-source code library that helps Python programmers work with relational databases such as Oracle, MySQL, PostgresSQL, and SQLite. Using real-world examples, this practical guide shows you how to build a simple database application with SQLAlchemy, and how to connect to multiple databases simultaneously with the same metadata.

SQL is a powerful language for querying and manipulating data, but it’s tough to integrate it with your application. SQLAlchemy helps you map Python objects to database tables without substantially changing your existing Python code. If you’re an intermediate Python developer with knowledge of basic SQL syntax and relational theory, this book serves as both a learning tool and a handy reference.

Essential SQLAlchemy includes several sections:

  • SQLAlchemy Core: Provide database services to your applications in a Pythonic way with the SQL Expression Language
  • SQLAlchemy ORM: Use the object relational mapper to bind database schema and operations to data objects in your application
  • Alembic: Use this lightweight database migration tool to handle changes to the database as your application evolves
  • Cookbook: Learn how to use SQLAlchemy with web frameworks like Flask and libraries like SQLAcodegen
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyEssential SQLAlchemy, 2nd Edition
 
3.6

(based on 7 reviews)

Ratings Distribution

  • 5 Stars

     

    (2)

  • 4 Stars

     

    (3)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (1)

  • 1 Stars

     

    (1)

71%

of respondents would recommend this to a friend.

Pros

  • Easy to understand (5)
  • Helpful examples (5)
  • Accurate (4)
  • Well-written (4)

Cons

  • Not comprehensive enough (3)

Best Uses

  • Intermediate (4)
  • Novice (4)
    • Reviewer Profile:
    • Developer (6)

Reviewed by 7 customers

Displaying reviews 1-7

Back to top

 
2.0

Code examples do not work

By ukwiz

from UK

Verified Reviewer

Pros

    Cons

    • Too many errors

    Best Uses

      Comments about oreilly Essential SQLAlchemy, 2nd Edition:

      The code examples for the app in Chapter 4 do not work. Table creation fails when trying to create constraints

       
      4.0

      good starting resource

      By James

      from Kamloops, BC

      About Me Developer

      Verified Buyer

      Pros

      • Easy to understand
      • Helpful examples
      • Well-written

      Cons

        Best Uses

        • Intermediate

        Comments about oreilly Essential SQLAlchemy, 2nd Edition:

        I read this book cover to cover and found it an enjoyable read. The author provides tips throughout that I found valuable.

        Though it covers the essentials of SQLAlchemy, by the time that I reached the end I found myself craving a book that went into more detail and covered more features of the library. That's not a criticism of this book though, just a desire to see more advanced resources.

        (1 of 1 customers found this review helpful)

         
        4.0

        nice introduction to SQLAlchemy

        By Tom

        from Nacka, Sweden

        About Me Developer

        Verified Reviewer

        Pros

        • Accurate
        • Easy to understand
        • Helpful examples
        • Well-written

        Cons

        • Not comprehensive enough

        Best Uses

        • Intermediate
        • Novice

        Comments about oreilly Essential SQLAlchemy, 2nd Edition:

        I enjoyed reading this book. It is a nice and helpful introduction to SQLAlchemy Core and ORM as well as to Alembic.

        The reader should be reasonably fluent in Python and SQL, otherwise this book is likely to be hard to follow. However, for readers fluent in SQL the book is sometimes explaining database basics in a way that is superfluous.

        The book has 3 main parts: SQLAlchemy Core, SQLAlchemy ORM and Alembic for SQLAlchemy ORM. The core and ORM parts are written so that you can read them in isolation. This is good when coming back to the book for checking up how to do something. However, when reading the book from cover to cover the repeated text is not that nice.

        The book explains the basics of how to use SQLAlchemy using good examples. After the explanation of the basics, there are links to where to find more information. This means that the book does not really have the depth that I envisioned from the title. However, the fact that it links to detailed information instead of including the details may help the book to be more "future proof", as the details are likely to change with new releases.

        (1 of 3 customers found this review helpful)

         
        1.0

        Not that impressive..

        By Mister President

        from San Jose, CA

        About Me Developer

        Verified Reviewer

        Pros

          Cons

          • Not comprehensive enough
          • Too many errors

          Best Uses

            Comments about oreilly Essential SQLAlchemy, 2nd Edition:

            This book is a good quick summary of SQLAlchemy, I have expected better and more detailed discussion of its topics.

            The author surely an expert programmer, but probably not best in writing books.. I had to eventually go online to understand the inner workings of SQLAlchemy after being confused by the various typos and vague examples..

             
            5.0

            Great book for jumpstarting your SQLAlchemy and alembic use

            By Chris the Consultant

            from Minneapolis, MN

            About Me Developer

            Verified Reviewer

            Pros

            • Accurate
            • Concise
            • Conversational
            • Easy to understand
            • Helpful examples
            • Well-written

            Cons

              Best Uses

              • Expert
              • Intermediate
              • Novice

              Comments about oreilly Essential SQLAlchemy, 2nd Edition:

              I needed to come up to speed on SQLAlchemy and alembic quickly for an App Engine app that I was building for a client. This book really helped set the stage for a quick implementation of database migrations (via alembic) and the ORM layer for the App Engine application. The documentation for SQLAlchemy rocks, but having the book there to guide you through examples was really nice to have.

              (3 of 3 customers found this review helpful)

               
              4.0

              A reasonably paced introduction to SQLAlchemy

              By Nicola Musatti

              from Milano, Italy

              About Me Developer

              Verified Buyer

              Pros

              • Accurate
              • Easy to understand
              • Helpful examples

              Cons

              • Not comprehensive enough
              • Too basic

              Best Uses

              • Novice
              • Student

              Comments about oreilly Essential SQLAlchemy, 2nd Edition:

              "Essential SQLAlchemy, 2nd Edition" is a good introduction to the SQLAlchemy ORM framework for those who prefer step-by-step guides. It is written in a clear style and follows a hands-on approach.

              Personally I would have preferred a little more terseness and a deeper coverage of topics. As it is I find the "Essential" adjective somewhat misleading, maybe "Learning SQLAlchemy" would have been a better name.

              (4 of 4 customers found this review helpful)

               
              5.0

              Great overview and reference book.

              By Brian D.

              from Nashville, TN

              About Me Developer

              Verified Reviewer

              Pros

              • Accurate
              • Concise
              • Easy to understand
              • Helpful examples
              • Well-written

              Cons

                Best Uses

                • Intermediate
                • Novice

                Comments about oreilly Essential SQLAlchemy, 2nd Edition:

                Disclaimer: The author is a friend of mine and a former colleague.

                I use SQLAlchemy on a nearly daily basis but I still was able to pick up quite a few new tidbits of knowledge from this book. I also stick mostly to the core parts of SQLAlchemy, so this book helped me understand how the ORM side of things works.

                This book is both good for beginners and good for experienced users who need a reference for parts of the system they may not be using.

                Displaying reviews 1-7

                Back to top

                 
                Buy 2 Get 1 Free Free Shipping Guarantee
                Buying Options
                Immediate Access - Go Digital what's this?
                Ebook:  $33.99
                Formats:  DAISY, ePub, Mobi, PDF
                Print & Ebook:  $43.99
                Print:  $39.99