A meta table as it’s name suggests, is a table containing metadata for the parent table (for example, wp_postmeta contains metadata for wp_post). These data are additional data stored in database to be retrieved when needed. Let’s say you publish a post. The original post data will be stored in wp_post table, while the rest … Read more
Access/update database with jQuery
As you will probably want to eventually do some reporting on the data, e.g. print a temperature average from this month last year in area X, I’d opt for custom tables from the beginning. I’m saying tables, because I don’t see a reason why you wouldn’t put the locations into a custom table as well. … Read more
Trigger Plugin database update after git pull
Scaling with hardware alone is expensive. We’ve worked with a few high traffic sites and a lot of demanding ecommerce/WooCommerce sites. The way we’ve scaled those is by testing the code, optimising database calls, optimising the database itself and implemented full page caching. Here’s a few tips to get you started Use nginx instead of … Read more
Emojis getting converted to “?”
To develop wordpress pages on Kubernetes, there are two types of tools you might want to use: 1. Dev Tools for Kubernetes Workflow There are a couple of dev tools for building applications directly on top of Kubernetes: ksync: https://github.com/vapor-ware/ksync (basic code sync) DevSpace: https://github.com/covexo/devspace (real-time code sync) Skaffold: https://github.com/GoogleContainerTools/skaffold (continuous deployment) Draft: https://github.com/Azure/draft (continuous … Read more
Reasons this might happen: When WP checks the tables exist and they don’t If the DB connection fails The database is unreachable A DESCRIBE query on the tables fails, be it permissions or access based If there is an error recorded in the wpdb object while setting up initial variables in wp_set_wpdb_vars When ms_load_current_site_and_network returns … Read more
Best Practice for Syncing Local Development With Staging Development [closed]
I have found that the following works for connecting the database via the theme’s functions.php file. I placed this code snippet at the end of the existing code in the file. Even though the fatal error threw several line errors when trying to access the site, it only came down to wpdb having an extra … Read more