Application-defined functions/UDF in LibSQL
Is there a way to define JS functions within libsql's sqlite database just like in better-sqlite? (see ref below)
db.function('add2', (a, b) => a + b);
db.prepare('SELECT add2(?, ?)').pluck().get(12, 4); // => 16
db.prepare('SELECT add2(?, ?)').pluck().get('foo', 'bar'); // => "foobar"
db.prepare('SELECT add2(?, ?, ?)').pluck().get(12, 4, 18); // => Error: wrong number of arguments
https://github.com/WiseLibs/better-sqlite3/blob/master/docs/api.md#functionname-options-function---this
db.function('add2', (a, b) => a + b);
db.prepare('SELECT add2(?, ?)').pluck().get(12, 4); // => 16
db.prepare('SELECT add2(?, ?)').pluck().get('foo', 'bar'); // => "foobar"
db.prepare('SELECT add2(?, ?, ?)').pluck().get(12, 4, 18); // => Error: wrong number of arguments
https://github.com/WiseLibs/better-sqlite3/blob/master/docs/api.md#functionname-options-function---this
GitHub
The fastest and simplest library for SQLite3 in Node.js. - WiseLibs/better-sqlite3
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,959Members
Resources
Similar Threads
Was this page helpful?
