René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"SQLite bind booleans","articleBody":"### What is the problem this feature will solve?\n\nCurrently, all booleans need to be transformed from `true` to `1` and `false` to `0` to bind them as SQLite parameters.\n\nTrying to use a boolean results in an error:\n\n```\nTypeError: Provided value cannot be bound to SQLite parameter 1.\n\ncode: 'ERR_INVALID_ARG_TYPE'\n```\n\n### What is the feature you are proposing to solve the problem?\n\nSQLite [supports](https://sqlite.org/datatype3.html#boolean_datatype) booleans!  I propose automatically transforming booleans to numbers, in the same way SQLite treats the boolean keywords:\n\n> SQLite does not have a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).\n\n> SQLite recognizes the keywords \"TRUE\" and \"FALSE\", as of version 3.23.0 (2018-04-02) but those keywords are really just alternative spellings for the integer literals 1 and 0 respectively.\n\nPlease note I only propose automatic conversion for boolean parameters to 0 and 1, not the other way around parsing results to booleans.\n\n### What alternatives have you considered?\n\nWriting a wrapper or manually handling the conversion.","author":{"url":"https://github.com/jlarmstrongiv","@type":"Person","name":"jlarmstrongiv"},"datePublished":"2025-04-13T12:23:02Z","url":"https://github.com/nodejs/node/issues/57862"}