npm install

create tables ,

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) UNIQUE,
    password TEXT
);

and 

CREATE TABLE posts (
    id SERIAL PRIMARY KEY,
    userid INT REFERENCES users(id),
    title VARCHAR(100) NOT NULL,
    blog TEXT,
    private BOOLEAN
);