Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [android]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
233 views

Proceeds JOIN only if condition met on the Owner table

I have many hasOne relationships like this: components component_headings component_images Here one Component can only have one hasOne to any of [headings, images]. Logically when a Component.type =...
Riajul's user avatar
  • 111
3 votes
0 answers
435 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....
Ankit Sahu's user avatar
1 vote
1 answer
476 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 ...
Tony77's user avatar
  • 21
2 votes
2 answers
1k 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 ...
b1sk1's user avatar
  • 21
1 vote
0 answers
24 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 ...
anAmaka's user avatar
  • 111
0 votes
1 answer
40 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 ...
Gloria's user avatar
  • 11
1 vote
1 answer
197 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 ...
Abhishek's user avatar
2 votes
2 answers
127 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 ...
ilw's user avatar
  • 23