Posts tagged with “Sql”
Upgrading Mastodon from PostgreSQL 15 to PostgreSQL 17
Upgrading Mastodon’s database from PostgreSQL 15 to 17 on Ubuntu 24.04 is fast and easy using `pg_upgradecluster` with link mode. Here’s a quick guide with steps, tips, and cleanup.
Using Visual MySQL Explain with Laravel
Using mysqlexplain.com's new Visual Explain mode to analyse and improve query performance in Laravel
Using MySQL Views with Laravel
Using MySQL views with Laravel allows you to encapsulate a lot of logic in a model class, which simplifies code, and can improve performance over eager-loading lots of relationships.
Clearing up the Mastodon Database using pg_repack
Running pg_repack regularly on your Mastodon instance can stop the database from growing too large.
Tweaking Postgres for Mastodon
I had to increase Postgres' max_connections settings to resolve issues with my Mastodon instance.
How I Deal with Money in PHP
Dealing with money and multi-currencies in Laravel and SQL the easy way.