-
There are a number of ways to migrate your data, depending on the age of the NAS, OS versions, and filesystems in use. Synology have a guide to help you…
-
For mission critical applications you need a lot more care, but for that simple side-gig or personal project this simple one-shot script will give a good idea of any major…
-
Recently I was rebuilding the Helpful Digital intranet using a WordPress block theme called UniBlock. As part of this I had written a custom plugin to register a new post…
-
While working on a project recently – a mapping one which required complex queries – I worked more with MySQL views. They undeniably make looking at complex data sources easier…
-
I’m starting this series with the simplest aspect – a MySQL query to return rows based on radius from a point. This is well trodden territory, although not always explained…
-
For a recent mapping project I implemented Algolia Places for address autocompletion to turn an address into latitude and longitude for querying the database. In the past we’ve used Google Maps,…
-
Trying to give myself a nudge to complete some 1/2 written posts, and write the unwritten ones, I decided to switch out the theme (again). I’ve gone with a very…
-
Excluding posts (or custom post types) from search results when they meet certain criteria is easy in theory. Just use the pre_get_posts action to modify the WP_Query arguments used to…
-
I often run one off reports for clients directly from the MySQL database behind their (normally WordPress) websites. Most are straightforward, perhaps requiring data from the wp_posts and wp_postmeta tables.…
-
Let's get a list of all duplicate postcodes (could be any string of course) out of a specific field in the database. This could be handled in PHP but, with…