Tag: data-management
-
Bash Script: Calculate before/after 2: Calculate Harder
in Dev StuffI’ve updated my script to test URL performance during changes, measuring the Time to First Byte (TTFB). The script now records initial and subsequent TTFB to determine update impact, displaying percentage change—a helpful tool for reporting.
-
Gathering database performance with WP-CLI
in WordPressDiscover how we employed WP-CLI to streamline the assessment of database server performance in WordPress, facilitating a more efficient profiling of SQL queries before and after crucial server upgrades.
-
Half Baked Idea: Limiting WordPress Image Upload Sizes
in WordPressLimit image upload size in WordPress media library by using the `wp_handle_upload_prefilter` filter. Implement a custom function to check and restrict the size of uploaded images. Utilize PHP code to set a maximum size limit and display an error message if the file exceeds it. Add this functionality to your WordPress site.
-
Fixing a broken ATOM Feed
The article explains how to convert an outdated ATOM feed to a JSON feed using a PHP proxy script. It details the process of fetching, caching, and transforming the XML data into a JSON format that can be used for more modern feed readers. The provided code snippets illustrate the conversion steps from ATOM to…
-
Quick Tip: Get Size of Revisions in WordPress
in WordPressMonitoring and managing data bloat in a WordPress site can be crucial. The introduction of the block editor has led to a surge in post revisions, which can clog up the database. Conducting a revision data audit using SQL queries can reveal the extent of unnecessary data accumulation, highlighting the importance of setting limits to…
-
My Favorite Firefox Addons
A list of Firefox add-ons for various functions such as password management, privacy, and content filtering. Add-ons include 1Password X, ClearURLs, uBlock Origin, and more. Explore these options for enhancing your browsing experience.
-
Getting WordPress Database Size via WP-CLI
in WordPressA WordPress WP-CLI command `db-size` allows fetching database tables, their data, and index size in various formats. The command offers sorting options like total, table, data size, and index size. Use `–format` to adjust the output format (`table`, `csv`, `json`, `count`, `yaml`), and `–raw` for full byte size.
-
Quick Tip: Export WordPress SQL output via WP-CLI
Learn how to run custom SQL queries on your WordPress database using a small WP-CLI command. The command supports different output formats like table, CSV, JSON, and more. Plus, it includes a dry run option for safety. No need to rely on `wp db query` anymore!
-
phpMyAdmin and MariaDB with Docker
in Dev StuffLearn how to set up MariaDB and phpMyAdmin using Docker on a MacBook Pro. Start containers, configure settings, and connect to databases easily. Useful commands included for managing containers and performing tasks like importing SQL files. Helpful references provided for your Docker journey.