litdb driver for postgres.js
npm install @litdb/postgreslitdb driver for postgres.js
``sh`
npm install @litdb/postgres
db.ts
`ts
import { connect } from "@litdb/postgres"
export const connection = connect({ hostname, database, user, password })
export const { $, async:db, native:sql } = connection
`
> When needed use sql to access postgres.js native sql function
app.ts
`ts
import { $, db } from "./db"
import { Contact } from "./models"
await db.dropTable(Contact)
await db.createTable(Contact)
await db.insertAll([
new Contact({ name:"John Doe", email:"john@mail.org" }),
new Contact({ name:"Jane Doe", email:"jane@mail.org" }),
])
const janeEmail = 'jane@mail.org'
const jane = await db.one))
// Insert examples
const { lastInsertRowid:bobId } = await db.insert(
new Contact({ name:"Bob", email:"bob@mail.org"}))
const { lastInsertRowid } = await db.exec
INSERT INTO Contact(name,email) VALUES('Jo','jo@doe.org')
const name = 'Alice', email = 'alice@mail.org'
await db.execINSERT INTO Contact(name,email) VALUES (${name}, ${email})
// Typed SQL fragment with named param example
const hasId =