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
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
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
0 Comment