Gathering detailed insights and metrics for @graphile-contrib/pg-order-by-multi-column-index
Gathering detailed insights and metrics for @graphile-contrib/pg-order-by-multi-column-index
Installations
npm install @graphile-contrib/pg-order-by-multi-column-indexDeveloper
graphile-contrib
Developer Guide
BETA
Module System
CommonJS
Min. Node Version
>=10
Typescript Support
No
Node Version
14.17.4
NPM Version
6.14.14
Statistics
8 Stars
46 Commits
2 Forks
3 Watching
2 Branches
5 Contributors
Updated on 01 Jul 2024
Bundle Size
2.75 kB
Minified
1.26 kB
Minified + Gzipped
Languages
JavaScript (96.92%)
Shell (3.08%)
Total Downloads
Cumulative downloads
Total Downloads
73,528
Last day
37.5%
231
Compared to previous day
Last week
3.3%
915
Compared to previous week
Last month
70%
3,242
Compared to previous month
Last year
94.3%
30,618
Compared to previous year
Daily Downloads
Weekly Downloads
Monthly Downloads
Yearly Downloads
Versions
@graphile-contrib/pg-order-by-multi-column-index
This Graphile Engine plugin adds enum values to the orderBy argument on connections, allowing you to order by multi-column indexes.
Requires
postgraphile@^4.1.0orgraphile-build-pg@^4.1.0
NOTE: If you're not using
ignoreIndexes: false, then you probably don't need this plugin.
PostGraphile's ignoreIndexes: false option only exposes the first column of each multi-column index on orderBy. This prevents clients from sending queries with an array of column names/directions that can't make use of the multi-column index. This plugin adds enum values to orderBy that match forward and backward scans of the index.
Example:
1create index on p.person (last_name ASC, first_name ASC);
1{ 2 allPeople(orderBy: LAST_NAME_ASC__FIRST_NAME_ASC) { 3 nodes { 4 id 5 firstName 6 lastName 7 } 8 } 9}
Usage
Append this plugin and the additional orderBy enum values will be added to your schema.
CLI
1yarn add postgraphile 2yarn add @graphile-contrib/pg-order-by-multi-column-index 3npx postgraphile --append-plugins @graphile-contrib/pg-order-by-multi-column-index
Library
1const express = require("express"); 2const { postgraphile } = require("postgraphile"); 3const PgOrderByMultiColumnIndexPlugin = require("@graphile-contrib/pg-order-by-multi-column-index"); 4 5const app = express(); 6 7app.use( 8 postgraphile(process.env.DATABASE_URL, "app_public", { 9 appendPlugins: [PgOrderByMultiColumnIndexPlugin], 10 graphiql: true, 11 }) 12); 13 14app.listen(5000);
No vulnerabilities found.
Reason
no binaries found in the repo
Reason
license file detected
Details
- Info: project has a license file: LICENSE:0
- Info: FSF or OSI recognized license: MIT License: LICENSE:0
Reason
7 existing vulnerabilities detected
Details
- Warn: Project is vulnerable to: GHSA-grv7-fg5c-xmjg
- Warn: Project is vulnerable to: GHSA-3xgq-45jj-v275
- Warn: Project is vulnerable to: GHSA-w573-4hg7-7wgq
- Warn: Project is vulnerable to: GHSA-8cf7-32gw-wr33
- Warn: Project is vulnerable to: GHSA-hjrf-2m68-5959
- Warn: Project is vulnerable to: GHSA-qwph-4952-7xr6
- Warn: Project is vulnerable to: GHSA-952p-6rrq-rcjv
Reason
Found 1/11 approved changesets -- score normalized to 0
Reason
0 commit(s) and 0 issue activity found in the last 90 days -- score normalized to 0
Reason
no effort to earn an OpenSSF best practices badge detected
Reason
security policy file not detected
Details
- Warn: no security policy file detected
- Warn: no security file to analyze
- Warn: no security file to analyze
- Warn: no security file to analyze
Reason
project is not fuzzed
Details
- Warn: no fuzzer integrations found
Reason
branch protection not enabled on development/release branches
Details
- Warn: branch protection not enabled for branch 'master'
Reason
SAST tool is not run on all commits -- score normalized to 0
Details
- Warn: 0 commits out of 20 are checked with a SAST tool
Score
2.1
/10
Last Scanned on 2024-11-18
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