Ever wondered which database or tables are taking up disk space on a MySQL/MariaDB server?
This query will provide the size of each table:
SELECT TABLE_SCHEMA AS `Database`,
TABLE_NAME AS `Table`,
ROUND(((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024), 2) AS `Size (MB)`,
ROUND((data_free / 1024 / 1024), 2) AS `Reclaimable Size (MB)`
FROM information_schema.TABLES
-- WHERE `TABLE_SCHEMA` = 'database_name'
ORDER BY (DATA_LENGTH + INDEX_LENGTH) DESC;Colin DeCarlo presented a talk at Laracon Online where among other useful tips, he demonstrated how to shim MySQL functions in an SQLite database (e.g., add functions that MySQL has but SQLite does not).
Here are two examples that I just needed in a project (FLOOR and DATEDIFF):
use Illuminate\Support\Facades\DB;
DB::getPdo()->sqliteCreateFunction('floor', fn ($value) => floor($value));
DB::getPdo()->sqliteCreateFunction('datediff', fn ($date1, $date2) => Carbon::parse($date1)->diff(Carbon::parse($date2))->days);We’re using Laravel Socialite with a self-hosted GitLab instance to authenticate users for an internal tool.
Every time the session times out, the OAuth flow redirects the user back to the default dashboard, regardless of what URL the user originally requested.
However, Laravel provides a url.intended session key with the original URL; here’s how I used it, with a fallback to the dashboard URL:
return redirect()->to(
session()->get('url.intended', route('dashboard')
);I build an oEmbed provider in a Laravel application the other day and needed to parse an arbitrary URL to determine the route and parameters passed in order to determine the response.
Since I already had the routes built for the possible URLs, I didn’t want to duplicate code and re-parse them.
Here’s how I ended up retrieving the route and parameters:
I build a Laravel-based command-line utility to import sermons from the Sermon Manager for WordPress plugin and migrate them into SermonAudio.
If it’s useful to you, see this repository for setup and usage details: https://gitlab.com/andrewminion/sermon-manager-to-sermon-audio
A quick MySQL snippet to count how many times a value appears in a single field—much easier to grok than multiple JOINs.
SELECT
COUNT(CASE WHEN meta_value = 'value1' THEN 1 END) AS value1,
COUNT(CASE WHEN meta_value = 'value2' THEN 1 END) AS value2
FROM wp_post_meta;
/** Results
| value1 | value2 |
|--------|--------|
| 75 | 56 |
*/One common issue with local development is how to handle uploaded files.
You could copy the entire wp-content/uploads/ directory but that can use up a lot of disk space for little benefit.
Another option is to rewrite all HTTP requests for local images to the appropriate URLs on the live site.
Here’s how to do it:
Find your nginx config file1 and add this line in the location / { block2:
rewrite ^/wp-content/uploads/(.*)$ https://{live site domain}/wp-content/uploads/$1;
Add this line to the .htaccess file:
RewriteRule ^wp-content/uploads/(.*)$ http://{live site domain}/wp-content/uploads/$1 [NC,L]
~/.config/valet/Nginx/ for a file with the same name as your site’s domain.last at the end
artisan tinker and psysh with XdebugI often use Xdebug for troubleshooting and interactively debugging local code as I write it.
Laravel’s artisan command is extremely useful for running code interactively during development. (It’s based on another utility named psysh.)
It can be very useful to set some debug breakpoints and then run code interactively using artisan, but occasionally when I run php artisan tinker, the PHP shell just sits there and doesn’t accept any input until I kill my xdebug listener.
Thanks to this issue, I finally have a solution.
Add this to the psysh config file (~/.config/psysh/config.php on macOS):
<?php
return [
'usePcntl' => false,
];When developing WordPress plugins for general use, I like to open the plugin directory itself in VS Code.
This allows me to use the git integration and terminal without wading through the wp-content/plugins/{plugin name} directory structure.
However, this results in the WordPress functions appearing as “undefined function” and the inability to jump to their definition or hover to see parameters and other details.
Here’s how I fix that annoyance:
intelephense.environment.includePaths