Skip to main content

Installing MySQL Workbench using an elevated command prompt on Windows

Installing software on a Windows machine can sometimes require elevated privileges, especially when making changes to system-wide settings or configurations. One example is the MySQL Workbench, a widely-used tool for managing MySQL databases. In this article, we’ll walk through how to install MySQL Workbench using an elevated command prompt, rather than installing it directly through the graphical interface.

Managing app versioning in Android Studio - simplifying versionCode, versionName, and versionNameSuffix

Versioning is an important aspect of any mobile app development process. In Android, this is handled through versionCode and versionName, which allow you to define the current state of your app for users and the Play Store. But where exactly should these be managed, and how can you ensure they propagate correctly across your project? This article covers the essentials of managing app versioning in Android Studio, using the build.gradle file.

 

Counting term occurrences in JSON arrays using regex in VS Code

Working on a project where the JSON dataset contains over 460,000 named records, we are preparing to upsert these records into Pinecone. However, for validation and testing purposes, it's essential to cross-check how many times a specific term appears across the dataset. To ensure data integrity, we only want to include one record per occurrence, regardless of whether the term appears once or multiple times within a record.

How to search for specific 'SBT' occurrences in VS Code using regular expressions

If you're working with a large codebase in Visual Studio Code (VS Code) and need to find specific occurrences of a term, but only when it's a standalone word possibly surrounded by spaces or parentheses, regular expressions (regex) are your best friend. This guide will walk you through the steps to efficiently search for these instances, I'll be searching for the term 'SBT' and ensuring you don't pick up unwanted matches like `'ADSBTCR'` or `'SBT123'`.

 

Enforcing HTTPS on an Nginx server: a step-by-step guide

In today's security-conscious world, enforcing HTTPS on your web applications is no longer optional—it's essential. Whether you're dealing with government reports or routine security audits, failing to enforce HTTPS can trigger warnings that leave you scrambling for a solution.

Navigating Docker and PHP with PECL: Trials, errors, and the eventual solution

Working with Docker can be a rewarding but occasionally frustrating experience, especially when dealing with development libraries and extensions that rely on external repositories. In this article, I’ll walk you through the trials and errors I encountered while setting up PECL and APCu in a PHP 8.2 Docker container. The process was full of lessons, dead ends, and ultimately, a working solution.

 

Resolving PHP GD library issues in Drupal

Introduction

For a while now, one persistent issue has been bugging me: a warning on Drupal's 'status report' page that reads:

GD library

library bundled (2.1.0 compatible)

How to search for "text" in VS Code while excluding comments

When working with code in Visual Studio Code, you may need to search for specific instances of a function or method, such as self.logger.log. However, it can be frustrating to sift through lines that are commented out, like # self.logger.log. Fortunately, VS Code provides a powerful search feature that allows you to exclude these commented lines from your search results.

 

Best practices and methods on how to create a Drupal 10 patch

When working on Drupal projects, especially in a collaborative environment, it’s crucial to follow best practices for creating and managing patches. Patches are essential for contributing back to the community, applying quick fixes, or sharing custom changes with your team. In this article, we'll explore the recommended method for creating a Drupal 10 patch and discuss when it might be appropriate to use alternative approaches.

Subscribe to