@adtechiumpublic/knex

v0.15.4

A batteries-included SQL query & schema builder for Postgres, MySQL and SQLite3 and the Browser For more information about how to use this package see README

Latest version published 6 years ago

License: MIT

NPM

GitHub

Package Health Score

53 / 100

security
Security review needed
popularity
Small
maintenance
Inactive
community
Active

Explore Similar Packages

Security

Security review needed

All security vulnerabilities belong to production dependencies of direct and indirect packages.

Security and license risk for significant versions

All Versions

Version				Vulnerabilities	License Risk
0.15.4	\|	07/2018	Popular	0 C 0 H 0 M 0 L	0 H 0 M 0 L
0.13.0	\|	03/2018		0 C 0 H 0 M 0 L	0 H 0 M 0 L

License

MIT

Security Policy

Is your project affected by vulnerabilities?

Scan your projects for vulnerabilities. Fix quickly with automated fixes. Get started with Snyk for free.

Get started free

Popularity

Small

Weekly Downloads (18)

GitHub Stars: 19.3K
Forks: 2.12K
Contributors: 440

Direct Usage Popularity

The npm package @adtechiumpublic/knex receives a total of 18 downloads a week. As such, we scored @adtechiumpublic/knex popularity level to be Small.

Based on project statistics from the GitHub repository for the npm package @adtechiumpublic/knex, we found that it has been starred 19,303 times.

Downloads are calculated as moving averages for a period of the last 12 months, excluding weekends and known missing data points.

Community

Active

Readme.md: Yes
Contributing.md: Yes
Code of Conduct: No
Contributors: 440
Funding: No

A good and healthy external contribution signal for @adtechiumpublic/knex project, which invites more than one hundred open source maintainers to collaborate on the repository.

We found a way for you to contribute to the project! Looks like @adtechiumpublic/knex is missing a Code of Conduct.

Embed Package Health Score Badge

Maintenance

Inactive

Commit Frequency

Open Issues: 1.02K
Open PR: 135
Last Release: 6 years ago
Last Commit: 6 months ago

Further analysis of the maintenance status of @adtechiumpublic/knex based on released npm versions cadence, the repository activity, and other data points determined that its maintenance is Inactive.

An important project maintenance signal to consider for @adtechiumpublic/knex is that it hasn't seen any new versions released to npm in the past 12 months, and could be considered as a discontinued project, or that which receives low attention from its maintainers.

As a healthy sign for on-going project maintenance, we found that the GitHub repository had at least 1 pull request or issue interacted with by the community.

Keep your project healthy

Check your package.json

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Node.js Compatibility: >=6

Age: 7 years
Dependencies: 16 Direct
Versions: 5
Install Size: 867 kB
Dist-tags: 1
# of Files: 213
Maintainers: 1
TS Typings: No

@adtechiumpublic/knex has more than a single and default latest tag published for the npm package. This means, there may be other tags available for this package, such as next to indicate future releases, or stable to indicate stable releases.

Readme

knex.js

A SQL query builder that is flexible, portable, and fun to use!

A batteries-included, multi-dialect (MSSQL, MySQL, PostgreSQL, SQLite3, Oracle(including Oracle Wallet Authentication)) query builder for Node.js and the Browser, featuring:

Node.js versions 6+ are supported.

Read the full documentation to get started!

For support and questions, join the #bookshelf channel on freenode IRC

For an Object Relational Mapper, see:

To see the SQL that Knex will generate for a given query, see: Knex Query Lab

Examples

We have several examples on the website. Here is the first one to get you started:

var knex = require('knex')({
  dialect: 'sqlite3',
  connection: {
    filename: './data.db'
  }
});

// Create a table
knex.schema.createTable('users', function(table) {
  table.increments('id');
  table.string('user_name');
})

// ...and another
.createTable('accounts', function(table) {
  table.increments('id');
  table.string('account_name');
  table.integer('user_id').unsigned().references('users.id');
})

// Then query the table...
.then(function() {
  return knex.insert({user_name: 'Tim'}).into('users');
})

// ...and using the insert id, insert into the other table.
.then(function(rows) {
  return knex.table('accounts').insert({account_name: 'knex', user_id: rows[0]});
})

// Query both of the rows.
.then(function() {
  return knex('users')
    .join('accounts', 'users.id', 'accounts.user_id')
    .select('users.user_name as user', 'accounts.account_name as account');
})

// .map over the results
.map(function(row) {
  console.log(row);
})

// Finally, add a .catch handler for the promise chain
.catch(function(e) {
  console.error(e);
});

@adtechiumpublic/knex dependencies

babel-runtime bluebird chalk commander debug inherits interpret liftoff lodash minimist mkdirp pg-connection-string tarn tildify uuid v8flags

FAQs

What is @adtechiumpublic/knex?

A batteries-included SQL query & schema builder for Postgres, MySQL and SQLite3 and the Browser. Visit Snyk Advisor to see a full health score report for @adtechiumpublic/knex, including popularity, security, maintenance & community analysis.

Is @adtechiumpublic/knex popular?

The npm package @adtechiumpublic/knex receives a total of 18 weekly downloads. As such, @adtechiumpublic/knex popularity was classified as small. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is @adtechiumpublic/knex well maintained?

We found indications that @adtechiumpublic/knex is an Inactive project. See the full package health analysis to learn more about the package maintenance status.

Is @adtechiumpublic/knex safe to use?

While scanning the latest version of @adtechiumpublic/knex, we found that a security review is needed. A total of 0 vulnerabilities or license issues were detected. See the full security scan results.

Last updated on 16 November-2024, at 00:59 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP

@adtechiumpublic/knex

A batteries-included SQL query & schema builder for Postgres, MySQL and SQLite3 and the Browser For more information about how to use this package see README

Ensure you're using the healthiest npm packages

Package Health Score

Explore Similar Packages

Security

Security and license risk for significant versions

Is your project affected by vulnerabilities?

Popularity

Weekly Downloads (18)

Direct Usage Popularity

Community

Embed Package Health Score Badge

Maintenance

Commit Frequency

Keep your project healthy

Check your package.json

Snyk Vulnerability Scanner

Package

Readme

knex.js

Examples

@adtechiumpublic/knex dependencies

@adtechiumpublic/knex development dependencies

FAQs

What is @adtechiumpublic/knex?

Is @adtechiumpublic/knex popular?

Is @adtechiumpublic/knex well maintained?

Is @adtechiumpublic/knex safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Fix identified vulnerabilities

Monitor for new issues

Package Health Score

Explore Similar Packages

Security and license risk for significant versions

Is your project affected by vulnerabilities?

Weekly Downloads (18)

Direct Usage Popularity

Embed Package Health Score Badge

Commit Frequency

Keep your project healthy

Check your package.json

Snyk Vulnerability Scanner

Readme

knex.js

Examples

@adtechiumpublic/knex dependencies

@adtechiumpublic/knex development dependencies

FAQs

What is @adtechiumpublic/knex?

Is @adtechiumpublic/knex popular?

Is @adtechiumpublic/knex well maintained?

Is @adtechiumpublic/knex safe to use?

Build a secure application checklist

Select a recommended open source package

Scan your app for vulnerabilities

Source Code

Open Source

Container

Config

Fix identified vulnerabilities

Monitor for new issues