@trenskow/pged NPM

@trenskow/pged

Just a silly little db management and query builder for Postgresql.

Usage

const PGed = require('@trenskow/pged');

const db = new PGed({ /* options (see below) */});

const updatedUser = await db.transaction(async () => {

    await db
        .from('users')
        .where({ id: 12 })
        .update({ username: 'myusername' });
    
    return await db
        .from('users')
        .select('id,username')
        .first()
        .where({
            $or: [{
                username: 'myusername'
            }, {
                id: 12
            }]
        });

});

In the above example we wrap our operations in a transaction, which automatically triggers connection to the Postgresql server if not present. The transaction is automatically committed if no error occurs, and automatically rolled back if an error does occur.

Transactions can be inside transactions - the library will figure out when to commit or roll back.

Options

These options are supported when creating a new PGed instance.

Name	Type	Description	Values	Default
`casing`	`Object`	See below
`casing.db`	`String`	The casing to use in the db.	Any supported by the caseit package.	`snake`
`casing.js`	`String`	The casing to use in js.	Same as above	`camel`

PostgreSQL Connection

To set connection parameters use environment variables or do as below.

const PGed = require('@trenskow/pged');

PGed.pg = { /* Options */ };

const db = new PGed({ /* options */ })

See the pg package for available environment variables and options.

License

See LICENSE.

postgresql query builder

@trenskow/async-event-emitter @trenskow/caseit @trenskow/custom-promise @trenskow/parse pg puqeue

@infinitebrahmanuniverse/nolb-_tre @everything-registry/sub-chunk-932 @zalastax/nolb-_tre

2 months ago

2 months ago

2 months ago

2 months ago

3 months ago

3 months ago

3 months ago

4 months ago

4 months ago

4 months ago

4 months ago

4 months ago

8 months ago

7 months ago

7 months ago

7 months ago

10 months ago

10 months ago

10 months ago

10 months ago

10 months ago

9 months ago

9 months ago

9 months ago

8 months ago

8 months ago

11 months ago

10 months ago

10 months ago

10 months ago

6 months ago

11 months ago

11 months ago

1 year ago

1 year ago

1 year ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

2 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

3 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago

4 years ago