Self-hosted Analytics with Next.js and PostgreSQL
How I built a privacy-first analytics system for mxd.codes using Next.js API routes, PostgreSQL and MaxMind GeoLite2 -without any third-party tracking service.
Hi, my name is
Max Dietrich.
Geospatial technologies and cycling are my thing. I'm from Wasserburg am Inn, Germany.
On this website I am sharing my learnings about web-development and creating web-maps.
- I'm also a proud member of the IndieWeb community.
- I've been tracking my location since 2021. Read more.
Recent Posts
Colota v1.1.0: Native Maps, Tracking Profiles, and Pause Zones
After releasing Colota 1.0 as an open-source Android GPS tracker, I spent the last months rebuilding the map engine, adding automatic tracking profiles, geofence-based pause zones, and a bunch of smaller improvements.
Effortless Wildcard SSL: Secure Your Domain with Let's Encrypt, Nginx, Docker and Cloudflare DNS
Learn how to generate and automate Let's Encrypt wildcard SSL certificates for Nginx using Docker and Cloudflare DNS API. Secure all your subdomains with easy setup, automatic renewal, and zero-downtime Nginx reloads.
How to Integrate Plausible Analytics in a Next.js App (Without Getting Blocked)
Learn how to integrate Plausible Analytics into a Next.js App Router project with route tracking and ad blocker-resistant proxying. A complete guide for privacy-focused, cookie-free analytics.
How to Create a Backup Script for PostgreSQL and MariaDB Containers on a Server
Learn how to automate backups for PostgreSQL and MariaDB running in Docker containers on a server. Protect your data with this simple, customizable backup script, ensuring regular backups with minimal effort.
Enhancing Social Interactions: Implementing Webmentions with Next.js and PostgreSQL
Learn how to integrate Webmentions into your Next.js site using PostgreSQL. Enhance engagement, foster social interactions, and build a dynamic web community with this step-by-step guide.