pg-ultra

pg-ultra হল একটি ছোট Node.js লাইব্রেরি যা PostgreSQL ডাটাবেসের সাথে সহজে সংযোগ এবং ডেটা ইনসার্ট/রিড করার জন্য তৈরি।

Install:

npm install pg-ultra

Usage:

Initialize pg-ultra:

const pgUltra = require("pg-ultra");

const db = new pgUltra({
  user: "postgres",
  host: "localhost",
  database: "testdb",
  password: "yourpassword",
  port: 5432,
});

//check
const fn = async () => {
  const connect = db.connection();
  console.log(connect);
};
fn();

/// uotput : db is connected

Insert data:

const res = await db.inset("users", {
    name: "jon",
    email: "[email protected]",
})
console.log(res);

///Output:data inset + data

FINDONE:

const data = {
  name: "maruf"
};
const fn=async () => {
    const find = await db.findOne("users", data);
    console.log(find)
}
fn()

find all data:

const fn=async () => {
    const find = await db.AllRead("users");
    console.log(find)
}
fn()

CreateSchema:

const fn=async () => {
    const find = await db.CreateSchema("users", {
        id: pgultra.MakeInt(),
        name: pgultra.MakeText(50),
        is_active: pgultra.MakeBool(),
        created_at: pgultra.MakeDate(),
    })
    console.log(find)
}
fn()