95,123 questions
0
votes
0
answers
19
views
Accessing sqlite fts5 from a Windows client, in particular for backup purposes
I have a large fts5 virtual table (currently about 90GB).
Because the sqlite ODBC driver, which I use (version 3.43.2) as my main sqlite scripting client, doesn't support fts5, I populate and use fts5 ...
- 1,155
1
vote
0
answers
68
views
how i can populate struct type only in returning joined column from sql
I have a table named tasks where have relationship one-many to another table (projects), i want to query tasks with projects but only return selected column from the projects table. how i can do that ...
- 11
-2
votes
0
answers
60
views
Cloned table works causes foreign key error [closed]
I'm having trouble cloning tables (sqlite3 under Python). I have two tables:
cursor.execute('''CREATE TABLE IF NOT EXISTS posts (
id INTEGER PRIMARY KEY AUTOINCREMENT,
...
- 145
1
vote
2
answers
85
views
Proper way to locate the position of a single newly inserted row based on order by clause immediately after insert?
After inserting a single row of data into a table (always a single row), I'd like to return to the application code the relative position of that row based on an order by clause. Thus, the application ...
- 3,173
0
votes
1
answer
28
views
Having clause removing rows. Is there a workaround?
Sqlites having clause is not acting as I expect. if I query 2 columns and use one in the group by, I don't get all the rows. I can get around the problem putting the having in a in clause, but should ...
- 3,360
1
vote
1
answer
21
views
On Delete set null not behaving as expected with sqlite
I'm using sqlite and I have a table
Sessions (sessionId INTEGER, ...)
And a table
Orders (orderId INTEGER, ...,sessionID INTEGER, Foreign key sessionID references Session on delete set null)
But when ...
0
votes
0
answers
29
views
SQLite is missing as DataSource in Visual Studio 2019
I used to generate and print reports in Visual Studio 2015 using SQLite databases. Creating reports with RDLC was very easy — I could design them and print directly on A4 paper. ORM use was like ...
- 13
1
vote
2
answers
45
views
viewing inside database in docker volume
I wrote a program with nodejs and I setup docker for it. The programs database is stored in a volume here is the code from compose.yaml
services:
server:
build:
context: .
environment:...
0
votes
0
answers
73
views
How can I add a Root CA certificate to Google Chrome’s local SSL store via script on Windows?
Since a recent version, Google Chrome maintains its own “local store” for SSL root certificates, allowing users to trust certificates without installing them at the Windows OS level. You can view this ...
- 67
0
votes
0
answers
148
views
Correct design for SQL table in SQLite3: how to optimize substring search?
I am using SQLite3 in C++ where I need to store text data. There are 7 columns in the table. I need to filter data by 7 columns. I need to check for equality of 6 columns to a specific value, and I ...
- 1,033
1
vote
1
answer
95
views
How to make concurrent writes in SQLite with FastAPI + SQLAlchemy without "database is locked" error?
What Happens
I trigger /session_a and /session_b almost simultaneously (e.g. with Postman or curl).
/session_b usually succeeds.
/session_a fails on db.commit() with
sqlite3.OperationalError: database ...
- 13
0
votes
0
answers
24
views
Electron.js form input fields freeze for a few seconds after inserting data
I'm building a desktop app using Electron.js with a Bootstrap-based form that includes input fields and dropdowns.
Everything works fine initially, but after I insert data once or while filling the ...
0
votes
0
answers
55
views
Could not load file or assembly 'Microsoft.Data.Sqlite, Version=9.0.7.0'
In Visual Studio 2022, I have an installer project. I went by what was suggested here:
The type initializer for 'SQLite.SQLiteConnection' threw an exception
When I run the project in Visual ...
- 291
0
votes
1
answer
60
views
Why is my SQLite database not creating a column for password?
I am building an app in expo as a personal project and I am trying to create a users table that will store names, emails, usernames, and passwords. The login screen and database run when the app ...
0
votes
0
answers
35
views
SQL Query to sum 2 columns from 1 table, and subtract result from a column in a different table [duplicate]
I have 2 tables (not related, no primary/foreign keys, no nulls in any column)
Table: MonthlyEarnings
| Month | Year | DebitAmount | CreditAmount |
| ----- | ---- | ----------- | ------------ |
| July ...
- 291