Dcoker Start to end

-
Start the PostgreSQL Container

docker run --name postgres-learn \

  -e POSTGRES_PASSWORD=mysecretpassword \

  -p 5432:5432 \

  -d postgres   


ACCESS the SQL Shell (psql) inside the Container

docker exec -it postgres-learn psql -U postgres

Rul you first query to list all database

\l

Create New Data Base

CREATE DATABASE learning_db;   

Connect to your new database

\c learning_db

Create Table inside the database

CREATE TABLE students (

  id SERIAL PRIMARY KEY,

  name VARCHAR(50),

  age INT

  gender VARCHAR(50)

);

Insert in the database

INSERT INTO students (name, age) VALUES ('Alice', 25);

INSERT INTO students (name, age) VALUES ('Bob', 30);   

Exit the shell

\q

Before Restart the container Check total container

docker ps -a
Container Start
docker start <container-id or container-name>

Comments

Post a Comment

Popular posts from this blog

VERTICAL SCALING 💋

-
 # 🚀 VERTICAL SCALING - COMPLETE GUIDE (0 to 100) # Everything You Need to Know About Vertical Scaling in JavaScript/TypeScript ================================================================================ TABLE OF CONTENTS ================================================================================ 1. WHAT IS VERTICAL SCALING? 2. VERTICAL VS HORIZONTAL SCALING 3. NODEJS CLUSTERING 4. LOAD BALANCING 5. MEMORY OPTIMIZATION 6. CPU OPTIMIZATION 7. DATABASE OPTIMIZATION 8. CACHING STRATEGIES 9. CONNECTION POOLING 10. RATE LIMITING 11. COMPRESSION & GZIP 12. WORKER THREADS 13. MONITORING & PROFILING 14. PRODUCTION DEPLOYMENT 15. COMPLETE EXAMPLES 16. TROUBLESHOOTING ================================================================================ 1. WHAT IS VERTICAL SCALING? ================================================================================ VERTICAL SCALING (Scale Up): Increasing the power of a single server. More CPU cores, more RAM, faster storage, better ...
Read more

CyberSecurity

-
 # 🔒 CYBERSECURITY A TO Z - COMPLETE GUIDE (0 to 100) # Everything You Need to Know About Cybersecurity - From Noob to Pro ================================================================================ TABLE OF CONTENTS ================================================================================ 1. CYBERSECURITY FUNDAMENTALS 2. COMMON THREATS & ATTACKS 3. AUTHENTICATION & AUTHORIZATION 4. ENCRYPTION & CRYPTOGRAPHY 5. NETWORK SECURITY 6. WEB APPLICATION SECURITY 7. DATABASE SECURITY 8. API SECURITY 9. CLOUD SECURITY 10. INCIDENT RESPONSE 11. COMPLIANCE & STANDARDS 12. SECURITY TESTING 13. SECURE CODING PRACTICES 14. DEPLOYMENT SECURITY 15. MONITORING & DETECTION 16. REAL-WORLD IMPLEMENTATIONS ================================================================================ 1. CYBERSECURITY FUNDAMENTALS ================================================================================ WHAT IS CYBERSECURITY? Protection of computer systems, networks, and data fr...
Read more

The Journey of Data — "Frontend → Backend → Database → Frontend"

-
  That’s an excellent question — and it’s one that every good backend/frontend developer must deeply understand. 💡 Let’s make this super clear and visual 👇 🧩 1. The Journey of Data — "Frontend → Backend → Database → Frontend" When you click a button or send a form, data travels from frontend → backend → database (and sometimes back). But how the data travels depends on how you send it — via: URL (params or query) Request body Headers Cookies Let’s break these down one by one. ⚙️ 2. req.params — URL Parameters (Part of the Route) Example: Frontend: await axios.get('/api/user/123'); Backend: app.get('/api/user/:id', (req, res) => { console.log(req.params.id); // "123" }); 🧠 Use req.params when : The data identifies a specific resource . Example: /user/:id , /post/:postId/comments , /delete/:id It’s part of the URL path, not optional. ✅ Example uses: Get a specific user: /users/:id Delete a specific post:...
Read more