- Lib add
sudo apt-get update
sudo apt-get install libpq-dev
| DROP TABLE IF EXISTS task_item; | |
| CREATE TABLE "task_item" ( | |
| "id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, | |
| "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, | |
| "updatedAt" DATETIME, | |
| "projectId" INTEGER, | |
| "title" TEXT, | |
| "content" TEXT, | |
| "complete" DATETIME, | |
| "start_date" DATETIME, |
| import { Pool } from "pg"; | |
| const pool = new Pool({ | |
| host: "localhost", | |
| port: 5432, | |
| database: "mydb", | |
| user: "root", | |
| password: "admin" | |
| }); |
| import mysql from "mysql2"; | |
| const pool = mysql.createPool({ | |
| host: 'localhost', | |
| user: 'root', | |
| password: 'admin', | |
| database: 'mydb', | |
| waitForConnections: true, | |
| connectionLimit: 10, | |
| queueLimit: 0 |
| import express from 'express'; | |
| import cookieParser from "cookie-parser"; | |
| import { createClient } from "redis"; | |
| const app = express(); | |
| app.use(express.json()); | |
| app.use(express.urlencoded({ extended: true })); | |
| app.use(cookieParser()); | |
| app.use(express.static('public')); |