All Questions
29,183 questions
-2
votes
0
answers
48
views
How can I make my Ordering System efficient with the use of Java and SQLite? [closed]
I am new to coding, specifically java and SQL. How can I make my Ordering System efficient, I am currently getting the ID and setting the variables one by one. The problem I will have in the future ...
-1
votes
1
answer
48
views
Buildozer tries to install from SQLite website, and it's not avaliable, even trying to make it use local file
I tried to export my app to Android Application using WSL, and I've got a problem when buildozer was installing packages that are needed for app: everything gone wrong with SQLite3.
Firstly I tried to ...
2
votes
1
answer
42
views
Android Room - Efficiently Querying Relationships with Large Datasets and Avoiding N+1 Problem
I'm working on an Android app using Room Persistence Library for data management. My app deals with a relatively complex data model involving multiple entities with one-to-many and many-to-many ...
- 51
0
votes
0
answers
25
views
How can I access a static SQLite database as a resource in an Android Tauri 2 app?
I have made a Tauri 2.0 dictionary app, with Android as the target platform. It uses Vue.js on the front-end, with a sqlx connection to a static SQLite database file that contains all the words and ...
- 456
1
vote
0
answers
18
views
Options Menu Integration in Android with SQLite Database
I'm trying to add an Options Menu (the 3-dot menu) to my Android app using Java and a custom Toolbar. The menu should show two options (Option 1 and Option 2), and display a Toast when either is ...
1
vote
0
answers
31
views
Movie Ticket App using SQLite Issue with Login Triggering 'User Already Exists
I am building an Android app with a login screen that stores the username and password in an SQLite database. After a successful login, the user is taken to a Movie Ticket Booking screen where they ...
0
votes
1
answer
41
views
Can SQLite database be used in Flutter mobile app created in Google Project IDX?
I have created a demo Flutter mobile app using SQLite db in my local environment.
I am trying to use Google Project IDX instead of my local environment for further development of my demo Flutter ...
- 512
-1
votes
2
answers
66
views
How to delete a row knowing its row index in a nested SQL statement where the table doesn't have a row index column?
My app has a function that deletes a specific row in a SQLite table based on the row index or position, but the table doesn't have a column that stores a row index for easy access. My app retrieves ...
- 3,274
0
votes
0
answers
43
views
Can the sqlite db be included in the apk file itself?
I made a CURD App using splite3 with Tauri Ver2.
It's working fine, but I have a question.
At the moment, I'm copying the sqlite database app.db to Android manually using the adb command, and ...
- 11
0
votes
0
answers
36
views
Is it possible to create a Blazor Hybrid app that uses NHibernate and Sqlite on Android?
I suspect it's not possible, but I would appreciate community input on this topic.
I've created a .NET MAUI Blazor Hybrid app, as one project in a multi-project solution. I have an Infrastructure ...
- 21
1
vote
2
answers
73
views
Trying to concatenate two flows from Room DAO query without success in kotlin
I want to concatenate the results of two SQL queries I implemented using the Room library. I will put an example to present it more clearly:
In my DAO file:
@Query(SELECT plantId FROM PlantView WHERE ...
- 2,165
0
votes
1
answer
128
views
DLLNotFoundException (e_)sqlite3
I'm exporting an Android game from Godot 4.4dev3 with SQLite and having issues getting it to work. It works on desktop. It always results in a DllNotFound error. I am only targetting arm64-v8a on the ...
- 3,085
1
vote
1
answer
57
views
SQLite query to compute row number without row_number etc
I have a table of string values where the natural sort order is first by length and then by value.
i.e.,
CREATE TABLE t(v VARCHAR(255));
INSERT INTO t(v) VALUES ('100'), ('10'), ('8'), ('5'), ('3'), (...
- 2,414
0
votes
0
answers
83
views
android.database.sqlite.SQLiteException: file is not a database: , while compiling: select count(*) from sqlite_master;
I am working with SQLCipher to encrypt my database in my Android app, but I am facing an issue where I cannot open the database using the correct passphrase. When I attempt to query the database, I ...
0
votes
2
answers
31
views
How to make Room work with "pre-packaged" databases with different schemas?
I'm experimenting to make an app that requires to hold a lot of info, like a database about the city and it's places.
Currently I'm using SQLite file to send this data from server to client - it is ...
- 41