What do you think?
Rate this book
Essential SQLAlchemy: Mapping Python to Databases
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
206 pages, Paperback
Published January 5, 2016
47 people are currently reading
60 people want to read
About the author
Jason Myers
34 books281 followersThere is more than one author with this name
Jason Myers was born in 1980 and raised on a farm ten miles outside of the small town of Dysart, Iowa. After
he graduated high school, he moved to San Francisco where he studied
film at the Academy of Art University. It was there, after taking a
Screenwriting 3 class that he met and studied under the inspiring instructor
and author James Dalessandro. James helped Myers grasp the value of
having great stories within the story and also the value of pacing. He also
taught him how to structure his stories in a way that made the reader feel
invested. Myers then sat down in early 2003 and began working on what
would become the first draft of Exit Here. He signed with literary agent
Gary Heidt and in 2005, at the age of 24, he signed a major publishing
deal with Simon & Schuster. Exit Here would go on to be released in May
of 2007 and thus far the book has sold over 90, 000 copies worldwide.
In 2010, Myers' second book, The Mission, also on Simon & Schuster,
was released worldwide. The book went into its third printing six months
after its release and has already sold nearly 30,000 copies to date. Myers
recently signed a new two book deal with Simon & Schuster. His next book,
Dead End, a Midwestern Gothic back roads chase thriller will be released on
6.14.2011 and his fourth book is set to be released in the Summer of
2012.
Myers continues to reside in San Francisco and writes full-time.
Jason Myers was born in 1980 and raised on a farm ten miles outside of the small town of Dysart, Iowa. After
he graduated high school, he moved to San Francisco where he studied
film at the Academy of Art University. It was there, after taking a
Screenwriting 3 class that he met and studied under the inspiring instructor
and author James Dalessandro. James helped Myers grasp the value of
having great stories within the story and also the value of pacing. He also
taught him how to structure his stories in a way that made the reader feel
invested. Myers then sat down in early 2003 and began working on what
would become the first draft of Exit Here. He signed with literary agent
Gary Heidt and in 2005, at the age of 24, he signed a major publishing
deal with Simon & Schuster. Exit Here would go on to be released in May
of 2007 and thus far the book has sold over 90, 000 copies worldwide.
In 2010, Myers' second book, The Mission, also on Simon & Schuster,
was released worldwide. The book went into its third printing six months
after its release and has already sold nearly 30,000 copies to date. Myers
recently signed a new two book deal with Simon & Schuster. His next book,
Dead End, a Midwestern Gothic back roads chase thriller will be released on
6.14.2011 and his fourth book is set to be released in the Summer of
2012.
Myers continues to reside in San Francisco and writes full-time.
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 6 of 6 reviews
January 24, 2023
The book does a fairly great job of outlining the basic use of SQLAlchemy, both the Core and ORM versions, along with Alembic, an additional tool for schema changes and database migration. Note that this book was written for SQLAlchemy v1.0, and the current version is 2.0.
Overall, the book is fairly high-level, which is ok, as most SQL Operations should probably be done via SQL anyhow. This makes the chapters on reflection quite useful. My main/only complaint is that the chapters between ORM and Core are almost identical, but the author doesn't really mention this. I understand why, as it is nice to see the comparision between the two methods, but if this is the approach the author was planning to take, I wish they would have been more explicit in calling out the differences and similarities. It doesn't take away from the usefulness as a learning tool; it's mostly an annoyance while reading.
Overall, the book is fairly high-level, which is ok, as most SQL Operations should probably be done via SQL anyhow. This makes the chapters on reflection quite useful. My main/only complaint is that the chapters between ORM and Core are almost identical, but the author doesn't really mention this. I understand why, as it is nice to see the comparision between the two methods, but if this is the approach the author was planning to take, I wish they would have been more explicit in calling out the differences and similarities. It doesn't take away from the usefulness as a learning tool; it's mostly an annoyance while reading.
November 17, 2022
Jasné, srozumitelné a navíc vše vysvětlené na databázi sušenek. Pořád si nejsem úplně jistá, jestli se vyplatí věnovat se SQLAlchemy víc než nad rámec našeho kurzu - zpočátku se to tvářilo jako něco skvělého a vlastně nezbytného pro práci s SQL databází v propojení s Pythonem, ale čím víc jsem četla, tím víc otázek vyvstávalo, tím víc jsem googlila a tím víc jsem zjistila, že možností je spousta. Nicméně tento formát textbooků mi neskutečně vyhovuje a já děkuji autorům za skvělou práci! Byla radost se s vámi učit.
March 24, 2020
If you consider yourself an intermediate python developer with moderate knowledge of relational databases, then this book can be a great introduction to Python's powerful SQLAlchemy library. I personally find the official SQLAlchemy documentation immensely powerful but overly verbose. This book provides an excellent birds-eye view of the most important nuts and bolts required for you to integrate relational databases into your Python Application.
June 23, 2017
Up to the point and everything you need to know to start using SQLAlchemy
October 7, 2019
Just a simple intro for beginners, a quick overview of what SQLAlchemy is.
March 28, 2020
Great into to SQLAlchemy and potentially a useful long-term reference guide. I particularly appreciate that it doesn’t tie itself to any particular framework.
Displaying 1 - 6 of 6 reviews