Migrating Shopify’s Core Rails Monolith to Trilogy
38 min

Migrating Shopify’s Core Rails Monolith to Trilogy

RailsConf - RailsConf 2023
Adrianna Chang
ruby ruby-on-rails trilogy active-record database mysql sql performance c-extensions open-source
Postgres Performance: From Slow to Pro
44 min

Postgres Performance: From Slow to Pro

DjangoCon - DjangoCon US 2023
Elizabeth Christensen
django python database-performance postgresql-tuning query-optimization postgresql-configuration table-bloat connection-pooling postgresql sql caching indexing
How to Ride Elephants Safely: Working with PostgreSQL when your DBA is not around
50 min

How to Ride Elephants Safely: Working with PostgreSQL when your DBA is not around

DjangoCon - DjangoCon US 2023
Richard Yen
django python database-administration dba recovery postgresql sql linux command-line performance-tuning monitoring
Strategies for handling conflicts and rollbacks in Django database migrations
13 min

Strategies for handling conflicts and rollbacks in Django database migrations

DjangoCon - DjangoCon US 2023
Abigail Afi Gbadago
django python rollback data-integrity schema-management database migrations orm conflict-resolution version-control sql
Django migrations, friend or foe? Optimize your Django migrations for faster testing
25 min

Django migrations, friend or foe? Optimize your Django migrations for faster testing

DjangoCon - DjangoCon US 2023
Denny Biasiolli
django python migrations test-database database testing performance cicd sql orm development-workflows
Using database triggers to reliably track model history
38 min

Using database triggers to reliably track model history

DjangoCon - DjangoCon US 2023
Wes Kendall Maxwell Muoto
django python database-triggers model-history audit-log django-pghistory postgresql data-modeling orm web-development database-architecture sql
Building an AI-powered SQL playground using Next.js, OpenAI, and Neon
10 min

Building an AI-powered SQL playground using Next.js, OpenAI, and Neon

Next.js Conf - Next.js Conf 2023
Mahmoud Abdelwahab
javascript nextjs neon edge-functions vercraft-ai-sdk next-js react openai ai sql postgres database serverless
Replacing SQL with Kotlin's 'dataframe' on the Las Vegas Strip
40 min

Replacing SQL with Kotlin's 'dataframe' on the Las Vegas Strip

KotlinConf - KotlinConf 2023
Andrew Goldberg
kotlin dataframe sql data-transformation data-analysis api csv jupyter-notebooks etl android kotlinx-serialization
Direct2DB: Radically Simplified App Architecture with Kotlin
50 min

Direct2DB: Radically Simplified App Architecture with Kotlin

KotlinConf - KotlinConf 2023
Mike Hearn
kotlin jetpack-compose-multiplatform jdbc two-tier-architecture conveyor jetpack-compose database app-architecture rpc deployment postgresql sql
Consistency and Isolation for Python Programmers
25 min

Consistency and Isolation for Python Programmers

PyCon - PyCon US 2023
A. Jesse Jiryu Davis
python database consistency isolation sql mongodb transactions distributed-systems replication concurrency anomalies linearizability
Data analysis with SQLite and Python
2h 46m

Data analysis with SQLite and Python

PyCon - PyCon US 2023
Simon Willison
sqlite python data-analysis sql sqlite-utils datasette database json csv api command-line-interface web-application
Build a Cloud in Thirteen Years
30 min

Build a Cloud in Thirteen Years

RubyConf - RubyConf 2024
Daniel Farina
ruby cloud-computing infrastructure heroku ubicloud orm sql roda authentication testing performance devops