sqlite Questions
4
Solved
I'm trying to use https://github.com/andpor/react-native-sqlite-storage for SQLite.
I made a sqlite database and it is pre-populated.
On my react-native project, I put players.db file to /www folde...
Callup asked 12/2, 2019 at 9:48
6
The Problem
There are some problem with maybe my installation of better-sqlite3 because when I try to execute my index.js (click to show it on pastebin) with
node index.js
there is always the s...
Irregular asked 23/6, 2018 at 4:26
4
im very new to sqlite, im using macbook m1, im try to use jupyter notebook to do sql
here is my code
%load_ext sql
import csv, sqlite3
con = sqlite3.connect("socioeconomic.db")
cur = co...
Balboa asked 1/4, 2023 at 21:7
3
I am trying to delete a SQLite database file from my C# application. The same application performs multiple RW queries to the DB by creating and disposing a new connection each time.
When trying to...
Fraction asked 19/1, 2023 at 12:51
2
I have a table storing directory paths (Dirs). These directory rows are referenced by a Files table, using the directory's rowid as a foreign key. When re-indexing directories/files there is the ne...
3
I have Python 3.8 installed alongside SQLite 3.16.2 on Debian 9.12 and I need to upgrade to a newer version of SQLite. I've downloaded and compiled the amalgamation available on the SQLite's site, ...
Ulrikeulster asked 22/6, 2020 at 20:43
3
Solved
When I try to connect my gradle project with sqlite database, I have an error:
Exception in thread "main" java.lang.Error:
java.io.FileNotFoundException: null\lib\tzdb.dat (The system cannot fi...
3
Solved
I'm using Sequelize for a express project I'm working on.
In one query I want to retrieve a concatenated result of two columns.
Like:
SELECT first_name || ' ' || last_name AS full_name FROM table...
Natal asked 15/1, 2017 at 18:14
4
I have this error in my application log:
sqlite3.OperationalError: database or disk is full
As plenty of disk space is available and my SQLite database does not appear to be corrupted (integrity...
Publicize asked 22/5, 2013 at 6:37
9
I created an iPad app on xCode(using PhoneGap) with sqlite plugin, stored data, and then when I want to view the data I stored I couldn't find where I saved it. According to my online research, it ...
Familiar asked 31/8, 2016 at 5:22
6
Solved
I'm building an Android application based on an old Android project.
In my new application I'm using Room. I have to use the same database that is used in the first project.
Furthermore, I've ext...
Minstrel asked 15/7, 2019 at 7:59
11
I'm running Pop!_OS (Ubuntu) 20.04. When I try to add sqlite3 to my dependencies on my nodejs project, I get this wall of warnings:
npm WARN deprecated [email protected]: request has been depr...
4
Solved
Here is my server mcve:
const express = require("express");
const app = express();
const fs = require("fs");
const dbFile = "./sqlite.db";
const exists = fs.existsSyn...
Rollerskate asked 15/10, 2020 at 13:7
2
I have a database of several tables in which the first field is defined as:
'ID' INTEGER NOT NULL UNIQUE ... PRIMARY_KEY('ID')
I do not use the AUTOINCREMENT keyword for any of these tables yet my...
Candicecandid asked 6/8, 2019 at 11:38
9
Solved
The downloads page on www.sqlite.org appears to only have links to the current version, and I would like to get a previous version. I cannot see any obvious links to historical versions on the site...
Sty asked 5/3, 2009 at 15:19
4
Solved
I get the above error for executing the below INSERT-statement. The database file ce.db is in the same directory as my code and I have successfully created the tables therein.
My sqlite version is...
Celadon asked 28/10, 2019 at 4:16
2
Solved
Is it possible to test if extension loading is enabled in SQLite 3 from C interface or using SQL without actually trying to load an extension?
Addend asked 14/9, 2012 at 12:46
12
Solved
If I run multiple threads against my web app I get:
java.sql.SQLException: [SQLITE_BUSY] The database file is locked (database is locked)
at org.sqlite.DB.newSQLException(DB.java:383)
at org.sql...
2
Solved
I create a user model for my Django REST framework. python manage.py makemigrations functions but when I run a migration I get:
return Database.Cursor.execute(self, query) django.db.utils.Operatio...
2
Solved
I have a table in sqlite. I am trying to get the first row of each group. Although there were earlier questions regarding the same. I couldn't find solution in sqlite.
My table looks like this:
...
4
Solved
I saw a similar question on Stack Overflow pertaining to Android, but I was wondering whether I should use backticks (`) or double quotes (") - using Python - to select table names or rowid or...
Departmentalize asked 5/8, 2014 at 14:18
3
I am trying to load a table from an SQLite .db file stored on a local disk. Is there any way to do this in PySpark?
My solution works but not as elegant. I read the table using Pandas though sqlite...
Quince asked 16/8, 2016 at 22:16
9
I'm having trouble with something that works in the Notepad example.
Here's the code from the NotepadCodeLab/Notepadv1Solution:
String[] from = new String[] { NotesDbAdapter.KEY_TITLE };
int[] to ...
6
I want to split a comma-separated string in Category column :
Category
Auto,A,1234444
Auto,B,2345444
Electronincs,Computer,33443434
I want to get only a single value from above stri...
4
Solved
I have a LINQ expression that is working fine on the production database but throws an error on the SQLite in-memory database of the test context:
The LINQ expression (EntityShaperExpression:
Enti...
Inland asked 3/3, 2020 at 9:1
1 Next >
© 2022 - 2024 — McMap. All rights reserved.