Tag: databases

PostgreSQL + Linux: Kernel Tuning That Actually Matters

An AWS engineer found Linux 7.0 halved their PostgreSQL performance. The fix was kernel tuning. Here's what settings matter and why, so you're not the last to know.

MySQL CLI: From Connection to Maintenance

Master MySQL from the command line: connect, query databases, manage users, repair tables, optimize—everything you keep Googling, one reference.

MySQL & MariaDB CLI in 2026: What Changed

MySQL 8.0 broke auth, MariaDB forked hard, and Docker changed how you connect. Here's what still works and what'll bite you.

Appwrite: Your Own Firebase, Minus the Google Surveillance Subscription

Appwrite self-hosted BaaS setup: auth, databases, storage, and serverless functions on your own hardware. Compare with Supabase and PocketBase.

NocoDB: Because Airtable Doesn't Need to Know Your Business

NocoDB self-hosted: connect to existing Postgres/MySQL, build spreadsheet views, auto-generate APIs, and skip the Airtable subscription forever.

Understanding PostgreSQL Connection URIs

Decode the postgresql:// connection string — host, port, database, SSL mode, and the gotchas that cause connection refused at deploy time.

Wiki.js for your documentation in docker

Wiki.js is a gorgeous self-hosted wiki with Markdown, WYSIWYG, and Git sync — Docker Compose setup with PostgreSQL backend.

NocoDB DB Management System

NocoDB wraps any SQL database in a spreadsheet UI — self-host an Airtable alternative on top of MySQL, PostgreSQL, or SQLite with Docker.

Automatic backup of docker Mysql or MariaDB container

Automate MySQL/MariaDB backups from a running Docker container using cron and mysqldump — no downtime, no excuses for losing your data.

Repair & Optimize all Mysql Databases one liner

Repair and optimize all MySQL databases at once with mysqlcheck — a one-liner that runs on every table without logging into MySQL.