Главная
Study mode:
on
1
Intro
2
Data Flow in a Data Science Company
3
Defining your Database Schema
4
Data Manipulation Language
5
Data Query Language
6
Using a Query Builder
7
Simple Query Builder Implementation
8
Composability and Reuse
9
Merge Statement SQLAlchemy
10
Testability
11
Testing against SQLite
12
Transaction/Rollback in your tests
13
Databse Reflection & Introspection
14
Security - Little Bobby Tables we call him
15
Database Migrations with Alembic
16
SQLAlchemy Exasol
17
Apache Arrow
18
Documentation
Description:
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.

SQLAlchemy as the Backbone of a Data Science Company

EuroPython Conference
Add to list
0:00 / 0:00