94,957 questions
Score of 0
0 answers
33 views
How to create table in Sqlite in .NET MAUI APPLICATION?
I am a PHP dev, to create database and create table I use phpmyadmin, now I am learning .net maui to create android applications, but unlike there, here is no phpmyadmin, where can I create the table??...
- reputation score 1
Score of 0
0 answers
93 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
143 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 -1
0 answers
60 views
How can I fix drizzle's error: "'schema' does not exist in type 'DrizzleSQLiteConfig<EmptyRelations>'."?
I'm trying to learn drizzle for expo in order to build an offline data base for an app. I'm following the tutorial: https://www.youtube.com/watch?v=1inzzYvbgO8&t=169s, because drizzle official ...
- reputation score 1
Score of 0
1 answer
94 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 150435
Score of 0
1 answer
114 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
70
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
153
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
136 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
146 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 3430
Score of -3
0 answers
82 views
Flask app SQLite3 objects created in one thread cannot be used in another [duplicate]
I've defined all functions of my code, which require the execution of SQLite3 SQL statements in a file, main2.py . I have imported all functions and objects into my app.py file which will create a ...
- reputation score 45
Score of 2
1 answer
208 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
61
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
136 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
Score of -5
1 answer
168 views
Cannot search anything [closed]
I was trying to program a function to search users from a table in the database but I've been trying to fix.
I tried following a tutorial with no success and I couldn't find anywhere a solution in ...
- reputation score 1