Skip to content

This repository showcases basic CRUD (Create, Read, Update, Delete) operations using PostgreSQL. It includes examples of how to interact with a PostgreSQL database, perform queries, manage data, and optimize database interactions. Ideal for developers looking to understand the essentials of database management with PostgreSQL.

Notifications You must be signed in to change notification settings

raihanuldev/PostgreSQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PostgreSQL-CRUD OPERATION

PostgreSQL, often referred to as "Postgres," is a powerful open-source relational database management system (RDBMS). It is known for its reliability, extensibility, and compliance with SQL standards

Create Database

-- Create database ; write it on CMd

CREATE DATABASE usersDB;

-- create a Table
CREATE TABLE book (
    id VARCHAR(255) PRIMARY KEY,
    name VARCHAR(20),
    role VARCHAR(20),
    description VARCHAR(250)
);

GET ALL BOOK FROM book Collection

app.get('/books', async(req,res)=>{
    try {
        const books = await pool.query("SELECT * FROM book")
        res.status(200).json({message: "data recived",data:books.rows})
    } catch (error) {
        res.json({error: error.message})
    }
})

Get Specific Book by Id

app.get('/books/:id',async(req,res)=>{
    try {
        const {id} = req.params;
        // console.log(id)
        const book = await pool.query("SELECT * FROM book WHERE id=$1",[id])
        res.status(200).json({text:"book paisi", data:book.rows})
    } catch (error) {
        res.json({error: error.message})
    }
})

delete specific Book by id

app.delete('/books/:id',async(req,res)=>{
    try {
        const {id} = req.params;
        const book = await pool.query("DELETE FROM book WHERE id=$1",[id])
        res.status(200).json({text:'Deleted'})
        
    } catch (error) {
        res.json({error: error.message})
    }
})

Update Book

app.put('/books/:id',async(req,res)=>{
    try {
        const {id} = req.params;
        const {name,description} = req.body;
        const updatedBook = await pool.query("UPDATE book SET name=$1,description=$2 WHERE id=$3 RETURNING *",[name,description,id])
        res.status(200).json({text: 'Book data Updated',data:updatedBook.rows})
    } catch (error) {
        res.json({error: error.message})
    }
})

POST Book on book Collection

app.post('/books',async(req,res)=>{
    try {
        const {name,description} = req.body;
        const id = uuidv4();
        // Post on the database 
        const newBook = await pool.query(
            "INSERT INTO book (id,name,description) VALUES ($1,$2,$3) RETURNING *",
            [id,name,description]
        )
        res.status(201).json({data: newBook.rows})
    } catch (error) {
        res.json({error: error.message})
    }
})

Contributing

Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.

Please make sure to update tests as appropriate.

License

MIT

About

This repository showcases basic CRUD (Create, Read, Update, Delete) operations using PostgreSQL. It includes examples of how to interact with a PostgreSQL database, perform queries, manage data, and optimize database interactions. Ideal for developers looking to understand the essentials of database management with PostgreSQL.

Topics

Resources

Stars

Watchers

Forks