After eight years of general availability, no one can say MySQL 5.7 didn’t have a good run. MySQL 5.7 officially reaches its End of Life (EOL) in October 2023. The good news is that MySQL 8.0 offers enhanced security, potential Continue reading What MySQL 5.7 EOL Means for WordPress Developers
Keeping regular backups of your WordPress installs is one of the most important things you should do after you launch a site. If you search for the term “backup” in the WordPress plugin repository, you’ll find over 700 that claim Continue reading Remotely Back Up Your WordPress Database and Media With WP Migrate CLI
In any business, data is your biggest asset. By analyzing data, you can make decisions on customer trends and behavior prediction. This boosts business profitability and effective decision-making. Without database software, a simple task like finding the average of all Continue reading 9 Types of Mongodb Operators You Need To Know
Webhooks are a mechanism for receiving notifications about events from disparate systems without having to continuously poll them. Also called Reverse APIs, they can be thought of as providing “API specs” that the consuming system needs to implement. One of Continue reading How to Test Webhooks From Public APIs in Local Development
As any site owner will tell you, data loss and downtime, even in minimal doses, can be catastrophic. They can hit the unprepared at any time, leading to reduced productivity, accessibility, and product confidence. To protect the integrity of your Continue reading PostgreSQL Replication: A Comprehensive Guide
Databases are essentially the backbone of any software. With several databases in the market and the increasing popularity of open-source databases, many developers and businesses share a common concern: How do you pick the right one? In this article, we’ll Continue reading MariaDB vs PostgreSQL: 14 Critical Differences
When starting a new project, one of the things developers can struggle with is choosing a stack. Zeroing in on the right technology to solve a problem can be a nerve-wracking experience. Databases in particular can be challenging to settle Continue reading MongoDB vs PostgreSQL: 15 Critical Differences
With a vast assortment of databases to choose from in the market, users can often mull over PostgreSQL vs SQL Server to iron out the better option for their use case. Organizations that leverage PostgreSQL for their operations might want Continue reading PostgreSQL vs SQL Server: 16 Critical Differences
Database synchronization is a problem that still gets raised almost every month in the local WordPress communities I’m part of – “if I am making changes to my local site, what happens to any updates made on the live site, Continue reading Syncing WordPress Database Changes Between Environments: How We Handle Merging in 2022
Here at Delicious Brains we eat, drink and sleep databases. However, we believe that any developer working with WordPress should have some level of knowledge about the database that sits behind a site. So I have put together the ultimate Continue reading The Ultimate Developer’s Guide to the WordPress Database
Have you ever wondered what it takes to create a custom table in WordPress or why you would ever want or need to? WordPress comes with many different ways to store data out-of-the-box. Luckily for us, WordPress is flexible enough Continue reading Creating a Custom Table with PHP in WordPress
Once upon a time I tried to build a theme and plugin store into the WordPress dashboard. Kind of like iTunes for WordPress. I called it WP App Store. Long story short, it didn’t work, I started this company (Delicious Continue reading Managing Custom Tables in WordPress
We’ve been asked this question a few times now, “Why should I invest in WP Migrate DB Pro when WordPress itself has a readily available export feature.” It’s a great question and one that we’re happy to answer. The long Continue reading WordPress XML Export/Import vs. WP Migrate DB Pro