What is the problem this feature will solve?
In current builds of node, it is not possible to perform decimal math with Sqlite, even though it is possible with the Sqlite CLI.
Example with Node
import { DatabaseSync } from "node:sqlite"
const db = new DatabaseSync(":memory:")
const sql = db.createTagStore()
console.log(sql.run`SELECT decimal('1.2')`)returns
console.log(sql.run`SELECT decimal('1.2')`)
^
Error: no such function: decimal
at ModuleJob.run (node:internal/modules/esm/module_job:437:25)
at async node:internal/modules/esm/loader:639:26
at async asyncRunEntryPointWithESMLoader (node:internal/modules/run_main:101:5) {
code: 'ERR_SQLITE_ERROR',
errcode: 1,
errstr: 'SQL logic error'
}
Example with the CLI
sqlite> SELECT decimal('1.2');
┌────────────────┐
│ decimal('1.2') │
├────────────────┤
│ 1.2 │
└────────────────┘What is the feature you are proposing to solve the problem?
I think node should build sqlite with the decimal extension enabled
What is the problem this feature will solve?
In current builds of node, it is not possible to perform decimal math with Sqlite, even though it is possible with the Sqlite CLI.
Example with Node
returns
Example with the CLI
What is the feature you are proposing to solve the problem?
I think node should build sqlite with the decimal extension enabled