94,924 questions
Score of -8
0 answers
164 views
Where do I store my C sqlite in Linux system [closed]
So in this C program I will need to access and edit sqlite database but where do I store that data? in the program file? How linux file standard work?
- reputation score 17
Score of 3
2 answers
385 views
How to fix sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file?
I was trying to run this jupyter notebook (https://github.com/langchain-ai/lca-lc-foundations/blob/main/notebooks/module-2/2.4_wedding_planners.ipynb) code in my IDE but encountered these problems:
my ...
- reputation score 11
Score of -6
0 answers
150 views
?How to implement automatic topographic drawing from survey codes in an Android Kotlin app [closed]
I am developing an Android application called Ounis Survey CAD using Kotlin and Android Views. The goal is to record topographic survey points and automatically generate drawing elements from field ...
- reputation score 1
Score of -1
1 answer
114 views
ViewHolder - BindView Prblem
I have a table:
id, code, LandName
items
----
----
----
Loading data into a ListView:
Cursor c = myDb.SelectData();
lisView1.setAdapter(new CountryAdapter(this, c));
the Query:
...
- reputation score 39
Score of -7
0 answers
92 views
Flask Can't Call Python Function From HTML Button Using 'onclick' [duplicate]
I'm currently in the process of developing an admin/approval panel for my Python webapp.
Currently the app allows users to make Bank Time requests (for any overtime worked). Once the user submits this ...
- reputation score 1
Score of 3
0 answers
95 views
Generate foreign keys inside CREATE TABLE during migrations
Entity Framework 6 + SQLite: how can I generate foreign keys inside CREATE TABLE during migrations?
I am using Entity Framework 6.5.1 with SQLite in a WPF .NET Framework 4.8 application.
I am using:
...
- reputation score 31
Score of 0
2 answers
161 views
Modeling bounded polymorphic children in SQLite/Drizzle: JSON column vs. Concrete Table Inheritance [duplicate]
SQLite/Drizzle: JSON column vs. normalized child tables for question data?
I’m using SQLite with Drizzle ORM. My questions table is currently normalized, with separate child tables for each question ...
- reputation score 19
Score of 1
2 answers
124 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 1
1 answer
57 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 3667
Score of -3
1 answer
153 views
Trouble with SELECT COUNT and GROUP BY [closed]
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 2
1 answer
248 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 655
Score of 0
0 answers
120 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
190 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
1 answer
126 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 150585
Score of 0
1 answer
155 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
