sqlite3

sqlite3 copied to clipboard

Error: Native SQLite3 library not found, try installing SQLite3.

5

import { Database } from "https://deno.land/x/[email protected]/mod.ts"; // Open a database export const client = new Database("../tolol.db"); info : deno --version deno 1.23.3 (release, x86_64-unknown-linux-gnu) v8 10.4.132.8 typescript 4.7.4 error message...

bobwatcherx

Invalid FFI pointer type, expected null, integer or BigInt

3

```js import { Database } from "https://deno.land/x/[email protected]/mod.ts"; const db = new Database("./files/dist/northwind.db"); const a = db.query("SELECT * FROM \"Employees\""); console.log(a); db.close(); ``` 

xhyrom

Rewrite for better performance & API

5

Goals: - Optimize for fastapi calls - Take inspiration from `better-sqlite3` (Node.js) API as it is simple and concise Previously:  Now: 

DjDeveloperr

Bundle SQLite3 dynamic library

6

Why does this library not come with a bundled version of the SQLite3 dynamic library? Especially in a system like deno, where the versions and locations of all other dependencies...

FeldrinH

https://www.sqlite.org/backup.html

DjDeveloperr

SQLITE_ENABLE_UPDATE_DELETE_LIMIT does not work on Linux

2

I was testing the same project on Windows and Linux found the Linux version of this module does not support some syntax: ```ts // deno run --allow-all --unstable test.ts import...

BlackGlory

Standardize SQL database interface for TS/JS

1

It's a topic that has been brought up every now and then in the Deno DB community, but as Deno is becoming more stable, supports NPM and Node, and we...

halvardssm

Allow configuring libsqlite location

2

I would like to bundle my own sqlite library, and setting the env variable is not viable. Can I pass it to the Database constructor or another config function?

mxcl

Error: no such table: fsdir

3

Jan05-2039.ts ``` import { Database } from "https://deno.land/x/sqlite3/mod.ts"; const db = new Database(":memory:"); const sqlQuery = Deno.args[0]; const stmt = db.prepare(sqlQuery); const result = stmt.all(); for (const row of result)...

7flash

Permission denied when trying to only allow access to a certain ffi path

1

Hi! I am trying to use this library by passing `--allow-ffi=THING` where `THING` is the value I am passing to `DENO_SQLITE_PATH`. The script fails with the following error ``` error:...

prescientmoon