Deno-Keyv-2

Example

SQLite

import { SqliteProvider } from "https://deno.land/x/keyv2/mod.ts";

// This make a new file called `db.sqlite` in your folder.
// The second value is the name of the database. You can name is anything you want :)

const db = new SqliteProvider("db.sqlite", "tablename");

PostgreSQL

import { PostgresProvider } from "https://deno.land/x/keyv2/mod.ts";

const db = new PostgresProvider(
    "tablename",
    "username",
    "database",
    "hostname",
    "password"
);
await db.init();

// Set an object in the database.
//            Key           Value
await db.set("user", { name: "Alex" });
// Data -> 'user': { 'name': 'Alex' }

await db.set("user.gender", "male");
// Data -> 'user': { 'name': 'Alex', 'gender': 'male' }

await db.set("user.age", 33);
// Data -> 'user': { 'name': 'Alex', 'gender': 'male', 'age': 33}

await pg.set("user.children", ["Klaudia", "Ada"]);
// Data -> 'user': {"name":"Alex","gender":"male","age":33,"children":["Klaudia","Ada"]}

// Remove value from key
await db.set("user.name", null);
// Output -> { 'gender': 'male', 'age': 33}

// Getting the data from the database
await db.get("user");
// Output -> { 'name': 'Alex', 'gender': 'male', 'age': 33}

await db.get("user.age");
// Output -> 33

// Remove `user` key
await db.delete("user");
// Output -> `null`

console.log(await pg.all());
// Data -> {
//   user: { name: "Alex" },
//   info: { name: "Alex", gender: "male", age: 33, children: [ "Klaudia", "Ada" ] }
// }