95,195 questions
0
votes
1
answer
24
views
Making an SQLite query simple
any way to speed-up the below queries?
The purposes is giving the list of the SN having the oldest activation date as in the second table below:
SELECT
Table.*
FROM
[Table]
WHERE
Table....
- 11
-2
votes
0
answers
46
views
How can I make my Ordering System efficient with the use of Java and SQLite? [closed]
I am new to coding, specifically java and SQL. How can I make my Ordering System efficient, I am currently getting the ID and setting the variables one by one. The problem I will have in the future ...
-4
votes
0
answers
82
views
Can i manipulate the output of .fetchall() in sqlite3/psycopg2?
I'm executing a query in psycopg2, and converting it to integers so I can plot the values:
cursor.execute("""SELECT msg FROM messages WHERE sensor_id = 3""")
series = ...
- 1
-1
votes
0
answers
36
views
Buildozer tries to install from SQLite website, and it's not avaliable, even trying to make it use local file
I tried to export my app to Android Application using WSL, and I've got a problem when buildozer was installing packages that are needed for app: everything gone wrong with SQLite3.
Firstly I tried to ...
0
votes
1
answer
32
views
Why is SQL SUM function returning wrong values using SqLite3 and Dbeaver
I have been taking a SQL course and am in the final project, which started to use SQLite3 on DBeaver. Previously the SQL prompts were written in the course using SQLite.
When trying the aggergate ...
-2
votes
0
answers
30
views
In SQLite how to extract the four characters after the third hyphen in a string? [closed]
I have the string 20-NG-200101-ESDC-N and I want to extract the four characters after the third hyphen: ESDC. A simple search for "SQLite substring" does not offer a straightforward simple ...
- 1
0
votes
1
answer
38
views
SQLite. I want to solve the problem with UPDATE timestamp
I have a field " date2" - TIMESTAMP. If I execute the command
UPDATE mytable
SET date2 = DATETIME('now', 'localtime', 'subsec');
all rows of date2 have the same value, e.g.: 2025-04-22 10:...
- 11
0
votes
0
answers
22
views
How to read expo-sqlite data in background
I'm trying to implement an app that continuously obtains measurements from different sensors and I store all that data in a SQLite database. This works properly, even if the user is not in the app and ...
-1
votes
0
answers
32
views
Sqlite cache_size minimum
I have a program that uses sqlite which seldomly reads a value for a second time. Therefore there is no need for caching. I'm trying to understand the minimum cache_size pragma I could set.
While I ...
- 1
2
votes
1
answer
42
views
Android Room - Efficiently Querying Relationships with Large Datasets and Avoiding N+1 Problem
I'm working on an Android app using Room Persistence Library for data management. My app deals with a relatively complex data model involving multiple entities with one-to-many and many-to-many ...
- 51
0
votes
0
answers
20
views
SQLite trigger to append new key to JSON `Config` column in `DEVICES` when `TEMP_DEVICES.HardwareID` is updated
Problem
I have two tables in my SQLite database:
-- unlinked device tokens
CREATE TABLE TEMP_DEVICES (
Id INTEGER,
HardwareID TEXT
);
-- mapped device info per account
CREATE TABLE ...
- 37
-5
votes
1
answer
69
views
What Danger am I Inviting if I Store Telegram User IDs Unhashed/Unencrypted in a Database? [closed]
I am working on a bot that echoes the latest YT video title of a specific Youtube Channel to its users. However, it will only echo the video title only if it contains at least one of the user's ...
0
votes
1
answer
47
views
Set up in-memory Sqlite database for testing in pest
I'm trying to set up testing using pest in a laravel project. I have several migrations which are stored in ./test/database/migrations, and I'd like to spin up a new sqlite in-memory database using ...
- 2,053
0
votes
0
answers
25
views
How can I access a static SQLite database as a resource in an Android Tauri 2 app?
I have made a Tauri 2.0 dictionary app, with Android as the target platform. It uses Vue.js on the front-end, with a sqlx connection to a static SQLite database file that contains all the words and ...
- 456
1
vote
0
answers
24
views
Qt 5.14.2 + SQLite3: Database locked when trying to drop temporary tables (COPYPL, COPYPL1)
I'm using Qt 5.14.2 with SQLite3. In the function below, I attempt to drop two temporary tables: "COPYPL" and "COPYPL1". Most of the time this works fine, but with some SQLite ...
- 11