All Questions
36 questions
2
votes
2
answers
149
views
Optimize Multiple Insert SQLite Coming From MySQL
I'm currently developing an app that requires sending and receiving of data from android studio going to MySQL and then data coming from MySQL will be saved from the SQLite. I need advice on how to ...
3
votes
1
answer
384
views
Sending and receiving of JSON data to and from Android Studio
I'm currently developing an app that requires sending and receiving of data from android studio going to MySQL and then data coming from MySQL will be saved from the SQLite. I need advice on how to ...
3
votes
2
answers
216
views
Displaying 21 spinners to select body parts
I just wanted to ask how can I make my code a bit shorter. As of now, I have way too much code in the class. The program should display about twenty one spinners. I know it's a lot, but in this layout,...
3
votes
1
answer
101
views
SQLiteOpenHelper for multi string tables
I wrote this simple SQLiteOpenHelper in order to use in one database various tables containing String records (each record having a String identifier, and ...
2
votes
1
answer
441
views
SQLite Quiz with Questions Table and Categories Table
Edit: I changed my approach.
I am trying to add categories to my existing SQLite quiz. This is my approach, what do you think about it? Do you think the foreign key restriction is necessary? I am a ...
0
votes
1
answer
238
views
Android SQLite database with 3 tables
I want to show you the SQLiteOpenHelper and Contract class for a little quiz app I made for practicing purposes. I have 3 tables ...
1
vote
2
answers
155
views
Code for writing and reading from the database
I created code for inserting and retrieving data from a specific table. I tried to optimize it and make it as beautiful and easy to read as I can, but maybe (almost certainly) I'm missing something.
...
2
votes
3
answers
897
views
Storing quiz questions in SQLite
I am creating my first android app. It is going to be a quiz.
There are 40 different question categories and each category has its own database table.
I am writing all questions into a sqlite database ...
1
vote
1
answer
902
views
DatabaseHelper with multiple tables
I am programming my first android app. It is going to be a quiz. It will have 40 different categories of questions and for each category I am going to have a SQLite Table, which holds the questions ...
3
votes
1
answer
2k
views
Android generic SQL database handler
Starting with the fact that creating the classic database handler in Android is really annoying and it usually takes a lot of time since you have to create one handler for each object, I thought at ...
0
votes
1
answer
140
views
5 input based search form for Android
I've been trying to look for a better way in which a user has up to 5 inputs in which they can search for results in a database.
I have 2 EditTexts in which the ...
4
votes
1
answer
296
views
SQLite database for books
First, my Book object:
...
4
votes
1
answer
47
views
Places and their PlaceCategories
I'm going to start small here because I actually have several questions but I'll go one at a time.
In the app I am making to better learn Java/Android/SQL/OOP, I have a page where a user can define ...
1
vote
2
answers
721
views
Properly structuring SQLite classes/operations in Android
I am new to Android development and I want to ensure I'm learning decent practices for doing things. Right now this is my database class, which currently allows me to make a new instance of the ...
3
votes
1
answer
2k
views
Pulling from data from SQLite DB on Android
Apart from merging the 2 get methods, what else can I do to optimise this?
Both input and output cannot be changed. Is there a way to iterate a map while writing to it?
...