open-index/open-npm huggingface dataset:
npm package: @launchpadlab/renovate-config
Description: Shareable configs for [Renovate](https://renovatebot.com/docs/config-presets/).
Latest version: 1.0.0

# renovate-config

Shareable configs for [Renovate](https://renovatebot.com/docs/config-presets/).

To use in `.renovaterc`:
```json
{
    "extends": ["@launchpadlab"]
}
```
npm package: @launchql/ast
Description: PostgreSQL AST utils
Author: Dan Lynch
Latest version: 13.0.4

# Postgres AST Deparser for Postgres

A pure plpgsql AST toolkit and deparser for PostgreSQL. This is the plpgsql equivalent of https://github.com/pyramation/pgsql-parser for deparsing, which can be used to create ASTs and deparse them back into strings in native Postgres.

Please read our documentation on [github](https://github.com/pyramation/postgres-ast-deparser)
npm package: @launchql/base32
Description: base32
Author: Web, Inc.
Latest version: 0.4.6

# base32 [![Build Status](https://travis-ci.com/pyramation/base32.svg?branch=master)](https://travis-ci.com/pyramation/base32)

RFC4648 Base32 encode/decode in plpgsql

# Usage

```sql
select base32.encode('foo');
-- MZXW6===


select base32.decode('MZXW6===');
-- foo
```

# credits

Thanks to 

https://tools.ietf.org/html/rfc4648

https://www.youtube.com/watch?v=Va8FLD-iuTg

# Development

## start the postgres db process

First you'll want to start the postgres docker (you can also just use `docker-compose up -d`):

```sh
make up
```

## install modules

Install modules

```sh
yarn install
```

## install the Postgres extensions

Now that the postgres process is running, install the extensions:

```sh
make install
```

This basically `ssh`s into the postgres instance with the `packages/` folder mounted as a volume, and installs the bundled sql code as pgxn extensions.

## testing

Testing will load all your latest sql changes and create fresh, populated databases for each sqitch module in `packages/`.

```sh
yarn test:watch
```

## building new modules

Create a new folder in `packages/`

```sh
lql init
```

Then, run a generator:

```sh
lql generate
```

You can also add arguments if you already know what you want to do:

```sh
lql generate schema --schema myschema
lql generate table --schema myschema --table mytable
```

## deploy code as extensions

`cd` into `packages/<module>`, and run `lql package`. This will make an sql file in `packages/<module>/sql/` used for `CREATE EXTENSION` calls to install your sqitch module as an extension.

## recursive deploy

You can also deploy all modules utilizing versioning as sqtich modules. Remove `--createdb` if you already created your db:

```sh
lql deploy awesome-db --yes --recursive --createdb
```
npm package: @launchql/inflection
Description: inflection is a port of the functionality from Ruby on Rails' Active Support Inflection classes into PostgreSQL
Author: Web, Inc.
Latest version: 0.4.7

# inflection [![Build Status](https://travis-ci.com/pyramation/inflection.svg?branch=master)](https://travis-ci.com/pyramation/inflection)

inflection is a port of the functionality from Ruby on Rails' Active Support Inflection classes into PostgreSQL

# Usage

```sql
select inflection.plural( 'child' );
-- children

select inflection.singular( 'children' );
-- child

select inflection.camel( 'message_properties' );
-- messageProperties

select inflection.pascal( 'web acl' );
-- WebAcl

select inflection.underscore( 'WebACL' );
-- web_acl
```

# credits

Thanks to 

https://github.com/dreamerslab/node.inflection


# Development

## start the postgres db process

First you'll want to start the postgres docker (you can also just use `docker-compose up -d`):

```sh
make up
```

## install modules

Install modules

```sh
yarn install
```

## install the Postgres extensions

Now that the postgres process is running, install the extensions:

```sh
make install
```

This basically `ssh`s into the postgres instance with the `packages/` folder mounted as a volume, and installs the bundled sql code as pgxn extensions.

## testing

Testing will load all your latest sql changes and create fresh, populated databases for each sqitch module in `packages/`.

```sh
yarn test:watch
```

## building new modules

Create a new folder in `packages/`

```sh
lql init
```

Then, run a generator:

```sh
lql generate
```

You can also add arguments if you already know what you want to do:

```sh
lql generate schema --schema myschema
lql generate table --schema myschema --table mytable
```

## deploy code as extensions

`cd` into `packages/<module>`, and run `lql package`. This will make an sql file in `packages/<module>/sql/` used for `CREATE EXTENSION` calls to install your sqitch module as an extension.

## recursive deploy

You can also deploy all modules utilizing versioning as sqtich modules. Remove `--createdb` if you already created your db:

```sh
lql deploy awesome-db --yes --recursive --createdb
```