npmpackage.info

Gathering detailed insights and metrics for pg-range

Other packages similar to pg-range

pg-range-parser

1.0.0

Parses postgres range types

pg-range-datepicker

1.0.0

A datepicker (single or range) for your angular app.

pg-ballistics

1.0.1

Ballistics JavaScript Library (for calculating range cards)

pg-numrange

1.0.2

Built to help parse, work with, and create PostgreSQL compatible range strings.

pg-range

node-postgres plugin to parse tsrange, tstzrange, daterange columns

1.1.2

MIT

JavaScript

4.12 kB

537,217 2.3

Installations

npm install pg-range

Developer Guide

BETA

Typescript

Yes

Module System

CommonJS

Node Version

18.9.0

NPM Version

8.19.1 Score

72.2

Supply Chain

88.5

Quality

75.3

Maintenance

100

Vulnerability

98.9

License

Pull Requests

Open

1

Total

8

Closed

2

Merged

5

Issues

Open

0

Total

8

Closed

8

Releases

Unable to fetch releases

Contributors

Unable to fetch Contributors

View All 4 Contributors

Languages

JavaScript

Makefile

JavaScript (98.66%)

Makefile (1.34%)

Love this project? Help keep it running — sponsor us today! 🚀

Developer

WhoopInc

Download Statistics

Total Downloads

537,217

Last Day

354

Last Week

2,207

Last Month

9,951

Last Year

109,988

GitHub Statistics

MIT License

26 Stars

31 Commits

7 Forks

30 Watchers

2 Branches

4 Contributors

Updated on Apr 30, 2024

Bundle Size

10.32 kB

Minified

4.12 kB

Minified + Gzipped

Bundlephobia

Maintainers

Package Meta Information

Latest Version

1.1.2

Package Id

pg-range@1.1.2

Unpacked Size

6.69 kB

Size

3.13 kB

File Count

NPM Version

8.19.1

Node Version

18.9.0

Total Downloads

Cumulative downloads

Total Downloads

537,217

Last Day

-8.5%

354

Compared to previous day

Last Week

-10.6%

2,207

Compared to previous week

Last Month

47%

9,951

Compared to previous month

Last Year

-5.5%

109,988

Compared to previous year

Daily Downloads

Weekly Downloads

Monthly Downloads

Yearly Downloads

Dependencies

@types/strange lodash.partial strange

Dev Dependencies

chai mocha pg sinon sinon-chai sinon-test

node-pg-range

Range type support for node-postgres.

Usage

Install pg-range into your existing pg adapter:

1var pg = require("pg");
2require("pg-range").install(pg);

Then make a query that returns range objects!

1client.query("SELECT range FROM table", function (result) {
2  // result.range = {
3  //   begin: Thu Mar 26 2014 17:57:02 GMT-0400 (EDT),
4  //   end: Thu Mar 27 2014 17:57:02 GMT-0400 (EDT),
5  //   bounds: '[)'
6  // }
7});

Or make a query that inserts range objects:

1var Range = require("pg-range").Range;
2
3client.query("INSERT INTO table VALUES ($1)", [Range(1, 3)]);

See the Postgres "Range Types" documentation for details.

Range objects

pg-range uses stRange.js, a JavaScript range library, to provide a Range class with useful methods, like contains and intersects. See the stRange.js API documentation.

Values of (PostgreSQL) type

int4range
int8range
numrange
tsrange
tstzrange
daterange

will be automatically parsed into instances of Range when the pg-range type adapter is installed.

Warning: When constructing range objects for use in queries, use the pg-range Range constructor as shown above, and not raw stRange.js Range objects. Raw stRange.js objects do not provide a toPostgres method, and will not properly serialize date ranges and empty ranges in queries!

No vulnerabilities found.

10

Binary-Artifacts

Determines if the project has generated executable (binary) artifacts in the source repository.

10

License

Determines if the project has defined a license.

3

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

1

Code-Review

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

0

Maintained

Determines if the project is "actively maintained".

0

CII-Best-Practices

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

0

Security-Policy

Determines if the project has published a security policy.

0

Fuzzing

Determines if the project uses fuzzing.

0

Branch-Protection

Determines if the default and release branches are protected with GitHub's branch protection settings.

0

SAST

Determines if the project uses static code analysis.

Score

2.3

/10

Last Scanned on 2025-02-10

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.

Learn More