Notes to Myself

Installing MongoDB on Windows

By Ercan
13/04/2025
0 comments

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..

PostgreSQL Date based Query Examples

By Ercan
13/04/2025
0 comments

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..

ImageMagick Usage Examples

By Ercan
13/04/2025
0 comments

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

Rest API Response Standards

By Ercan
13/04/2025
0 comments

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 ..

FFmpeg Usage Examples

By Ercan
13/04/2025
0 comments

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

ExifTool Usage Examples

By Ercan
13/04/2025
0 comments

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

Removing Old Eclipse Versions

By Ercan
13/04/2025
0 comments

In Eclipse-based IDEs, after performing an update, files from previous versions are retained. To remove these files, first delete the old versions from the Installation History. Then, retrieve the value of eclipse.p2.profile from the «installation_path»/configuration/config.ini file. Use this value in the following command: eclipse -application org.eclipse.equinox.p2.garbagecollector.application -profile <<profile>> Example usage: .\dbeaver.exe -application org.eclipse.equinox.p2.garbagecollector.application -profile DefaultProfile .\eclipse.exe -applica..