DjangoCon Europe 2023 | Use SQLite in production

Use SQLite in production by Tom Dyson

Why the world's most popular database is a good option for your app in production, despite the advice of the official Django documentation.

SQLite is a popular option for the local development of Django applications. It's built-in to Python, and it's well supported by the Django. However, the standard advice, both from the official documentation and from the community in general, is that it's not the right tool for running your app in production.

In this talk I'll argue that it's time to change this position. In many cases, SQLite is the fastest database option available to Django developers. It's always the cheapest and the most energy efficient. The traditional concerns about concurrent writes can be handled through new configuration options, and the limits on horizontal scalability can be addressed through innovative approaches developed and funded by companies like Fly.io and Cloudflare.

I'll use real-world examples to compare SQLite's performance against the traditional database options for production. I'll also explore some of the exciting new developments in the SQLite ecosystem, particularly those which enable its use in machine learning in general, and LLMs (large language models) in particular.

Date Added: September 19, 2024