Essential SQLAlchemy, 2/e (Paperback)

Jason Myers, Rick Copeland

買這商品的人也買了...

商品描述

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

商品描述(中文翻譯)

深入研究SQLAlchemy,這是一個受歡迎的開源程式庫,可幫助Python程式設計師與關聯式資料庫(如Oracle、MySQL、PostgresSQL和SQLite)進行互動。這本實用指南使用真實世界的例子,向您展示如何使用SQLAlchemy建立一個簡單的資料庫應用程式,以及如何使用相同的元數據同時連接到多個資料庫。

SQL是一種強大的用於查詢和操作資料的語言,但將其與應用程式整合起來並不容易。SQLAlchemy可以幫助您將Python物件映射到資料庫表格,而不需要大幅修改現有的Python程式碼。如果您是一位具有基本SQL語法和關聯理論知識的中級Python開發人員,這本書既是一個學習工具,也是一個方便的參考資料。

《Essential SQLAlchemy》包含以下幾個部分:
- SQLAlchemy Core:以Pythonic方式使用SQL表達式語言為應用程式提供資料庫服務
- SQLAlchemy ORM:使用物件關聯映射器將資料庫架構和操作綁定到應用程式中的資料物件
- Alembic:使用這個輕量級的資料庫遷移工具來處理應用程式演進中的資料庫變更
- Cookbook:學習如何在像Flask這樣的網頁框架和SQLAcodegen這樣的程式庫中使用SQLAlchemy