Optimizing SQLite - Building SaaS #210
A developer shares their process of optimizing SQLite database configuration for their SaaS application after migrating from Postgres.
A developer shares their process of optimizing SQLite database configuration for their SaaS application after migrating from Postgres.
A developer documents migrating a SaaS app to DigitalOcean using Kamal, detailing network issues and Docker setup.
Fixing the Docker image to get a Kamal deployment functional on a DigitalOcean droplet.
Introduces the 'leopards' Python library for filtering and aggregating lists, offering a lightweight alternative to pandas for basic data operations.
A developer continues migrating a SaaS app from Heroku to DigitalOcean, focusing on secrets with 1Password and creating a hosting droplet.
The author details migrating a Django app from Heroku to DigitalOcean, switching to Huey for background tasks and integrating Kamal.
Explores using Python's pattern matching and comprehensions for efficient data cleaning, transformation, and analysis.
A practical guide to reading and writing Parquet files in Python using PyArrow and FastParquet libraries.
A developer recounts an intense debugging session with the django-allauth package that turned a minor sign-up issue into a major investigation.
A tutorial on using PyArrow for data analytics in Python, covering core concepts, file I/O, and analytical operations.
Analyzes the viability of using uv's managed Python in production, covering portability, performance, and security implications.
A comprehensive guide to building interactive data applications using the Streamlit framework, covering setup, visualization, ML integration, and deployment.
The author begins migrating a SaaS application from Heroku to Digital Ocean, focusing on creating a Dockerfile and new deployment tools.
A developer explores using Kamal, a deployment tool, to deploy a web app to a Digital Ocean Droplet virtual machine.
A beginner-friendly guide explaining Python's built-in functions with simple definitions and examples for easy learning.
A developer shares their experience using ChatGPT as a coding assistant to boost productivity, generate tailored code, and troubleshoot.
Learn how to extract text and data from PDFs using Python tools like pypdf, OCR, and table extraction techniques.
A guide for R users to learn basics of Python, HTML, CSS, JS, and C++ to enhance their data science and web development projects.
Building a Django job to send activation email reminders before user accounts expire, plus discussion on dependency management.
Python 3.12 deprecates datetime.utcnow(). This article explains why and how to migrate to timezone-aware datetime.now(timezone.utc).