MicroPyramid Blog

A practical, modern (Django 5.x) guide to aggregation in the Django ORM: when to use aggregate() vs annotate(), Count/Sum/Avg/Min/Max, grouping with v...

A practical 2026 guide to creating Excel (.xlsx) files in Python with XlsxWriter - write and format data, insert images, draw bar and column charts, e...

A current, practical guide to writing custom template tags and filters in Django 5.x — templatetags package setup, filters, simple tags, inclusion tag...

Django REST Framework offers four view styles, from function-based views (most control) to ViewSets + routers (least code). This practical guide imple...

A current, practical guide to configuring CORS for assets served from Amazon S3 and CloudFront: the modern JSON bucket CORS format, forwarding the Ori...

A practical, up-to-date guide to extracting text and structured data from PDF and Microsoft Office files in Python. Use pdfplumber and pypdf for PDFs,...

Learn how to convert HTML into PDF files in Python using pdfkit and wkhtmltopdf, with install steps for every OS, working code for from_url/from_file/...

A practical guide to Python's @property decorator: turn methods into managed attributes for computed values, validation, and read-only access without ...

Generate a QR code in Python in a few lines with the qrcode library. This guide covers the quick start, the QRCode API and error-correction levels, st...

A practical, up-to-date guide to running scheduled and recurring background tasks in Django using Celery 5.x and Celery Beat: app setup, crontab and i...

A practical guide to Django REST Framework serializers: Serializer vs ModelSerializer, serialization and deserialization, validation, nested and relat...

Salesforce Data Loader imports, updates, upserts, and exports up to 5 million records through the API. Learn when to use it over the Data Import Wizar...