Security News
New axobject-query Maintainer Faces Backlash Over Controversial Decision to Support Legacy Node.js Versions
A JavaScript library maintainer is under fire after merging a controversial PR to support legacy versions of Node.js.
postgraphile-core
Advanced tools
Changelog
Readme
This module is the compatibility between the web layer of
PostGraphile and the GraphQL schema
built with Graphile Engine. It loads the relevant graphile-build-pg
plugins
and augments the inflector depending on the PostGraphile options provided.
To help us develop this software sustainably under the MIT license, we ask all individuals and businesses that use it to help support its ongoing maintenance and development via sponsorship.
And please give some love to our featured sponsors 🤩:
Chad Furman | Timescale |
Unless you want to use the low-level API you probably want to go to the PostGraphile (previously 'PostGraphQL') repository instead: https://github.com/graphile/postgraphile
It's suitable to use this module in your own application, but please be aware you
need to bring your own security in the form of an authenticated pgClient
(see
below).
For more information about PostGraphile and Graphile Engine please see the documentation at graphile.org.
createPostGraphileSchema(pgConfig, schemas, options)
This is the function you're most likely to use in production, it will return
a promise to a GraphQL schema. You are responsible in for implementing
security by passing a pre-authenticated pgClient
inside the GraphQL
context
when you resolve a GraphQL query or mutation.
Example:
const schema = await createPostGraphileSchema(
process.env.DATABASE_URL,
["users_schema", "posts_schema"],
{
dynamicJson: true,
pgJwtSecret: process.env.JWT_SECRET,
pgJwtTypeIdentifier: "users_schema.jwt_type",
}
);
Full example:
const { createPostGraphileSchema } = require("postgraphile-core");
const { graphql } = require("graphql");
const pg = require("pg");
// Create a postgres pool for efficiency
const pgPool = new pg.Pool({
connectionString: process.env.DATABASE_URL,
});
async function runQuery(query, variables) {
// Generate our schema using the default plugins against DATABASE_URL,
// introspecting the two schemas specified with the options provided.
//
// Normally for performance you'd only do this once for your entire
// application run, not once per query as it is here.
const schema = await createPostGraphileSchema(
process.env.DATABASE_URL,
["app_public"],
{
dynamicJson: true,
pgJwtSecret: process.env.JWT_SECRET,
pgJwtTypeIdentifier: "users_schema.jwt_type",
}
);
// Fetch a postgres client from the pool
const pgClient = await pgPool.connect();
// Start a transaction so we can apply settings local to the transaction
await pgClient.query("begin");
try {
// The following statement is equivalent to (but faster than):
// await pgClient.query("set local role to 'postgraphile_user'");
// await pgClient.query("set local jwt.claims.user_id to '27'");
await pgClient.query(`select
set_config('role', 'postgraphile_user', true),
set_config('jwt.claims.user_id', '27', true)
`);
return await graphql(
schema,
query,
null,
/* CONTEXT > */ {
pgClient: pgClient,
} /* < CONTEXT */,
variables
);
} finally {
// commit the transaction (or rollback if there was an error) to clear the local settings
await pgClient.query("commit");
// Release the pgClient back to the pool.
await pgClient.release();
}
}
// Normally you'd execute a query in response to an HTTP request or similar
runQuery(
// This query obviously depends on your database schema
"query MyQuery { allPosts { nodes { id, title, author: userByAuthorId { username } } } }"
)
.then(result => {
console.dir(result);
pgPool.end();
})
.catch(e => {
console.error(e);
process.exit(1);
});
To see how this works in a real application, check out
withPostGraphileContext
in
PostGraphile
watchPostGraphileSchema(pgConfig, schemas, options, onNewSchema)
This function is useful in development; it returns a promise that resolves to a
release
function that you can call to stop watching. The onNewSchema
callback will be called every time a new schema is generated, and it is
guaranteed to be called before the returned promise resolves. Other than the
additional onNewSchema
option, the options are identical to that of
createPostGraphileSchema
above.
FAQs
[![Discord chat room](http
The npm package postgraphile-core receives a total of 19,675 weekly downloads. As such, postgraphile-core popularity was classified as popular.
We found that postgraphile-core demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
A JavaScript library maintainer is under fire after merging a controversial PR to support legacy versions of Node.js.
Security News
Results from the 2023 State of JavaScript Survey highlight key trends, including Vite's dominance, rising TypeScript adoption, and the enduring popularity of React. Discover more insights on developer preferences and technology usage.
Security News
The US Justice Department has penalized two consulting firms $11.3 million for failing to meet cybersecurity requirements on federally funded projects, emphasizing strict enforcement to protect sensitive government data.