Category
Databases
27 articles
Migrating SQL Server 2016 to PostgreSQL on a VPS
SQL Server 2016 reached end of extended support in July 2026. Technical guide to migrate to PostgreSQL on a VPS: data types, T-SQL gaps, pgloader, cutover plan.
MySQL 8.0 to 8.4 LTS migration on a VPS: step-by-step guide
MySQL 8.0 EOL April 30, 2026: no more security patches. Migrate to MySQL 8.4 LTS — breaking changes, pre-checks, in-place upgrade and when to pick MariaDB 11.x.
Migrate PostgreSQL from RDS, Cloud SQL or a managed DB to a VPS
Step-by-step PostgreSQL migration plan from RDS, Cloud SQL and Supabase to a self-hosted VPS: exact commands, source-specific pitfalls and zero-downtime cutover.
Migrating from undb to Teable on a ServOrbit VPS
Migrate from undb to Teable on a VPS: Rust-powered NoCode database, Airtable-compatible API, full Docker Compose guide and data import steps.
PostgreSQL 19 delayed: impact on self-hosted apps
PostgreSQL 19 beta 4 removes 53 features and pushes GA to late October 2026. What changes for n8n, Supabase, Nextcloud and Mattermost — and why PG 18 is the right target.
Migrating PostgreSQL 15 to 17 in a Docker stack
Complete guide to migrating PostgreSQL 15 to 17 in Docker: pg_dump/pg_restore, incompatible extensions, zero-downtime checklist — and the Supabase case.
PostgreSQL High Availability with Patroni on VPS
3-node PostgreSQL cluster with Patroni 4.1 and etcd 3.6: automatic failover under 30 seconds, synchronous replication, no managed service required.
Self-Hosted PostgreSQL vs Amazon RDS: ROI Comparison
Real cost of PostgreSQL on a VPS vs Amazon RDS in 2026: figures, configuration, troubleshooting and migration guide.
PostgreSQL end of life: plan your major upgrade
PostgreSQL supports each major version for five years, ending in November. Find out which one you run and plan the upgrade without losing data.
Valkey vs Redis in 2026: comparison and migration guide
Valkey 9.1 vs Redis 8: RESP2/RESP3, RDB/AOF format, module API, client libraries and a 4-step migration. Choose in 2026 by licence and modules.
PostgreSQL on a VPS: reliable, controlled database
Host PostgreSQL on a VPS: production config, pgBackRest backups, streaming HA, RDS/Supabase/Neon comparison and OOM troubleshooting.
Hosting MySQL on a VPS: complete guide
Install MySQL 8.4 LTS on a VPS: prerequisites, security hardening, InnoDB performance, secure remote access, automated backups, and troubleshooting.
Hosting Redis on a VPS: the complete guide
Deploy Redis on your Cloud VPS: RAM/CPU requirements, security (ACL, TLS), RDB/AOF persistence, troubleshooting, and high availability.
Hosting MongoDB on a VPS
Host MongoDB on your Cloud VPS: Docker deployment, replica set, authentication, indexing, and controlled backups.
Hosting Supabase on a VPS in 2026
Self-host Supabase on your Cloud VPS: Postgres, Auth, Storage and REST API behind Envoy. PG 15→17 migration, Kong→Envoy, GoTrue CVE.
Hosting Appwrite on a VPS: complete self-hosted guide
Deploy Appwrite on your VPS with Docker: full stack, Traefik SSL, backups, hardening, and Supabase comparison.
Hosting PocketBase on a VPS: complete guide
Deploy PocketBase on your VPS with Docker, HTTPS, OAuth, automatic backups and troubleshooting. Step-by-step guide, 2026.
Hosting Directus on a VPS
Host Directus on your VPS: an open source headless CMS and data platform on top of your SQL database. Docker, Postgres, reverse proxy, and SSL guide.
Hosting ClickHouse on a VPS
Host ClickHouse on your VPS: a columnar analytical database for your logs, metrics, and dashboards. Docker, memory tuning, and SSL guide.
Hosting Qdrant on a VPS
Host Qdrant on your VPS: Docker Compose, API key, TLS, HNSW tuning, quantization, Python v1 client, snapshots and Prometheus monitoring.
Hosting Weaviate on a VPS
Weaviate on a VPS: annotated Docker Compose, API key auth, vectorizer choice, HNSW and quantization, backups, Python client v4 and troubleshooting.
Hosting Meilisearch on a VPS
Host Meilisearch on your VPS: an instant, fault-tolerant and typo-tolerant search engine. A Docker, master key and SSL guide.
Hosting Typesense on a VPS
Deploy Typesense on your Cloud VPS: an instant, fault-tolerant search engine, in Docker with reverse proxy and SSL.
Hosting Elasticsearch on a VPS: security and troubleshooting
Install and secure Elasticsearch on a VPS: precise JVM prerequisites, Docker deployment, xpack.security, ILM, S3 snapshots and heap monitoring.
Hosting MinIO on a VPS
MinIO on a VPS: buckets, console, TLS, backups. The Community edition is archived, so here is how to decide between staying and migrating.
MariaDB on a VPS: free, fast, controlled SQL
Deploy MariaDB on a ServOrbit VPS: 1-click install, automated backups, InnoDB tuning and secure remote access.
Bytebase on VPS: SQL Migration Reviews and Team Access
Deploy Bytebase on your VPS and end risky SQL migrations: review workflow, 200+ SQL lint rules, full audit trail for PostgreSQL, MySQL, MongoDB and 20+ engines.