Padding Tutorials
What do you want to build?
Filter
6 tutorials
All tutorials
How to Find and Fix Slow PostgreSQL Queries with EXPLAIN ANALYZE
You will read a PostgreSQL 18 query plan, add an index that turns a 40 ms table scan into a 0.2 ms lookup, and use pg_stat_statements to find which queries deserve that effort.
Advanced · 16 min · Databases
How to Install Valkey 9.1 (a Redis-Compatible Cache) on Ubuntu 26.04
You will install Valkey 9.1 from the project's official binary release, run it as its own user with a password and a memory limit, and use it as a cache from the command line.
Beginner · 12 min · Databases
How to Install PostgreSQL 18 on Ubuntu 26.04 and Create Your First Database
You will install PostgreSQL 18 from the official PostgreSQL apt repository, create a database and a user for your app, and connect to it with a password.
Beginner · 11 min · Databases
How to Install MySQL 9.7 LTS on Ubuntu 26.04
You will install MySQL 9.7 LTS from Oracle's official apt repository, close it to the network, create a database and a limited user for your app, and connect with a password.
Beginner · 12 min · Databases
How to Install MongoDB 9.0 and Create a Database and User
You will install MongoDB 9.0 Community from the official MongoDB apt repository on Ubuntu 26.04, turn on authentication, and create an admin user and a limited user for one app database.
Beginner · 13 min · Databases
How to Back Up and Restore a PostgreSQL Database with pg_dump
You will back up a PostgreSQL 18 database in three formats, restore it into a fresh database, check the copy matches, and schedule a nightly backup that deletes old files.
Intermediate · 14 min · Databases