Volodymyr Pavlyshyn
db.function('add2', (a, b) => a + b);
db.prepare('SELECT add2(?, ?)').pluck().get(12, 4); // => 16
Sqllte allow hosted functions and virtual tables. it could be useful for custom logic and synchronisation between different type of storages.
Allso in combination with triggers it is enabler for reactivity features
April 12, 2024