94,948 questions
Score of 1
2 answers
96 views
How can I make sqlite optimise its sharing of B-trees across indexes?
If I create these indexes in this order:
CREATE INDEX mytablecol1col2 on mytable(col1,col2);
CREATE INDEX mytablecol1 on mytable(col1);
sqlite (version 3.43.2) is clearly still creating and ...
- reputation score 1174
Score of 0
1 answer
48 views
Kamal deploy SQLite error on start: unable to open database file
I have a Rails project that has been configured to deploy to a staging server with Kamal for a while that works great. Now it's time to spin up a production destination. Simple enough, I copy the ...
- reputation score 3647
Score of -1
1 answer
142 views
Trouble with SELECT COUNT and GROUP BY
I am adding data to a table I created with an INSERT INTO statement in SQLite. When I enter the code below (minus ~~ubicageo~~ in the SELECT TOTAL row) within parenthesis, the code fails to group the ...
- reputation score 1
Score of 0
0 answers
170 views
AUTOINCREMENT order inside one multi-row INSERT
If I do this:
CREATE TABLE `MyTable` (
`Id` INTEGER PRIMARY KEY AUTOINCREMENT,
`Name` TEXT
) STRICT;
INSERT INTO `MyTable` (`Name`)
VALUES ('Alice'), ('Bob');
in SQLite, I expect that Alice will ...
- reputation score 635
Score of 0
0 answers
105 views
Problem running SQLite in Terminal Services
I have changed a .NET 4.8 application that stored temporary data in a MS Access database to use SQLite.
Whilst running on my local machine everything runs fine. However, when I run the application ...
- reputation score 1
Score of 0
0 answers
167 views
Update a database table from a dataset
I use a database table as the binding source for a DataGridView.
The table consists of only two columns (essentially a key-value table). In the DataGridView, I can change the order of the rows using ...
- reputation score 193
Score of 0
1 answer
104 views
Cannot enforce foreign key constraints when autocommit is false
I am building a tiny program using a database, and I found that SQLite should be well suited for my requirements. I started designing my database schema with some foreign keys and my first tests ...
- reputation score 150465
Score of 0
1 answer
121 views
C# Blazor using SQLite - DllNotFoundException
I'm learning Blazor and databases, and I'm new to programming in general.
I created a Blazor web assembly project, .NET 10 LTS with a simple local SQLite database.
I just want to use SQLite inside my ...
- reputation score 55
Advice
0
votes
1
replies
77
views
SQLite: how to match multiple records from multiple many-to-many relations?
I've got the below SQlite tables (simplified for posting here):
CREATE TABLE movies (movie_id, title);
INSERT INTO movies (movie_id, title) VALUES
(0, 'Shaun of the Dead'),
(1, 'Hot Fuzz'),
(2, '...
- reputation score 361
Advice
0
votes
6
replies
157
views
Optimizing Month Naming
Can I get any advice on how to optimize the naming for the months in the following code:
(The date convention with the database is 'YYYY-MM-DD')
Select
strftime('%Y-%m', order_date) AS month,
COUNT(...
- reputation score 1
Score of 2
1 answer
151 views
How can I add a bytestring into an SQLite database using python? [duplicate]
I want to add a bytestring into an SQLite database in python. I have tried to format it into a string and back, but that doesn't return the same integer value regardless of the the encoding.
I have ...
- reputation score 45
Score of 0
2 answers
161 views
If use == to compare strings (of numbers) in Tcl why can't you get back the string using cast as text in SQL?
I made a mistake of using == to evaluate two strings instead of eq and when I tried to cast a variable that was a string of numbers to text, after such comparison, the result was a string but after ...
- reputation score 3520
Score of 2
1 answer
221 views
WinUI 3 MSIX app from Microsoft Store fails to create SQLite tables, but works in Debug/local build
I have a WinUI 3 / .NET 8 app packaged as MSIX and published through Microsoft Store.
The app uses EF Core 8 with SQLite. On startup I initialize the database with migrations:
using var db = Services
...
- reputation score 41
Advice
0
votes
3
replies
62
views
Replace '\n' in a substr
I have a substr line which highlights a section of text using the instr command the resulting section of text is then output
But in the selection of text I get '\n' (spaces in otherwords!), I want to ...
- reputation score 1
Score of -1
1 answer
168 views
In SQLite with DBeaver Transaction....Commit is not working
I am using SQLite with DBeaver. I recently got a university assignment where I was asked to show the locking mechanism of a database. So I decided to work with DBeaver.
I can solve it properly with ...
- reputation score 86
