5 Tools to test website responsiveness
Updated 2nd December 2023
If you are concerned with providing a great experience to users and potential customers on mobile devices, or you are concerned with your SEO rankings, then you need a reliable way to confidently test website responsiveness. How website responsiveness affects SEO It is widely known that search engines rank websites higher if they perform well
SQL Union – What is a Union and how to combine two or more SQL Select queries
Updated 1st December 2023
The SQL UNION Operator is used to combine two or more SELECT statements together into one set of results. Things to know about SQL Union Operator To execute a SQL UNION statement successfully, you need to be away of the requirements of a UNION statement. Example using SQL UNION In our example we have 2
How to transform geometries with PostGIS
Updated 2nd October 2023
PostGIS is a power extention for PostgreSQL databases. It provides a suite of tools to handle and manipulate geographic data. At times, you may need to transform geometries with PostGIS for different base maps or to perform more accurate calculations, such as calculating the area of a polygon. Transform geometry with PostGIS PostGIS has a
How to install PostGIS
Updated 2nd October 2023
PostGIS is a plugin which adds support for storing, indexing and querying geographic data in PostgreSQL databases. To get started with PostGIS, you will need to install the extension on your PostgreSQL database. If you are using PostgreSQL as a service from a cloud provider, you may already have PostGIS installed. How to check if
How to setup a remote MySQL database connection in PHPStorm
Updated 1st October 2023
PHPStorm is packed full of features designed to make the development process for PHP developers efficient and streamlined. Although Jetbrains have a standalone product for interacting with databases, named DataGrip, PHPStrom ships with the Database Tools and SQL plugin. This tools is powerful, integrated directly within the IDE, and provides a convinient way to intract
PHP 8.3 release and features
Updated 6th September 2023
The time of year is fast approaching for PHP developers around the world. We have a new PHP release knocking on the door. PHP 8.3 RC 1 is now available for testing, and with this release we are able to get a glimps at some of the highlight features coming later in the year. PHP
Find php.ini on Apple Silicon installed with Homebrew
Updated 1st October 2023
Are you having trouble finding your php.ini file which was installed locally with Homebrew? Packages installed with Homebrew can be installed in different locations making it hard to find, especially if you are on new Apple Mac running Apple’s Silicon chips. Here, I will show you home to locate your locally installed php.ini file installed
Laravel 9: How to Add a New Column to an Existing Table in a Migration
Updated 1st October 2023
Laravel has a number of features designed to make developing web applications easier and faster. Migrations in Laravel allows us to manage the structure of our databases. In this post, you will learn how to add a new column to an existing table in a migration. Create a new migration file First, we need to
List of programming languages used for Web Development
Updated 16th August 2022
There are a wide variety of programming languages that can be used for web development. Which one you choose depends on your preferences and needs. Some languages are better suited for certain tasks than others. In this post, we’ll take a look at some of the most popular languages used for web development. JavaScript PHP
5 Tips for quickly learning web development
Updated 1st October 2023
If you’re interested in learning web development, you may be wondering how to go about it in the most efficient way possible. There’s no single answer to this question, as different people have different learning styles and preferences. However, there are a few general tips that can help you make the most of your learning