* `DATABASE_URL` *mandatory* a connection string to a PostgresSQL instance. * `KOHR_JSON_SIZE_LIMIT` defaults to `'100mb'`, used to limit the size of JSON data sent to us.

ceymard

@salesway/kohr

Error

Ignore

Warn

License

Maintenance

Miscellaneous

Quality

Supply chain risk

Vulnerability

Admins only

Organization members

Dashboard

<upgradeLink>Upgrade</upgradeLink> to access this feature

About

Blog

Socket CLI

Customers

Socket Dependency Search

Docs

Socket for GitHub

Love

Impersonation Mode Active

Update your browser to the latest version for the best experience.

Your web browser is outdated

Use another browser for the best experience.

Your web browser is unsupported

{{count, number}} commits last two months

{{count, number}} critical severity alert

{{count, number}} critical severity alerts

{{count, number}} dependency vulnerability

{{count, number}} dependency vulnerabilities

{{count, number}} development dependencies

{{count, number}} transitive dependencies

{{count, number}} version published last month

{{count, number}} versions published last month

{{count, number}} version published in last two months

{{count, number}} versions published in last two months

{{count, number}} version published last week

{{count, number}} versions published last week

{{count, number}} version published last year

{{count, number}} versions published last year

Socket undergoes annual SOC2 Type II audits. Socket customers can request a copy of the full SOC2 Type II report.

Allows organization owners and admins to access detailed records of actions taken by members of their organization, complete with timestamps.

Prevent compromised packages from infiltrating your supply chain by monitoring for changes in real-time.

Join our Discord community to get help from Socket engineers and other Socket users.

Compare millions of open source packages on socket.dev

Detect malicious code and risky behavior (e.g. network) in your dependencies using "deep package inspection"

All data is encrypted in transit and at rest using industry standard encryption algorithms.

Get a dedicated Socket account manager and access to Socket’s Customer Success team.

Get dedicated support from Socket engineers via email and Slack.

"Shift left" with the Socket Chrome extension and give intervene early, before developers choose risky or low quality dependencies.

Catch developers using risky dependencies and give them a "speed bump" to encourage good behavior

Install the Socket GitHub app to receive real-time dependency scanning and reports with every pull request.

Integrate Socket into your GitHub SCM to prevent risky dependencies from being installed.

Socket scans for vulnerabilities in your dependencies, including CVEs, security advisories, and more.

Socket supports dependencies in many languages, with most popular ecosystems coming in 2024. We've got you covered no matter what languages you use.

Enforce license policies across your organization

Receive a Microsoft Teams message to the channel of your choice anytime Socket runs a new analysis, has a new finding, or a policy has changed.

Get help migrating from Socket's free plan to Socket's paid plans.

Run Socket on-premises or in your own cloud environment.

Query for any dependency (at any version) across your entire organization

Integrate Socket into your CI/CD pipeline to prevent risky dependencies from being deployed to production.

Analyze an entire project to find supply chain risks

Tag projects to organize and filter your projects

Restrict access based on the roles of individual users within an organization.

Receive a Slack message to the channel of your choice anytime Socket runs a new analysis, has a new finding, or a policy has changed.

Socket is SOC2 Type II compliant and undergoes annual audits.

The Socket CLI allows teams to prevent risky dependencies from being installed, and to get dependency insights from the command line.

Socket supports SAML SSO for single sign-on and identity management.

Integrate Socket into your VS Code IDE to prevent risky dependencies from being installed.

Get a POST request anytime Socket runs a new analysis, has a new finding, or a policy has changed.

Socket will analyzed your SBOMs up to a maximum number of dependencies.

API that allows you to analyze a project, lookup package scores and alerts, and more.

Create API tokens to authenticate with the Socket API and CLI.

The number of developers in your team. A developer is someone who made a commit to your organization's repositories scanned by Socket in the past month.

Use Socket to protect your private repositories.

Socket is always free for open source projects.

Socket retains all reporting data for 3 months, 1 year, or a custom term of your choice.

Access the threat feed that powers Socket.

Unlimited scale, self-hosting, and priority support for large teams.

For open-source projects, individuals, and small teams.

For growing teams with enhanced scale, security, and support.

There is a package with a similar name that is downloaded much more often.

There are packages with similar names that are downloaded much more often.

This may not be the package you want!

Instance

Alert Locations

Package

The {{ecosystem}} package {{- packageName}} receives a total of <strong>{{numWeeklyDownloadCount, number}}</strong> weekly downloads. As such, {{- packageName}} popularity was classified as <strong>{{popularity}}</strong>.

Is {{- packageName}} popular?

Is {{- packageName}} safe to use?

Is {{- packageName}} well maintained?

What is {{- packageName}}?

{{packageDescription}}Version: {{versionString}} was published by {{publisherName}}. Start using Socket to analyze {{- packageName}} and its {{dependencyCount, number}} dependencies to secure your app from supply chain attacks.

Sorry, it seems this package was removed from the registry

Package was removed

This package version has been unpublished, mostly likely due to security reasons

Package version was removed

Provide a detailed description of the malware...

Socket fights vulnerabilities and provides visibility, defense-in-depth, and proactive supply chain protection for JavaScript, Python, and Go dependencies.

Socket - Secure your dependencies. Ship with confidence.

Compare versions

{{- packageName}} - npm Package Compare versions

var __awaiter = (this && this.__awaiter) || function (thisArg, _arguments, P, generator) {

    return new (P || (P = Promise))(function (resolve, reject) {

        function fulfilled(value) { try { step(generator.next(value)); } catch (e) { reject(e); } }

        function rejected(value) { try { step(generator["throw"](value)); } catch (e) { reject(e); } }

        function step(result) { result.done ? resolve(result.value) : new P(function (resolve) { resolve(result.value); }).then(fulfilled, rejected); }

        step((generator = generator.apply(thisArg, _arguments || [])).next());

Object.defineProperty(exports, "__esModule", { value: true });

const database_1 = require("./database");

const functions_1 = require("./functions");

const postgres_1 = require("./postgres");

const { RequireAuthenticated } = require('./middleware');

    return __awaiter(this, void 0, void 0, function* () {

        const c = yield database_1.db.getNewConnection();

		coalesce(array_agg(kcu.column_name::text) filter (where kcu.column_name is not null), '{}') "columns"

		LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc

				ON tc.table_catalog = t.table_catalog

				AND tc.constraint_type = 'PRIMARY KEY'

		LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu

				ON kcu.table_catalog = tc.table_catalog

				AND kcu.table_schema = tc.table_schema

				AND kcu.constraint_name = tc.constraint_name

	WHERE   t.table_schema NOT IN ('pg_catalog', 'information_schema')

	t.table_catalog, t.table_schema, t.table_name

postgres_1.augmentDialect(exports.sql.dialect);

            ctx.body = { error: e, message: e.message, user: ctx.state.user };

// All queries inside here use a database connection

        const args = Object.assign({}, ctx.request.body, ctx.request.query);

        if (typeof args.canal !== 'string') {

            ctx.body = { error: 'missing canal' };

        args.level = parseInt(args.level || 10);

        args.message = args.message || '';

        yield ctx.pg.query(`INSERT INTO logging.logs(level, canal, message, payload)

            args.level, args.canal, args.message, args.payload

        const args = ctx.request.payload;

            res = yield ctx.pg.run(ctx.params.name, ...args);

            res = yield ctx.pg.run(ctx.params.name, args);

 * Schema informations, used by admin to build a basic interface around

exports.rt.get('/model_infos', RequireAuthenticated, function (ctx) {

			from INFORMATION_SCHEMA.COLUMNS where table_schema = 'public'

                tables[l.table_name] = [];

            tables[l.table_name].push(l);

                return a.ordinal_position > b.ordinal_position ? 1 :

                    a.ordinal_position < b.ordinal_position ? -1 : 0;

                item_count: (yield ctx.pg.query(`SELECT COUNT(*) as cnt FROM "${x}"`)).rows[0].cnt,

exports.rt.get('/query', RequireAuthenticated, function Query(ctx) {

        let query = Object.assign({}, ctx.request.body, ctx.request.query);

        ctx.body = (yield ctx.pg.query(query.query, query.values)).rows;

/////////////////////////////////////////////////////////////////////////////////////////

        throw new Error('invalid PK length');

    for (var i = 0; i < vals.length; i++) {

exports.rt.get('/model/:table/:id', RequireAuthenticated, function (ctx) {

        const query = exports.sql.build({

            condition: getCondition(ctx.params.table, ctx.params.id)

        // console.log(query.query, query.values)

        let res = yield ctx.pg.query(query.query, query.values);

            ctx.body = { error: "not found" };

exports.rt.merge('/model/:table/:id', RequireAuthenticated, function UpdateSingle(ctx) {

        let obj = Object.assign({}, ctx.request.body, ctx.request.query);

            if (obj[x].constructor === Object) {

                obj.$mergeJson = obj.$mergeJson || {};

                obj.$mergeJson[x] = obj[x];

            condition: getCondition(ctx.params.table, ctx.params.id),

 * Sessions are linked to specific users. If the user is dropped,

export declare const fn_logging: Mutation;

export declare const fn_merge_json: void;

export declare const fn_merge_json: Mutation;

export declare const views_auth: Mutation;

export declare const logging_perms: Mutation;

export declare const user_perms: Mutation;

exports.pgcrypto = dmut_1.Mutation.static

    .auto `create extension pgcrypto with schema pgcrypto`;

exports.plv8_ext = dmut_1.Mutation.static

    .down `alter database app reset plv8.start_proc`

    .up `alter database app set plv8.start_proc = 'plv8_init'`;

    .auto `create role "@unauthenticated"`

    .auto `create role "@authenticated"`;

    .auto `create table "logging"."logs" (

  username text not null default current_user,

  level integer not null default 10, -- 10 is info

	username text not null, -- usernames are directly mapped to roles...

	other_roles text[] not null default '{}'::text[],

	auth_provider text default null, -- used with oauth to choose the best method to authenticate the user...

	data jsonb not null default '{}'::jsonb,

	constraint users__primary_key primary key (username)

exports.sessions = dmut_1.Mutation.static.depends(exports.pgcrypto, exports.users)

	username TEXT default null, -- nullable, as we can be anonymous

	hash TEXT NOT NULL UNIQUE default pgcrypto.gen_random_uuid(),

	constraint sessions__primary_key primary key (hash),

	constraint session_user_fkey foreign key (username)

			references users (username) match simple

    .auto `create index session_hash_idx on sessions (hash)`;

exports.triggers = dmut_1.Mutation.static.depends(exports.pgcrypto, exports.users)

    .auto `create function salt_password_if_needed() returns trigger as $body$

      NEW.password := pgcrypto.crypt(NEW.password, pgcrypto.gen_salt('bf'));

    .auto `create function create_role_if_needed(username text) returns void as $body$

		@@ -135,3 +135,2 @@ "use strict";
		const args = ctx.request.payload;
		console.log(args);
		var res = {};
		@@ -138,0 +137,0 @@ if (Array.isArray(args))

		@@ -182,4 +182,3 @@ "use strict";
		$body$ language sql`;
		exports.fn_merge_json = dmut_1.Mutation.depends(exports.plv8_ext)
		.fn(function mergeJson(...a) {
		function mergeJson(...a) {
		function _merge(o1, o2) {
		@@ -201,3 +200,6 @@ for (var x in o2) {
		return res;
		}, 'json');
		}
		exports.fn_merge_json = dmut_1.Mutation.depends(exports.plv8_ext)
		.fn(mergeJson, 'json', 'json')
		.fn(mergeJson, 'jsonb', 'jsonb');
		exports.views_auth = dmut_1.Mutation.depends(exports.users)
		@@ -204,0 +206,0 @@ .auto `create view users_public as

		{
		"name": "@salesway/kohr",
		"version": "0.6.0",
		"version": "0.6.1",
		"main": "./lib/index.js",
		@@ -5,0 +5,0 @@ "types": "./lib/index.d.ts",

		@@ -107,3 +107,2 @@ import * as koa from 'koa'


		/**
		@@ -152,3 +151,2 @@ *
		const args = ctx.request.payload
		console.log(args)
		var res = {}
		@@ -155,0 +153,0 @@ if (Array.isArray(args))

		@@ -213,4 +213,3 @@ import {Mutation} from 'dmut'

		export const fn_merge_json = Mutation.depends(plv8_ext)
		.fn(function mergeJson(...a: any[]): any {
		function mergeJson(...a: any[]): any {
		function _merge(o1: any, o2: any) {
		@@ -234,5 +233,9 @@ for (var x in o2) {
		return res
		}, 'json')
		}

		export const fn_merge_json = Mutation.depends(plv8_ext)
		.fn(mergeJson, 'json', 'json')
		.fn(mergeJson, 'jsonb', 'jsonb')


		export const views_auth = Mutation.depends(users)
		@@ -239,0 +242,0 @@ .auto `create view users_public as

Fixed alerts

Improved metrics

Worsened metrics

		@@ -15,5 +15,5 @@ import { Mutation } from 'dmut';
		export declare const fn_logging: Mutation;
		export declare const fn_merge_json: void;
		export declare const fn_merge_json: Mutation;
		export declare const views_auth: Mutation;
		export declare const logging_perms: Mutation;
		export declare const user_perms: Mutation;