Cannot insert empty buffer (it becomes NULL)

[Prinzhorn]

Similar to #11

My NOT NULL constraint is failing for empty BLOB.

better-sqlite3@7.4.1
Node v14.17.0

const Database = require('better-sqlite3');
const db = new Database(':memory:');

db.exec('CREATE TABLE data (contents BLOB)');
db.prepare('INSERT INTO data (contents) VALUES (?)').run(new Uint8Array(0));
console.log(db.prepare('SELECT * FROM data').all());

[ { contents: null } ]

Related

ericsink/SQLitePCL.raw@e324598
dotnet/efcore#17494 (comment)
https://github.com/aspnet/Microsoft.Data.Sqlite/pull/208/files
https://sqlite.org/forum/forumpost/5bae43cbd77fc654?t=h
https://www.mail-archive.com/sqlite-users@mailinglists.sqlite.org/msg35366.html

Also what is it with SQLite forums and "The author has deleted this message."....

[Prinzhorn]

For now I'm working around it by binding an empty string when the buffer is empty

stmt.run({
    content: content.length === 0 ? '' : content,
});

[JoshuaWise]

It appears this bug only occurs in newer version of node, because they changed how their C++ API works. Oh well.

This is fixed in v7.4.3.

[Prinzhorn]

Thanks!