Tag: Databases

What MySQL 5.7 EOL Means for WordPress Developers

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 boosts in performance, new data types, and new features like common table expressions that give WordPress developers an expanded toolbox. In this article, we explore the differences between MySQL 5.7 and 8.0...
Continue Reading What MySQL 5.7 EOL Means for WordPress Developers

Managing WordPress Dev Environments With WP-CLI and Robo

Automating repetitive tasks is one of the best ways to save time in your development workflow. In my day to day work as a plugin developer, I often have to… Read more The post Managing WordPress Dev Environments With WP-CLI and Robo appeared first on Delicious Brains. ...
Continue Reading Managing WordPress Dev Environments With WP-CLI and Robo

How to Test Webhooks From Public APIs in Local Development

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… Read more The post How to Test Webhooks From Public APIs in Local Development appeared first on Delicious Brains. ...
Continue Reading How to Test Webhooks From Public APIs in Local Development

Python With Keyword

‘with’ is a keyword in Python. The reserved words in Python or any other programming language are called keywords. A keyword cannot be used as a variable name, function name, or for any other type of identification. The keyword mentioned above, alongside other keywords, could change depending on the Python version. ...
Continue Reading Python With Keyword

Clean Code Tip: F.I.R.S.T. acronym for better unit tests

Good unit tests have some properties in common: they are Fast, Independent, Repeatable, Self-validating, and Thorough. In a word: FIRST! ...
Continue Reading Clean Code Tip: F.I.R.S.T. acronym for better unit tests

Python Throw Exception explained with examples

Exceptions in Python programs can occur for various causes, and if they aren’t handled properly, they can cause the program to crash, resulting in data loss or, worse, data corruption. As a Python programmer, you must consider various exception scenarios and incorporate error management into your code. ...
Continue Reading Python Throw Exception explained with examples

How to sort DataFrame by column in Pandas

The ability to sort datasets is one of Pandas’ most appealing features. By sorting, you can see your relevant data at your table’s top (or bottom). There isn’t much you need to know right away. When you sort several columns with sort keys, the magic happens. ...
Continue Reading How to sort DataFrame by column in Pandas

CRUD operations on PostgreSQL using C# and Npgsql

Once we have a Postgres instance running, we can perform operations on it. We will use Npgsql to query a Postgres instance with C# ...
Continue Reading CRUD operations on PostgreSQL using C# and Npgsql

CRUD operations on PostgreSQL using C# and Npgsql

Once we have a Postgres instance running, we can perform operations on it. We will use Npgsql to query a Postgres instance with C# ...
Continue Reading CRUD operations on PostgreSQL using C# and Npgsql

CRUD operations on PostgreSQL using C# and Npgsql

Once we have a Postgres instance running, we can perform operations on it. We will use Npgsql to query a Postgres instance with C# ...
Continue Reading CRUD operations on PostgreSQL using C# and Npgsql