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.
All the articles with the tag "databases".
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.
Master MySQL from the command line: connect, query databases, manage users, repair tables, optimize—everything you keep Googling, one reference.
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 self-hosted BaaS setup: auth, databases, storage, and serverless functions on your own hardware. Compare with Supabase and PocketBase.
NocoDB self-hosted: connect to existing Postgres/MySQL, build spreadsheet views, auto-generate APIs, and skip the Airtable subscription forever.
Decode the postgresql:// connection string — host, port, database, SSL mode, and the gotchas that cause connection refused at deploy time.
Wiki.js is a gorgeous self-hosted wiki with Markdown, WYSIWYG, and Git sync — Docker Compose setup with PostgreSQL backend.
NocoDB wraps any SQL database in a spreadsheet UI — self-host an Airtable alternative on top of MySQL, PostgreSQL, or SQLite with Docker.
Automate MySQL/MariaDB backups from a running Docker container using cron and mysqldump — no downtime, no excuses for losing your data.
Repair and optimize all MySQL databases at once with mysqlcheck — a one-liner that runs on every table without logging into MySQL.