Blog

News, tutorials and release notes for Canvasly Web Studio, Sidcraft and VidCellar.

Showing posts tagged “PostgreSQL”. Show all posts

· Canvasly Web Studio · Development

How to Set Up a Local Database, Step by Step (PostgreSQL and MariaDB with Docker)

In our Local development setup guide we said every layer of your environment should be written down, so a new machine needs one command. This tutorial does exactly that for the layer that causes the most trouble: the database. By the end you'll have a PostgreSQL database that starts in seconds, is reachable only from your own computer, comes with realistic test data, and can be backed up, restored or wiped clean with a single command. A MariaDB + WordPress version follows, for headless WordPress work.

Read the post How to Set Up a Local Database, Step by Step (PostgreSQL and MariaDB with Docker) →

· Canvasly Web Studio · Performance

Database Performance Tuning 101: How to Identify, Isolate and Fix Slow or Duplicate SQL Queries in Production

Most slow websites aren't slow because the server is too small. They're slow because a handful of database queries do far more work than they need to, or run far more often than they should. This guide walks through a simple, repeatable loop for finding those queries in production, understanding why they're slow, fixing them safely, and proving the fix worked. Examples cover MySQL / MariaDB (which WordPress uses) and PostgreSQL.

Read the post Database Performance Tuning 101: How to Identify, Isolate and Fix Slow or Duplicate SQL Queries in Production →