Urgent.News

What's breaking now, across thousands of outlets.

Tech

Self-Hosting Supabase on VPS with Coolify v4

๐Ÿ’ก Originally published on Bijak Technology Enterprise Journal with full interactive parameter benchmarks. Commercial Supabase Cloud Pro bills spike aggressively the moment your application crosses the 100,000 Monthly Active Users (MAU) threshold, while surges in Auth and Realtime function calls drain your egress bandwidth allowance. For engineering teams managing tight operational budgets,โ€ฆ

In a detailed production runbook, the article outlines the process of migrating a full Supabase stack to a self-hosted infrastructure using Coolify v4 and Traefik v3 on a Hostinger KVM VPS. This migration can cut operating costs by up to 85% without compromising PostgreSQL database performance. The article also provides a comparison of costs between Supabase Cloud Pro and self-hosted VPS, highlighting the significant savings potential of the latter.

To set up the system, the article instructs to create a working directory on the server and prepare a docker-compose.yml file to deploy Supabase components modularly. The configuration includes services for PostgreSQL, Kong, GoTrue, PostgREST, Realtime, and Storage API. The Traefik v3 routing system is used to secure communication between containerized services and handle automated SSL termination and wildcard subdomain routing.

Prerequisites for the Hostinger KVM VPS include Ubuntu 22.04 LTS, minimum 8 GB RAM, NVMe SSD storage, and specific kernel tuning adjustments in /etc/sysctl.conf. The article also outlines troubleshooting steps for potential issues such as Realtime WebSocket connections dropping and disk IOPS slowing down during backups.

This independent architecture offers total sovereignty over data, reduced latency due to geographical server proximity, and significant long-term budget efficiency.

Written by urgent.news from Dev.to's reporting โ€” not their text. Machine-written โ€” may contain errors; check the original before relying on it.

Read the original at dev.to โ†’

More in Tech

The Design Logic Behind Eight Skills

In the previous post I said that the defenses we bought with real incidents eventually turned into eight concrete SKILLs. This post explains how to use those eight.

๐ŸŒณ Pine Script into readable Python for Free

Download the converted 449 strategies and 471 indicators via this link I built a free compiler and translated over 1000 popular trading strategies and indicators from TradingView into Python sourceโ€ฆ

  • Free compiler translates 1,000+ TradingView strategies to Python
  • 384 strategies and 458 indicators achieve bit-for-bit consistency
  • Supports multiple exchanges via CCXT library for candlestick charting

More from Wednesday 18 November โ†’