The fastest and simplest library for SQLite3 in Node.js.
This report summarizes scanner evidence for WiseLibs/better-sqlite3, a JavaScript project with 7,539 GitHub stars. SynthScan examined 25,950 lines of code across 110 source files, recording 41 pattern matches distributed across 1 syntactic category. The legacy adjusted pattern signal is 1.6 (Low pattern signal); it is not an authorship estimate.
Use the findings to ask whether maintainers can explain intent, verify dependencies, simplify unnecessary scaffolding, and focus review effort. Risk Payload v1 adds ownership, supply-chain, over-engineering, and review-effort vectors when available. These are prompts for human verification, not probabilities, security findings, or measured maintenance costs.
Use each vector to guide manual verification of the underlying findings.
Payload schema: 1.0.0 · Engine: 2.0.0 · Scoring: heuristic-density-v1 · Scan date: 2026-10-31.
Can maintainers explain intent, assumptions, and trade-offs? 41 finding(s).
Are imports declared and package/API names verified? 0 finding(s).
Are wrappers, guards, and repeated structures necessary? 0 finding(s).
Which changes need focused human review? 41 finding(s).
This chart tracks the legacy adjusted pattern score across scan runs. Changes can reflect source changes, scan coverage, or detector/scoring versions; they do not measure AI adoption or prove that a team refactored code. Compare runs only when their scoring versions are compatible. The dashed line tracks the raw pattern-hit count.
Groups findings by configured severity weight. Severity is not a confidence estimate, security rating, or proof that a package is missing. Verify imports against the project's manifests and inspect each finding in its local design context.
This horizontal bar chart shows where configured pattern scores accumulate across directories. Treat the bars as locations to inspect, not as evidence of authorship or code quality. Use the file-level findings to decide whether a directory needs a focused ownership, dependency, complexity, or review check.
The scanner identified 41 distinct pattern matches across 1 syntactic category. Each entry below represents a discrete location in the source code where the engine recorded a detector match to inspect in context. Expand any category row to inspect the individual file paths, line numbers, code snippets, and the lexical context (CODE, COMMENT, or STRING) in which each match was detected.
Reading the findings table: The Severity column indicates the configured finding weight (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — legacy comment-context matches receive a ×1.5 score weight. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier under the legacy scoring model.
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | deps/download.sh | 1 | #!/usr/bin/env bash | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 81 | # define SQLITE_APICALL | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 441 | ** | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 461 | #define SQLITE_CORRUPT 11 /* The database disk image is malformed */ | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 501 | #define SQLITE_ERROR_RETRY (SQLITE_ERROR | (2<<8)) | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 521 | #define SQLITE_IOERR_CLOSE (SQLITE_IOERR | (16<<8)) | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 541 | #define SQLITE_IOERR_CODEC (SQLITE_IOERR | (36<<8)) | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 561 | #define SQLITE_READONLY_DIRECTORY (SQLITE_READONLY | (6<<8)) | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 601 | ** error in future versions of SQLite. | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 1241 | ** </ul> | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 1261 | #define SQLITE_FCNTL_HAS_MOVED 20 | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 2221 | #define SQLITE_CONFIG_HEAP 8 /* void*, int nByte, int min */ | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 2701 | #define SQLITE_DBCONFIG_ENABLE_FKEY 1002 /* int int* */ | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 3501 | ** top-level SQL code. | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 3521 | #define SQLITE_INSERT 18 /* Table Name NULL */ | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 4401 | ** <dd>The maximum depth of recursion for triggers, and the maximum | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 8581 | */ | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 8681 | ** as the first argument to [sqlite3_test_control()]. | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 8701 | #define SQLITE_TESTCTRL_OPTIMIZATIONS 15 | COMMENT |
| LOW | deps/sqlite3/sqlite3.h | 11341 | #define CARRAY_INT32 0 /* Data is 32-bit signed integers */ | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 401 | */ | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 421 | #define sqlite3_close sqlite3_api->close | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 441 | #define sqlite3_column_text sqlite3_api->column_text | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 461 | #define sqlite3_exec sqlite3_api->exec | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 481 | #define sqlite3_open16 sqlite3_api->open16 | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 501 | #define sqlite3_result_value sqlite3_api->result_value | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 521 | #define sqlite3_value_int64 sqlite3_api->value_int64 | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 541 | #define sqlite3_file_control sqlite3_api->file_control | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 561 | #define sqlite3_test_control sqlite3_api->test_control | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 581 | #define sqlite3_log sqlite3_api->log | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 601 | #define sqlite3_stricmp sqlite3_api->stricmp | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 621 | #define sqlite3_value_dup sqlite3_api->value_dup | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 641 | #define sqlite3_prepare16_v3 sqlite3_api->prepare16_v3 | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 661 | #define sqlite3_str_errcode sqlite3_api->str_errcode | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 681 | #define sqlite3_free_filename sqlite3_api->free_filename | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 701 | #endif | COMMENT |
| LOW | deps/sqlite3/sqlite3ext.h | 721 | #define sqlite3_carray_bind_v2 sqlite3_api->carray_bind_v2 | COMMENT |
| LOW | src/better_sqlite3.cpp | 1 | #include <cassert> | COMMENT |
| LOW | src/better_sqlite3.cpp | 21 | COMMENT | |
| LOW | src/util/macros.cpp | 1 | #define NODE_ARGUMENTS const Napi::CallbackInfo& | COMMENT |
| LOW | src/util/macros.cpp | 61 | #define REQUIRE_STATEMENT_NOT_LOCKED(stmt) \ | COMMENT |