95,082 questions
0
votes
0
answers
55
views
+50
Connect to SQLCipher encrypted SQLite database with Rider's built-in plugin
I'm trying to connect to my database through Rider but it doesn't work since I encrypted my database with SQLCipher. Tutorials say I should add these fields in the "Advanced" tab but that ...
0
votes
0
answers
62
views
SqlAlchemy not using updated table name in join statement
I'm not exactly sure how to what is going on, but for our testing we rename the tables before we generate everything (ie schema.table_name is renamed to table_name_schema due to issues with how we ...
- 79
0
votes
0
answers
44
views
Electron Builder: Built app starts UI but server + SQLite database do not run in packaged versio
I have an Electron application that uses:
React for the frontend
Node + Express backend inside /Server
A SQLite database stored inside the same /Server folder
During development, everything works ...
- 1
3
votes
1
answer
100
views
Getting SQLite Syntax Error when saving model in Sequelize.js v7
So, I'm trying to learn full stack by making a list app, and I'm using
Sequelize.js for the database. So far I've got User and List models. I
recently switched to Sequelize v7.0.0-alpha.47. I can't ...
- 112
Advice
0
votes
3
replies
72
views
Serialization for database?
Lately I've been curious about databases so I am reading books and trying to do simple assignments to learn more about them. I read about pages which contain rows and that's all good but how do I ...
- 433
0
votes
2
answers
72
views
How do I resolve a error global::System.Diagnostics.Debugger.Break(); in a .Net Maui application
I'm trying to configure a new Maui app to use EF and Sqlite following this guide: https://learn.microsoft.com/en-us/dotnet/maui/data-cloud/database-sqlite?view=net-maui-9.0
For a long time I got an ...
- 832
0
votes
1
answer
116
views
How can I retrieve data between certain times?
My data decoded from a radio receiver is stored in tables Flights and Aircraft with a common field AircraftID to enable a JOIN. There are fields for when the radio signal starts and ends (StartTime ...
- 3
0
votes
0
answers
30
views
CapacitorSQLite “isConnection() is not implemented on Android” in Ionic v8 + Capacitor 7
I’m developing an app using Ionic v8 and Capacitor 7, and I’m trying to integrate the @capacitor-community/sqlite plugin.
However, when I run the app on an Android device, I get the following error:
...
4
votes
2
answers
128
views
sqlite3 shell on Windows : extra carriage returns when using output redirection
Demonstrate the issue
Let's use nvim to create a text file:
> nvim C:\temp\in-file.txt
The contents of the text file:
> Get-Content C:\temp\in-file.txt
abc
bcd
cde
Now let's create a simple ...
- 9,699
0
votes
0
answers
121
views
Laravel PHPUnit test: Multiple databases issue
In my Laravel application, I have set up two databases in a single server. All specific migrations and model classes have $connection property set up to use blog instance. The app works fine, no ...
- 64
0
votes
0
answers
100
views
Why does my message not appear on the page even though the server log shows it was sent successfully in CivetWeb + SQLite?
I’m building a local web chat feature using CivetWeb (C++), SQLite, and a frontend in plain HTML/JS.
When a message is sent, the server log shows:
Attempting to send message: product_id=3, sender=1, ...
- 19
-4
votes
1
answer
93
views
Calculate Duration in SQLite from M/D/YYYY H:MM:SS Text and Format as h:mm:ss
I have an SQLite table named trip where the started_at and ended_at times are stored as TEXT in a non-standard M/D/YYYY H:MM:SS (or HH:MM:SS) format. I need to write an SQLite query to calculate the ...
0
votes
0
answers
398
views
Issue with StoreKit 2 In App Purchases: "unfinalized statements / unfinished backups" SQLite Crash
I’m running into a persistent error while implementing StoreKit 2 renewable subscriptions in my SwiftUI app.
Context
I have a two-screen flow:
Screen 1: user selects a subscription plan (monthly / ...
- 21
0
votes
1
answer
44
views
Should I disallow backups of sqlite to the same physical media? [closed]
Looking at the Sqlite backup options
https://oldmoe.blog/2024/04/30/backup-strategies-for-sqlite-in-production/
I have a question that is orthogonal to the backup method used:
suppose on Windows I ...
- 5,935
0
votes
1
answer
59
views
Escaping weird path names with sqlite json_extract
I'm trying to figure out how to escape weird field values in a json_extract expression. Here's my table:
create table records (
record_pk text primary key,
config json not null default '{}',
...
- 925
0
votes
2
answers
139
views
With SQLite, where is the as keyword optional, and what difference does adding it make, if any?
Currently I am learning Python programming for manipulating SQLite database, and I am a bit confused with the following SQL statement which works.
SELECT *
FROM student s, result r
WHERE s.studentid =...
- 43
0
votes
0
answers
101
views
Record Selection in Main Dataset from a Sub Dataset in Delphi
The application I'm writing has a main form where all the database fields and DBGrid that contains the entire SQLite dataset (ExpItemQuery) reside. I have designed a database search functionality into ...
- 216
0
votes
0
answers
62
views
SQLite3 Exec Failing with Assertion in checkWalModeFromQuery on Xcode 26
I'm encountering a runtime assertion failure when trying to execute a SQLite query using sqlite3_exec in Xcode 26. The error occurs specifically when attempting to set WAL (Write-Ahead Logging) mode ...
0
votes
1
answer
58
views
Python is creating a connection for each execution in executemany [closed]
I have the following code
logger = get_console_logging_object()
def get_db_path() -> str:
""" get the path to the database file"""
script_path = Path(__file__)....
- 960
1
vote
0
answers
67
views
Microsoft.EntityFrameworkCore.Sqlite TOP and LIMIT SQL syntax error
In Entity Framework Core 9.0.9, the query builder fails with SQLite Syntax
builder.Services.AddDbContext<MyDbContext>(fun options ->
options.UseSqlite(connectionString) |> ignore
It ...
- 41
2
votes
1
answer
102
views
Is sqlite upsert "insert or ignore ... on conflict do update..." a valid statement?
In Sqlite3...
I need to copy data from an unconstrained table to a more constrained table. I need to drop illegal entries (null), replace matching existing entries (unique x), and add new entries. ...
- 424
4
votes
1
answer
413
views
Python 3.13.5 sqlite3 DeprecationWarning persists despite registering custom date adapter
I am building an application using Python 3.13.5 and the native sqlite3 library. To correctly handle datetime.date objects and avoid the new DeprecationWarning, I am trying to implement the officially ...
2
votes
0
answers
214
views
MAUI: SQLite database "removed" after app closes in release mode
Why does the SQLite database file get deleted when the release mode app closes?
My SQLite database works perfectly during the app lifecycle but gets completely deleted when the app is closed only in ...
- 132
0
votes
0
answers
149
views
In Delphi 12, using FireDAC, is there a way I can set the field length of a string automatically
We are porting an application to a SQLite database (that we can't change - it's PowerSync if that helps) that has a number of views, and when we do a select from one of these views, all the text ...
- 6,931
1
vote
2
answers
98
views
Executing SELECT query in one thread and INSERT and UPDATE in another thread in SQLite3
Is it safe to execute SELECT query in one thread and INSERT and UPDATE in another thread in SQLite3 in C++? Will it cause data race/UB?
I create a connection to the database as follows
sqlite3* db;
...
- 1,349