SQLAlchemy as the Backbone of a Data Science Company

Discover how SQLAlchemy serves as the backbone of a data science company in this EuroPython Conference talk. Explore the scalability of relational data models in the era of NoSQL databases and Map Reduce algorithms. Learn how Blue Yonder utilizes SQLAlchemy throughout their data science workflows to manage billions of records for predictive algorithms. Delve into SQLAlchemy's advanced features beyond ORM, focusing on the Core API, Expression Language, and database migrations with Alembic. Gain insights into database abstraction, security measures against SQL injection, query composability and reuse, testability techniques, and database reflection. Understand the implementation of a custom SQLAlchemy dialect for the EXASolution database system. Cover topics including data flow in data science, database schema definition, data manipulation and query languages, query builders, testing strategies, and database migrations.