Let's talk Databases in Python: SQLAlchemy and Alembic

Speaker

Hannah Stepanek

Material

• video
• slide

Note

• Building models
• Types of indexing
  • Multiple Column Index
  • Partial Index
  • Functional/Expression Indexing
    • e.g., SELECT * FROM Annotation WHERE reference[0] = ann
• Connecting to the database
  • Session Scoping
• Connection pools
• Keep alives
• Building queries
• Database Migrations

Share on: Twitter ❄ Facebook ❄ Email

---