Nevertheless Published Mine

    dbdts.db
    TypeScript icon, indicating that this package has built-in type declarations

    3.7.0 • Public • Published

    dbdts.db

    Documentation can be found here

    NPM Downloads NPM Version Discord Server

    Example

    This is a small example of how you would create a database instance and a table with 2 columns with a primary column and a json column, connecting database and doing some operations with it.

    const { Database, Column, Table } = require("dbdts.db")
    
    const db = new Database({ path: "./db.sqlite" })
    
    const table = db.createTable("mytable").addColumns([
        new Column()
        .setName("id")
        .setPrimary(true)
        .setType("TEXT"),
        new Column()
        .setName("json")
        .setType("JSON")
        .setDefault({})
    ])
    
    db.once("ready", () => {
        console.log(`Database is ready!`)
    
        const changes = table.set({
            id: "12345",
            json: {
                swords: 1,
                hammers: 0
            }
        })
    
        console.log(changes)
    
        const results = table.get({
            where: {
                column: "id",
                equals: "12345"
            }
        })
    
        console.log(results)
    
        const deletion = table.delete({
            where: {
                column: "id",
                equals: "12345"
            }
        })
    
        console.log(deletion)
    
        const all = table.all()
    
        console.log(all)
    })
    
    db.connect()

    Creating an API Database:

    const { APIDatabase, Column } = require("dbdts.db")
    
    //You will need to install axios yourself.
    const axios = require("axios")
    
    const db = new APIDatabase({
        port: 3444,
        password: "youshallnotpass"
    })
    
    const table = db.createTable("mytable").addColumns([
        new Column()
        .setName("id")
        .setPrimary(true)
        .setType("TEXT"),
        new Column()
        .setName("json")
        .setType("JSON")
        .setDefault({})
    ])
    
    db.open(async () => {
        console.log(`Database ready!`)
    
        await axios.post(`${db.url}/set`, {
            table: "mytable",
            data: {
                id: "12345",
                json: {
                    swords: 1,
                    hammers: 0
                }
            },
            options: {
                where: {
                    column: "id",
                    equals: "12345"
                }
            }
        }, {
            headers: {
                Authorization: db.options.password
            }
        })
    
        const request = await axios.post(`${db.url}/get`, {
            table: "mytable",
            options: {
                where: {
                    column: "id",
                    equals: "12345"
                }
            }
        }, {
            headers: {
                Authorization: db.options.password
            }
        })
    
        console.log(request.data)
    })

    Setting expiring time to data

    That's right! With the release of v3.5.0, we've finally added the ability to add a expiring duration to data in the database.
    Here's a small example:

    ... // Assuming you got a working database setup of dbdts.db and the variable is defined as db.
    
    db.on('expire', (table, data) => {
        console.log(`Data`, data, 'expired in table', table)
    })
    
    // Set some data as usual to db.
    db.set("sometable", {
        id: 'someid',
        data: {},
        value: 10
    }, {
        where: { column: "id", equals: "someid" }
    })
    
    // The above data will be deleted from the database after 25000ms.
    db.setTimedData('sometable', 'someid', 25000)

    And that's it! Make sure to adapt the example to what you got in your project and remember the id is attached to the table's primary key.

    Install

    npm i dbdts.db

    DownloadsWeekly Downloads

    112

    Version

    3.7.0

    License

    MIT

    Unpacked Size

    147 kB

    Total Files

    47

    Last publish

    Collaborators

    • ruben40000
    • leref