npmpackage.info

Gathering detailed insights and metrics for extra-sql.web

extra-sql.web - 1.1.12 | npmpackage.info

extra-sql.web

Generates SQL commands for creating tables, inserting data, and performing operations like text search and matching in PostgreSQL databases.

1.1.12

MIT

TypeScript

26.45 kB

3.4

Installations

npm install extra-sql.web

Developer Guide

BETA

Typescript

Yes

Module System

CommonJS, ESM

Node Version

22.14.0

NPM Version

10.9.2 Pull Requests

Open

0

Total

0

Closed

0

Issues

Open

0

Total

0

Closed

0

Releases

Unable to fetch releases

Languages

TypeScript

TypeScript (100%)

Developer

nodef

Download Statistics

Total Downloads

Last Day

Last Week

Last Month

Last Year

GitHub Statistics

MIT License

1 Stars

1 Commits

1 Forks

2 Watchers

3 Branches

1 Contributors

Updated on May 03, 2025

Maintainers

View All 1 Contributors

Package Meta Information

Latest Version

1.1.12

Package Id

extra-sql.web@1.1.12

Unpacked Size

26.45 kB

Size

7.25 kB

File Count

NPM Version

10.9.2

Node Version

22.14.0

Published on

Apr 08, 2025

Total Downloads

Cumulative downloads

Total Downloads

NaN

Last Day

NaN

Compared to previous day

Last Week

NaN

Compared to previous week

Last Month

NaN

Compared to previous month

Last Year

NaN

Compared to previous year

Weekly Downloads

Monthly Downloads

Yearly Downloads

Dev Dependencies

@rollup/plugin-commonjs @rollup/plugin-node-resolve @types/jest @types/node extra-build jest rollup-plugin-cleanup rollup-plugin-dts ts-jest

SQL is designed for managing or stream processing data in an RDBMS. This package provides a set of functions to generate SQL commands for creating tables, inserting data, and performing various operations, including text search and matching, on SQL databases (currently PostgreSQL).

▌ 📦 Node.js, 🌐 Web, 📜 Files, 📰 Docs, 📘 Wiki.

1import * as xsql from 'extra-sql';
2
3xsql.tableExists('food');
4// → SELECT EXISTS (SELECT 1 FROM information_schema.tables WHERE table_name='food');
5
6xsql.setupTable('food', {code: 'TEXT', name: 'TEXT'},
7  [{code: 'F1', name: 'Mango'}, {code: 'F2', name: 'Lychee'}]);
8// → CREATE TABLE IF NOT EXISTS "food" ("code" TEXT, "name" TEXT);
9// → INSERT INTO "food" ("code", "name") VALUES
10// → ($$F1$$, $$Mango$$),
11// → ($$F2$$, $$Lychee$$);
12
13
14xsql.selectTsquery('columns', 'total fat');
15// → SELECT * FROM "columns" WHERE "tsvector" @@ plainto_tsquery('total fat');
16
17xsql.matchTsquery('columns', ['total', 'fat']);
18// → SELECT *, '2'::INT AS "matchTsquery" FROM "columns" WHERE "tsvector" @@ plainto_tsquery('total fat') UNION ALL
19// → SELECT *, '1'::INT AS "matchTsquery" FROM "columns" WHERE "tsvector" @@ plainto_tsquery('total');

Index

Property	Description
createTable	Generate SQL command for CREATE TABLE.
createIndex	Generate SQL command for CREATE INDEX.
createView	Generate SQL command for CREATE VIEW.
insertInto	Generates SQL command for INSERT INTO using an array of values.
setupTable	Generate SQL commands to set up a table (create, insert, index).
tableExists	Generate SQL command to check if a table exists.
selectTsquery	Generate SQL command for SELECT with tsquery.
matchTsquery	Generate SQL query for matching words with tsquery.
insertIntoStream	Generate SQL command for INSERT INTO using a stream of values.
setupTableIndex	Generate SQL commands for setting up table indexes and views.
createTableData	Generate SQL command for creating a table with data.
updateData	Generate SQL command for updating data.
selectData	Generate SQL command for selecting data.
insertIntoData	Generate SQL command for inserting data.
deleteData	Generate SQL command for deleting data.
OPERATORS	Set of operators in SQL. {field}
OPERAND_COUNT	Number of operands used with an SQL operator. {field}

No vulnerabilities found.

10

Dangerous-Workflow

Determines if the project's GitHub Action workflows avoid dangerous patterns.

10

Binary-Artifacts

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

10

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

10

License

Determines if the project has defined a license.

0

Code-Review

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

0

Pinned-Dependencies

Determines if the project has declared and pinned the dependencies of its build process.

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

SAST

Determines if the project uses static code analysis.

0

Token-Permissions

Determines if the project's workflows follow the principle of least privilege.

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.

Score

3.4

/10

Last Scanned on 2025-07-07

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