instead of writing plain SQL you should use an ORM like drizzle. From there it's pretty easy to init your database like you want to:

// Make sure to install the 'pg' package 
import { drizzle } from 'drizzle-orm/node-postgres';

const db = drizzle(process.env.DATABASE_URL);
 
const result = await db.execute('select 1');

by password which password did you mean?

the one in db > password: "p@ss",

the password that you need to connect your DB?

yes!

why would you need to clone that password?

i have console log, i logged user on db and client they both logged the write user name
when I tried the same with Password
db logged it correctly
client logged null

im just following a tutorial .. im not sure why they did that

user would be public but passworld is a private one

don't just follow - unless you are not sure what you are gonna do

there is nothing I can assume you are gonna do with the password

Just to connect to the database
i tried client.connect(); it failed

password was not a string, after looking into it, it turned out to be null

do you really create db instance in this way or do you use env variables?

its exported from another file

import { Client } from 'pg';
const db = new Client({
    user: 'user1',
    host: 'localhost',
    database: 'dbName',
    password: "p@ss",
    port: 1234,
});
export default db ;

then imported in the new file

trying to clone it on const client then connect to the database

I just meant about password

do you have a string or do you import from env?

oh just a string

I'll look into it, but Im just learning next and react for the first time, i just need to learn the basics

wdym by "clone"?

Than you should start by learning SQL

im doing the tutorial for nextJS https://nextjs.org/learn/dashboard-app/setting-up-your-database

cool

there is a file the seeds the database just to so we can have data to work with through out the tutorial, appearntly pg has been updated so the files are no longer working

I don't see anything there that says "clone the password". Instead I see a lot of using env files, that you don't have 🤔

seeds the databse? do u mean filling out the config for the db object?

original code was
after importing db
const client = await db.connect();
but that is no longer working as client is always undefined

why is it always undefined?

so i kept trying to figure out why and what has changed so i can update my code

do u get any errors

a bit confusing indeed

just undefined when u call client.query(); I get error yes .. it saied somethin bout calling query from undefined

the file has const client = await db.connect(); that is no longer working, i assume it clones db but I can be wrong

it doesnt clone anything, the word clone is not correct here

db.connect just returns an instance of the db after connect has finishede

u need to check the documentation of pg

there we go

check this

everything u need is on this page

and store everything like db logins and else in env files

everything that is dynamic and need to be protected

so in your case, u will have a object in a singleton that always returns the client after client.connect has finished

That’s just creates a connection to the database with the preconfigured object (db) that contains the credentials

yes i get that, but its no longer working for some reason

do what i told u above

u are probably not calling client.connect in your exported db const

oh yea im trying to understand how do I import data from env file to the script later

its everything automatic

just create a .env file

where ?

in your root

ok

check the tutorial

there should be a section that documents that i think

ohh , im hosting postgress locally, im not using that Vercel's

its not practicle to let other ppl handle ur data anyway

check this and u are good

also i recommend always checking the docs correctly otherwise u will waste a lot of time understanding things

@Asian black bear It seems like you are new in the whole web developement thing. In developement you can't just start by watching a youtube video or ask other people and follow every step the guy in the video does or someone said to you. That works, until you get an error. So start by learning the basics and then one after another. Right now it seems like you are learning React, Nextjs, Typescript, (Libraries), JSX, (Javascript), CSS, HTML.

That's way to much to start. So, start with the basics: Javascript, CSS, HTML. When you know them go in the advanced direction: JSX, React, important Libraries. And then go in the OP stuff like: NextJs and Typescript.

I learned all these stuff from this guy: [Codevolution](https://www.youtube.com/@Codevolution)
Very much recommended.

For the beginning I recommend you, you using his crash course, for the topics I wrote down: https://youtu.be/XIOLqoPHCJ4?feature=shared
Please do it, else you won't make it that long in programming
After this playlist you know the basics of webdevelopement and can start big projects like a ecommerce store with a db connenction

Enjoy the developement journey and best of luck ^^

I have been using web dev for4 years, I just stopped the past two years because I was working on game dev, now Im back, im just new js frameworks

I've finished a react crash course

thanks, I'm not really stuck, i was just wondering after cloing the whole db why password was still null

user was cloned correctly but not the password
I guess i could use db to query instead of client but I was just trying to figure out how things work under the hood