• Your shopping cart is empty!

Recent Posts

Installing Podman on Windows

This guide outlines the steps to install Podman on a Windows environment. 1. Enable Required Windows Features Open PowerShell as Administrator and execute: dism.exe /online /enable-feature /featurename:Microsoft-Windows-Subsystem-Linux /all /norestart dism.exe /online /enable-feature /featurename:VirtualMachinePlatform /all /norestart Restart your computer to apply the changes. 2. Install WSL 2 Download and install the latest WSL 2 update from: https://wslstorestorage.blob.core.windows.net/wslblob/wsl_update_x64.msi 3. Set WSL 2 as Default Version In PowerShell,..

Continue Reading

Changing Podman Data Directory on Windows

This guide outlines the steps to change the Podman data directory on a Windows environment by exporting and importing the WSL instance. 1. Stop the Podman Machine Execute the following command to stop the Podman machine: podman machine stop 2. Export the WSL Instance Export the existing WSL instance to a backup file: wsl --export <<instance_name>> backup.tar 3. Unregister the WSL Instance Unregister the current WSL instance: wsl --unregister <<instance_name>> 4. Import the WSL Instance to New Location Import the WSL instance to t..

Continue Reading

Using OpenStreetMap Data with PostgreSQL

This guide outlines the steps to import OpenStreetMap (OSM) data into a PostgreSQL database with PostGIS support on a Windows environment. 1. Install PostGIS Extension Add spatial support to PostgreSQL by installing the PostGIS extension: https://postgis.net/install/ 2. Create a PostgreSQL Database Create a new database in PostgreSQL to store the OSM data. Then, enable the necessary extensions by executing: CREATE EXTENSION postgis; CREATE EXTENSION hstore; 3. Download OSM Data Obtain the desired .osm.pbf file from Geofabrik: https://download.geofabrik.de/ 4. Downloa..

Continue Reading

Installing PostgreSQL on Windows

This guide outlines the steps to install and initialize PostgreSQL on a Windows environment using the ZIP archive. 1. Download PostgreSQL Visit the official PostgreSQL website and download the ZIP archive: https://www.enterprisedb.com/download-postgresql-binaries 2. Extract the ZIP File Extract the downloaded ZIP file to your desired location, for example: D:\Dev\pgsql-14.1 3. Create Necessary Directories Within the extracted folder, create the following directories: mkdir <<postgresql_path>>\data mkdir <<postgresql_path>>\log 4. Initialize Po..

Continue Reading

Installing MongoDB on Windows

This guide outlines the steps to install MongoDB on a Windows environment. 1. Download MongoDB Visit the official MongoDB website and download the Community Server version in ZIP format: https://www.mongodb.com/try/download/community 2. Extract the ZIP File Extract the downloaded ZIP file to a desired location, for example: D:\Dev\mongodb-7.0.2 3. Create Necessary Directories Within the extracted folder, create the following directories: mkdir <<mongodb_path>>\conf mkdir <<mongodb_path>>\data mkdir <<mongodb_path>>\log 4. Create C..

Continue Reading

PostgreSQL Date based Query Examples

Today select current_date; --2024-01-17 Yesterday select current_date - 1; --2024-01-16 Tomorrow select current_date + 1; --2024-01-18 Format Date select to_char(current_date,'DD/MM/YYYY'); --17/01/2024 This year select extract(year from current_date); --2024 Next year select extract(year from current_date + interval '1 year'); --2025 Last year select extract(year from current_date - interval '1 year'); --2023 First day of current month select cast(date_trunc('month', current_date) as date); --2024-01-01 Last day of current month select cast(date_trunc('month',current_da..

Continue Reading

ImageMagick Usage Examples

You can download ImageMagick by using link below. https://imagemagick.org/script/download.php Adding Watermark to Photo composite -gravity <<position>> <<watermark_file>> <<input_file>> <<output_file>> Possible position values; SouthEast, SouthWest, NorthEast, NorthWest

Continue Reading

Rest API Response Standards

List - GET --------------------------------------------------------------------- Success - 200 OK - Return list of resulting entities matching the search criteria Success - 200 OK - Return an empty array Get Specific - GET --------------------------------------------------------------------- Success - 200 OK - The entity matching the identifier specified is returned as content Failure - 404 Not Found - No content Create - POST --------------------------------------------------------------------- Success - 201 Created ..

Continue Reading

FFmpeg Usage Examples

You can download FFmpeg by using link below. https://ffmpeg.org/download.html Cutting the Video/Audio file at certain intervals ffmpeg.exe -ss 00:16:10 -to 00:18:26 -i <<input_file>> <<output_file>> Changing video size and frame rate ffmpeg.exe -i <<input_file>> -vf "scale=960:540,fps=25" <<output_file>> Changing video size and frame rate by using Nvidia GPU ffmpeg.exe -hwaccel cuda -i <<input_file>> -vf "scale=960:540,fps=25" <<output_file>>

Continue Reading

ExifTool Usage Examples

You can download ExifTool by using link below. https://exiftool.org/ Changing the date information of the file exiftool -AllDates="2021:11:28 00:00:00" FolderOrFile Adding or changing GPS data to the file exiftool -XMP:GPSLongitude="<<value>>" -XMP:GPSLatitude="<<value>>" -GPSLongitudeRef="East" -GPSLatitudeRef="North" <<path>>

Continue Reading
Showing 11 to 20 of 21 (3 Pages)