sqlite3
sqlite3 copied to clipboard
The fastest and correct SQLite3 module for Deno runtime
I have this table: ```sql CREATE TABLE producers ( id INT UNIQUE NOT NULL , title TEXT NOT NULL , phone TEXT NOT NULL , address TEXT NOT NULL ,...
Using `jsr:@db/[email protected]`, I'm unable to read values from the DB if they contain a NUL in them (the value is truncated) ```ts import * as sqlite from 'jsr:@db/sqlite' const db...
What is the correct way of iterating over the results one at a time without having to load large dataset in memory? It's giving an error while trying to use...
Is there any particular reason you ship a binary without Unicode (ICU) support? You ship with the full-text search extension, which makes sense - but how is full-text search any...
It would be really nice to have support for Data Change Notification Callbacks, which are implemented in the SQLite C interface by the [sqlite3_update_hook()](https://www.sqlite.org/c3ref/update_hook.html) function. We would like to access...
I'm currently migrating from sql.js to @db/sqlite and have a few questions: 1. Is it possible to export the database as a buffer, like `db.export()` in sql.js? 2. Can I...
This should be the best option to use SQLite in Deno, unfortunately the default SQLiteDialect in Kysely only understands the `better-sqlite3` API. Is it possible to provide a Kysely dialect,...