292 questions
1
vote
1
answer
140
views
How to properly include SQLite3 with an Electron, Electron Forge, Sequelizer set-up in production?
I've been trying to set-up a working Electron application using Electron Forge with Sqlite3 and Sequelize. This has worked great up until where I need to actually build and package, and distribute the ...
- 78
-1
votes
1
answer
55
views
I am engaging with Capstone project - prepare online learning system for student and teacher logging
I created my capstone project frontend with Angular.js, and the backend with Node.js and Express. The database was created by sqlite3. I want to update the files in the GitHub repository and use ...
3
votes
0
answers
82
views
WatermelonDB Error: EBUSY: resource busy or locked when switching from LokiJSAdapter to SQLiteAdapter with Node.js
I creted a basic Node.js app with WatermelonDB and LokiJSAdapter and is working fine but when I switched to SQLiteAdapter this error start appering. Any ideas hoe to fix that?
Error: EBUSY: resource ...
- 31
-1
votes
1
answer
66
views
Discord.js | Bot's role reactions post does not continue to work between sessions [closed]
I'm trying to set up a /roles command for my Discord bot. The goal is to have the bot post an embed with some automated self-reactions that correspond to self-assignable roles identified in the embed. ...
- 49
-2
votes
2
answers
87
views
Search nested array of objects in JSON object
I need to make a query to return an entire row on the condition of a substring search. This search must match a column called 'movies' and it is a JSON Object within it, inside this object is an array ...
1
vote
0
answers
19
views
how to use result set of db.all in db.run command that is just next to it. Given these both are in db.serialize()
db.serialize(()=>{
const rightjoinpromise=new Promise((resolve,reject)=>{
db.all(
'select temp_data.colour,temp_data.size,temp_data.price,temp_data.quantity,temp_data....
- 11
0
votes
0
answers
137
views
How to get result from sqlite3 to variable in typescript?
I have a need, for example, to return information about whether the user is blocked, obtained from the database, to the main code. I created a class called Db:
export class Db {
constructor() {
...
0
votes
0
answers
12
views
SQlite3 || How to use return for select in a function [duplicate]
I started learning js relatively recently. I have a function that should return the search result from the SQlite3 table. but because of the asynchrony, it outputs the result before it has found any ...
- 1
0
votes
0
answers
35
views
Using sqlite3 js to replace html text
So I want to put out a WHERE query for this 'code' (row.code) and recieve the row.title from there.
With the row.title I want to use js to replace the 'title.placeholder' text with 'row.title'. For eg....
- 1
0
votes
1
answer
2k
views
Dockerfile for sqlite3 solving the error with better-sqlite3
in my project I need a Dockerfile for sqlite3 because I am using microservices with Kubernetes and Docker and on Windows and MacOS it gave me the same error when installing.
the project uses nodejs ...
- 605
0
votes
1
answer
104
views
Sqlite3 database empty after running migration in javascript
this is db.js
const sqlite3 = require('sqlite3').verbose();
const path = require('path')
const { migrationScript } = require('../db/migrations/migrate');
const WDIR = process.cwd();
const DB_PATH = ...
-3
votes
1
answer
267
views
TypeError: Named parameters can only be passed within plain objects, while trying to handle Sqlite errors using ES6 arrow functions
I have some working code to manipulate a Sqlite database written in this notation (I think ES5?):
try {
const cols = Object.keys(data).join(", ");
const placeholders = Object.keys(...
- 1,425
0
votes
1
answer
80
views
node-sqlite3 running at end of TS
When querying a DB in TS using node-sqlite3 the query happens after everything else.
The docs haven't yielded any answers, though there may be something glaringly obvious that I've missed.
I've ...
- 13
0
votes
0
answers
394
views
No debugger available, can not send 'variables' Node.js error when using vs code
I am currently using a node.js for the first time trying to use it to SELECT in an sqlite3 database code it connects to the database and even makes an array with 9 results which is the number of ...
1
vote
1
answer
735
views
My executable file that i compiled with nexe on NodeJS not works on a different location
Note that i’m using NodeJS v16.16.0
When utilizing nexe to compile my file, everything works as expected until I attempt to change the file location at that point, the program ceases to function. ...
- 11