How to use sqlite3 on wrangler3.20.0

Tetrax-10 · 2023-12-14T17:05:51.724Z

I get this error when I try to use sqlite3: ✘ [ERROR] Could not resolve "mock-aws-s3" node_modules/@mapbox/node-pre-gyp/lib/util/s3_setup.js:43:28: 43 │ const AWSMock = require('mock-aws-s3'); I get this for 'aws-sdk', "nock"

T

Tetrax-10OP•12/14/23, 5:07 PM

import sqlite3 from "sqlite3"

const db = new sqlite3.Database("data/your_database.db")

const tableName = "your_table_name"
const searchKey = "9916486"

const query = `SELECT * FROM ${tableName} WHERE row1 = ?`

db.get(query, [searchKey], (err, row) => {
    if (err) {
        console.error(err.message)
    } else {
        if (row) {
            console.log("Result:", row)
        } else {
            console.log("Key not found.")
        }
    }

    db.close()
})

import sqlite3 from "sqlite3"

const db = new sqlite3.Database("data/your_database.db")

const tableName = "your_table_name"
const searchKey = "9916486"

const query = `SELECT * FROM ${tableName} WHERE row1 = ?`

db.get(query, [searchKey], (err, row) => {
    if (err) {
        console.error(err.message)
    } else {
        if (row) {
            console.log("Result:", row)
        } else {
            console.log("Key not found.")
        }
    }

    db.close()
})

import sqlite3 from "sqlite3"

const db = new sqlite3.Database("data/your_database.db")

const tableName = "your_table_name"
const searchKey = "9916486"

const query = `SELECT * FROM ${tableName} WHERE row1 = ?`

db.get(query, [searchKey], (err, row) => {
    if (err) {
        console.error(err.message)
    } else {
        if (row) {
            console.log("Result:", row)
        } else {
            console.log("Key not found.")
        }
    }

    db.close()
})

import sqlite3 from "sqlite3"

const db = new sqlite3.Database("data/your_database.db")

const tableName = "your_table_name"
const searchKey = "9916486"

const query = `SELECT * FROM ${tableName} WHERE row1 = ?`

db.get(query, [searchKey], (err, row) => {
    if (err) {
        console.error(err.message)
    } else {
        if (row) {
            console.log("Result:", row)
        } else {
            console.log("Key not found.")
        }
    }

    db.close()
})

K

kian•12/14/23, 5:08 PM

Is this for a Worker?

K

kian•12/14/23, 5:08 PM

You can't run

sqlite3

sqlite3

sqlite3

sqlite3 in a Worker

T

Tetrax-10OP•12/14/23, 5:19 PM

Yeah workers

T

Tetrax-10OP•12/14/23, 5:19 PM

Is there any other way to use sqlite

T

Tetrax-10OP•12/14/23, 5:19 PM

Or any other database

E

Erisa•12/14/23, 5:24 PM

You can use D1 in Workers which is based off sqlite https://developers.cloudflare.com/d1/get-started/

Get started · Cloudflare D1 docs

This guide will instruct you through:

T

Tetrax-10OP•12/14/23, 5:35 PM

Thx

How to use sqlite3 on wrangler3.20.0

Similar Threads

Similar Threads

Similar Threads