Category "sqlite"

Cannot find module '/home/container/node_modules/sqlite3/lib/binding/napi-v3-linux-x64/node_sqlite3.node'

Everything's running perfectly throught cmd on my pc but when i host it on my host servers i have this error: `:/home/container$ npm start knexfile.js Starting

Using asyncio extension with SQLite backend broken by version upgrade

An upgrade from SQLAlchemy version 1.4.0b2 to 1.4.0b3 results in the following error when attempting to connect to a SQLite engine, using the asyncio extension.

SQLite python not returning false on an empty select

Hi having some issues with SQLite3 been having a good time with it up until now but recently ran into some issues when I was trying to check if a select stateme

How to fix Cannot find module '@vscode/sqlite3' when running npx knex migrate:make test

When npx knex migrate:make executed this error pop up Using environment: development Knex: run $ npm install sqlite3 --save Cannot find module '@vscode/sqlite3'

SQLite impute missing values by mean for every group

I have an SQLite table as shown below. students grades Nick 34 Nick 42 Nick 86 Nick Null John 38 John 12 John 74 John Null Colin 87 Colin 23 Colin 46 Colin 42

Sqlite - Return rows where some values are different

I have a large table a SQLite database of student exam results. Students often resit failed exams and subsequently pass them as shown with student 10001 below.

Nodejs and SQLite how create multiple tables?

I have question about creating multiple tables in one DB. I try to run for 2 tables, but seems after the first db.run(CREATE TABLE , second db.run(CREATE TABLE

How to combine multiple commands output in the one varialble in shell script?

I'm using the following script to get the data of one of the variables from the database file #!/bin/bash sqlite3 pdu.db <<'END_SQL' .timeout 2000 SELECT

Locking thread and creating new cursors not resolving sqlite3 "recursive use of cursors not allowed"

I am trying to make a simple flask web server that presents two graphs of data using matplotlib from a DHT22 sensor stored in a sqlite3 database. The code is ba

'more placeholders than values' when inserting into sqlite database

I am trying to dynamically insert into a sqlite database from python. Here is my code: for person in people: db.execute("INSERT INTO students (first, middle, la

I can't list disk encrypted on osquery 5.0.1

I have this query to list all machine without disk encrypted in my pack. SELECT m.device, m.device_alias, m.path, m.type, de.encryption_status FROM mounts m L

SQLite3 database or disk is full on csv imports

This issue has been discussed on a number of threads, but none of the proposals seem to apply to my case. I have a very large sqlite database (4Tb). I am trying

SQLSTATE[HY000]: General error: 1 table posts has no column named *

I'm actually new to Laravel and I'm trying to build a basic social network with this Framework. For this project, I created a page called post which users can a

SQLITE3 + Python (I need to ask bank 1 table if its data exists in bank 2 table)

I have a doubt about python and sqlite3. import sqlite3 conna= sqlite3.connect('db_a') a = conna.cursor() connb= sqlite3.connect('db_b') b = conna.cursor() I

SQLite string search in rows then insert string into new rows with values of the same row last column

I want to provide a query to my database that will search if a string exists in Column2(site_id) then put that string in a new table with the value of its befor

showing 1 data from Sqlflite flutter

So i want to make a delete button, so the user could delete those data according to the data they choose to see. Each time the data on the sqflite were added th

Column Inheritance for Independent ORM Mapper Classes In SQL Alchemy

I am trying to replicate the following SQLite CREATE TABLE statements using the declarative ORM mapper classes in SQLALchemy. CREATE TABLE IF NOT EXISTS questio

Airflow without sudo access?

in my virtual env on azure VM, i ran pip3 install apache-airflow when i started airflow db init i received File "/home/shivamanand/myenv/lib/python3.7/site-pack

I want to assign value of logged in user's user_company to the user_company field of the newly created user

When a user creates a user record for a client, the new client should should have the current logged in user's User.user_company value. In the problem here, I w

Convert from Prodigy's JSONL format for labeled NER to spaCy's training format?

I am new to Prodigy and spaCy as well as CLI coding. I'd like to use Prodigy to label my data for an NER model, and then use spaCy in python to create models.