Only Coders

python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - android-sqlite

deleting Blob from SQLiteCipher db

I am storing images in SQLiteCipher as a blob (byte[] form): public void insertNewImageBlob (byte[] image, String password) { System.out.println(image); SQLiteDatabase db = instanc...

Ernxe

java

android

sqlite

android-sqlite

Votes: 0

Answers: 0

Unknown error calling sqlite3_step (11: database disk image is malformed) eu : iOS

I am working on an iOS App, using SQLite DB. The app has a functionality where on opening the app, records from the server are inserted into the local SQLite db. During this process, my SQLite DB is g...

rv3

ios

objective-c

database

sqlite

android-sqlite

Votes: 0

Answers: 1

Latest Answer

Few suggestions: Make sure you are not trying to access the db from multiple threads at same time. All the db operations should be performed serially while working with sqlite. Have you checked this ...

Shivam Bansal

Delete using inner join with composite primary key

I am trying to delete some records from my database, I have succeeded and it works when testing in "DB Browser for SQLite" software but when I try to copy it to my Android Studio project I g...

JP711

android

sqlite

android-sqlite

android-room

Votes: 0

Answers: 1

Latest Answer

The use of ROW VALUES was introduced in SQLite in version 3.15.0 and this is supported by API Level 26+ in Android. If your app targets lower API levels you can use EXISTS in your query: DELETE FROM A...

forpas

Possible to store time in SQLite database?

QUESTION: Im making a flashcard app and when the user clicks "easy" for example, I want to increase the time of the card, then that card won't appear until the time goes reaches 0. e.g. &quo...

DannyMelander

android

kotlin

android-sqlite

Votes: 0

Answers: 1

Latest Answer

is this possible to do? I believe that if you consider what SQLite is capable of and what an Android App is capable of then Yes. However using SQLite alone then No. Typically, to get your outcome, t...

MikeT

Posts

Questions

Blogs

Jobs