Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...
Posts by Category
Mac
Too many open files error on macOS
We’re going to increase an ulimit setting on macOS, but first let’s obtain the current limit of file descriptors via ulimit -n.
How to Write to NTFS Drives in macOS Mojave
In case you use NTFS formatted USB drives on your Mac, you can only open files stored on those drives, but you can’t change those files.
Set up PHP 7.2 on macOS Mojave (with homebrew)
To check the version of PHP in the terminal, type the following command:
Error: tool ’xcodebuild’ requires Xcode… on macOS
If you get the following error with npm install
Launch Sublime Text 3 from the terminal
$ echo $PATH
SSH keys are lost after macOS High Sierra reboot
To list all keys run
Make a Zip Archive without a .DS_Store file on macOS
Let’s compress folder (current one) without the .DS_Store file
DevOps
Enable TLS (SSL) database connection and certificate-based authentication
This note aims to show step by step how to generate a self-signed SAN SSL/TLS certificate on macOS Monterey and then configure a secure connection and certif...
Install AWS CLI on macOS
Easiest way to install AWS CLI
How to reload Nginx on Alpine Linux
When you run the following command, Nginx will reload its configuration from a specified file without stopping the server
Working with AWS credentials on macOS
Check credentials
Create MySQL dump on EC2 instance and download it
We’re going to create a MySQL dump on an EC2 instance, compress and download this file to our local (Mac) machine.
MySQL
Next AUTO_INCREMENT value
To get the next AUTO_INCREMENT value from a table run the following query:
Create MySQL dump on EC2 instance and download it
We’re going to create a MySQL dump on an EC2 instance, compress and download this file to our local (Mac) machine.
Extra Ukrainian letters are not sorted well
The problem is that Ukrainian letters are not sorted correctly by the alphabet, ie “і” and “є” are preceded by “а”, “б”, while using the ORDER BY operator in...
PHP
PHP 7 Compatibility Checker (php7cc)
$ apk add php7-phar
Does a remote file exist (using get_headers)?
As you probably know, a get_headers function in PHP typically returns something similar to:
JavaScript
At least one checkbox must be selected (checked)
There is a form with multiple checkboxes and we’re going to make sure that at least one is checked using pure JavaScript. To set a custom validation error me...
How to fix imprecise calculations in JavaScript
What is it about? Try to execute some of the following examples in the browser console (or somehow using JavaScript) and you will see that sometimes there ar...
WordPress
How to add email to MailChimp list using WordPress
```php <?php
Testing
Using Apache Bench for simple load testing
The following command runs 100 requests in total with 10 concurrent requests to example.com.