The definitive guide to using Django with SQLite in production 💡

This page summarizes the projects mentioned and recommended in the original post on dev.to

CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  1. litestream

    Streaming replication for SQLite.

    ... # Install wget and Litestream RUN --mount=type=cache,target=/var/cache/apt,sharing=locked --mount=type=cache,target=/var/lib/apt,sharing=locked \ apt-get update --fix-missing && \ apt-get install --no-install-recommends -y wget && \ wget https://github.com/benbjohnson/litestream/releases/download/v0.3.13/litestream-v0.3.13-linux-amd64.deb && \ dpkg -i litestream-v0.3.13-linux-amd64.deb ENTRYPOINT ["./entrypoint.sh"]

  2. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  3. litestack

    There has been a lot of conversation about using SQLite as a production database for websites for the past few years, espeically in the Rails community with Litestack. And now, in the latest version of Rails, SQLite has become the defacto backend for many parts of the stack.

  4. sqlite

    sqlite mirror (by smparkes)

    I currently have a managed PostgreSQL database at Digital Ocean which has worked well, but I have been looking into using SQLite in production to reduce server costs and network latency. And, since I'm not particularly DevOps-y, I do not want to be on the hook for maintaining my own PostgreSQL database. So, I have been investigating other solutions for my newest side project, filmcliq.com.

  5. django_libsql

    Turso libSQL: A fork of SQLite that supports distributed databases (django-libsql)

  6. libsql

    libSQL is a fork of SQLite that is both Open Source, and Open Contributions.

    Turso libSQL: A fork of SQLite that supports distributed databases (django-libsql)

  7. marmot

    A distributed SQLite replicator built on top of NATS

    marmot: A distributed SQLite replicator built on top of NATS

  8. rqlite

    The lightweight, user-friendly, distributed relational database built on SQLite.

    rqlite: The lightweight, user-friendly, distributed relational database built on SQLite

  9. SaaSHub

    SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

    SaaSHub logo
  10. django-q2

    A multiprocessing distributed task queue for Django. Django Q2 is a fork of Django Q. Big thanks to Ilan Steemers for starting this project. Unfortunately, development has stalled since June 2021. Django Q2 is the new updated version of Django Q, with dependencies updates, docs updates and several bug fixes. Original repository: https://github.com/Koed00/django-q

    django-q2

  11. django-db-queue

    Simple database-backed job queue

    django-db-queue

  12. huey

    a little task queue for python

    huey

  13. blaze-starter

    Blaze.horse — Django Starter Kit

    blaze-starter start.sh

  14. coolify

    An open-source & self-hostable Heroku / Netlify / Vercel alternative.

    I have been running Django sites in production under heavy load for over 10 years at my day job. We started with a MySQL database backend but, after running into a few issues, switched to PostgreSQL which has been rock-solid. I tend to use the same stack for side projects. Especially because, initially, most of my projects were hosted on Heroku and they had stellar support for PostgreSQL. Now, having bounced from Heroku to Render to Fly.io to Digital Ocean (with CapRover) to Hetzner (with Coolify), I am re-evaluating my default choice of database.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Why you should probably be using SQLite

    8 projects | news.ycombinator.com | 27 Oct 2023
  • Limbo: A complete rewrite of SQLite in Rust

    6 projects | news.ycombinator.com | 10 Dec 2024
  • Dbmate: A lightweight, framework-agnostic database migration tool

    2 projects | news.ycombinator.com | 16 Jun 2024
  • Why SQLite Is Taking over with Brian Holt and Marco Bambini

    5 projects | news.ycombinator.com | 12 Jun 2024
  • SQLite-Web: Web-based SQLite database browser written in Python

    7 projects | news.ycombinator.com | 7 Feb 2024