Recent Posts (Ercan)
Installing PostgreSQL on Windows
- By Ercan
- 13/04/2025
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 PostgreSQL Run the fo..
Installing MongoDB on Windows
- By Ercan
- 13/04/2025
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 Configuration File In..
PostgreSQL Date-Based Query Examples: Today, Month, and Year
- By Ercan
- 13/04/2025
Working with dates is essential in PostgreSQL for reporting, analytics, and application logic. This guide provides practical examples of common date-based queries in PostgreSQL, from today’s date to month and year calculations. 1. Day-Based Queries PostgreSQL makes it easy to retrieve today’s, yesterday’s, or tomorrow’s date: -- Today SELECT current_date; -- Output: 2024-01-17 -- Yesterday SELECT current_date - 1; -- Output: 2024-01-16 -- Tomorrow SELECT current_date + 1; -- Output: 2024-01-18 2. Formatting Dates You can format dates using the to_char function: ..
ImageMagick Usage Examples
- By Ercan
- 13/04/2025
ImageMagick is a powerful open-source tool for creating, editing, and converting images directly from the command line. It supports hundreds of image formats and offers a wide variety of operations, including resizing, cropping, filtering, color adjustments, annotations, and more. Whether you want to process a single image or automate transformations on large image collections, ImageMagick provides a versatile and scriptable solution. You can download ImageMagick by using link below. https://imagemagick.org/script/download.php ⚡ Basic Image Operations Convert image format: ..
Rest API Response Standards
- By Ercan
- 13/04/2025
When building or consuming REST APIs, HTTP status codes are one of the most important aspects of communication between the server and the client. They tell us whether a request was successful, failed, or requires additional action. Below is a structured guide to the most common REST API responses, based on typical CRUD operations (Create, Read, Update, Delete). List – GET 200 OK – Returns a list of entities matching the search criteria. 200 OK (Empty Array) – Indicates no entities were found, but the request was still successful. Get Specific – GET 200 OK – The req..
FFmpeg Usage Examples
- By Ercan
- 13/04/2025
FFmpeg is a versatile open-source tool for handling multimedia data, including video, audio, and images. It provides command-line utilities for converting formats, extracting metadata, resizing, cropping, merging, and automating repetitive tasks. Whether you need to process a single file or manage large collections of media, FFmpeg offers fast and flexible solutions. You can download FFmpeg by using link below. https://ffmpeg.org/download.html ⚡ Basic Video Operations Convert video format: ffmpeg -i input.mp4 output.avi Display video information: ffmpeg -i input.mp4 ..
ExifTool Usage Examples
- By Ercan
- 13/04/2025
ExifTool is a robust and open-source command-line application developed by Phil Harvey, designed to read, write, and manipulate metadata across hundreds of file formats. Whether you're geotagging images for a research dataset or updating timestamps after image capture, ExifTool provides a flexible and script-friendly solution. You can download ExifTool by using link below. https://exiftool.org/ 📦 Basic Metadata Operations View all metadata: exiftool image.jpg View specific fields: exiftool -Make -Model -DateTimeOriginal image.jpg Export all metadata to a text file:..
Cleaning Up Old Version Files After Updating Eclipse-Based IDEs
- By Ercan
- 13/04/2025
In Eclipse-based IDEs, when you perform an update, files from previous versions are often retained on your system. Over time, these leftover files can consume unnecessary disk space. To remove them safely, follow these steps: 1) Delete old installations Go to Help → About → Installation Details → Installation History, and remove any outdated installations. 2) Find your installation profile The profile name is usually stored in the file: <installation_path>/configuration/config.ini Look for the property: eclipse.p2.profile 💡 You can also find this information under the..
lifeboxtransfer – Your User-Friendly WeTransfer Alternative
- By Ercan
- 19/12/2024
Sharing files online should be simple, fast, and safe. Whether it’s work documents, photos, or videos, you need a platform that’s reliable and easy to use. lifeboxtransfer offers a free and secure way to send files up to 5GB, making it an excellent alternative to WeTransfer. Key Features of lifeboxtransfer 1️⃣ Free and Easy File Sharing Upload your files and share them instantly via a direct link or email. No account is required—just drag, drop, and share. 2️⃣ Flexible Expiration Options You decide how long your files stay accessible: 7, 14, or 21 days. This automatic expi..