Questions tagged [android]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
0answers
13 views

App Crash due to Sqlite database Locked Exception

I am having an Android app with read only local sqlite database. Also I have use Sqlite Asset Manager for the local database. import android.content.Context; import com.readystatesoftware.sqliteasset....
0
votes
1answer
20 views

SQLite - get every row that has a common entry in the second column

I am working on an Android studios project and I have a table that has two columns item and listname. I want to get all the items that have a common Listname so in this case if I were looking for ...
1
vote
1answer
336 views

Is it possible to set SQLite DB on server and connect to it in an Android app?

I'm creating an app as a study project. One of requirements is not to hardcode. For this reason, I want to get data from DB with every start of the app and change data stored in DB outside of the app ...
0
votes
0answers
21 views

Optimal query using indexes

I have an sqlite table Task(type INT ,due_date LONG) where due_date is stored in epoch TYPE DUE_DATE ---- ---------- 1 1582038293 1 1485034292 2 1082048291 3 ...
-1
votes
1answer
34 views

Moving for the first time to sql [closed]

I have been doing the backends of my android apps with Firebase for a long time but it is not a good database so I decided to move to mySQL for my next project. Is that possible to build a free ...
0
votes
1answer
96 views

Designing a database for Reading Comprehension

So I am building an RC app that will require me to fetch data. I have data in Excel sheet and I would like to load the data in sqlite database. But I am having trouble designing the db. A little ...
1
vote
2answers
118 views

Correct organization of the database structure and selection

Sorry for newbie question. For example, there is some kind of abstract device, we will call the Device class and the tasks for it: Task1, Task2, Task3. For concreteness, I will describe everything in ...