Recent Posts (rest)
Backing Up and Restoring PostgreSQL Databases
- By Ercan
- 17/04/2025
This guide outlines the steps to back up and restore PostgreSQL databases using command-line tools on Windows. Backing Up a Database To back up a PostgreSQL database, use the `pg_dump` utility: .\pg_dump.exe -U <username> -d <database_name> > <dump_path> Example: .\pg_dump.exe -U postgres -d testdb > C:\Users\Ercan\Desktop\db_dump.sql Backing Up a Table To back up a PostgreSQL table, use the `pg_dump` utility: .\pg_dump.exe -U <username> -d <database_name> -t <table_name> > <dump_path> Example: .\pg_dump.e..
Backing Up and Restoring MongoDB
- By Ercan
- 17/04/2025
This guide outlines the steps to back up and restore MongoDB databases using the official MongoDB Database Tools. 1. Download MongoDB Database Tools Obtain the MongoDB Database Tools from the official website: https://www.mongodb.com/try/download/database-tools 2. Backing Up a Database Use the `mongodump` utility to create a backup of your database: .\mongodump.exe --db=<<db_name>> --out <<dump_path>> Replace `<<db_name>>` with the name of your database and `<<dump_path>>` with the desired output directory. 3. Restoring ..
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..