Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sqlite]

SQLite is a relational database management system (RDBMS). Instead of running a server process, SQLite databases are directly accessed by running the 'sqlite' binary.

-1
votes
0answers
9 views

How to Bring sqlite database colum value in autocomplete text in android studio [closed]

I have checked many answers and topics but most of those include defined string array values . I am looking for solution to bring value from database table as i search on threashold of 2. Please ...
-1
votes
0answers
7 views

how to insert image in sql database in android [closed]

MainActivity.java package com.example.tanishyadav.myapplication; import android.Manifest; import android.content.Intent; import android.content.pm.PackageManager; import android.graphics.Bitmap; ...
1
vote
0answers
73 views

Can't access Gmail Inbox trough Sqlite3, mailstore.email@gmail.db doesn't exist Android nougat

I used this to get all emails on inbox (on android shell or through tasker running a shell command): sqlite3 /data/data/com.google.android.gm/databases/mailstore.YOUREMAIL@gmail.com.db "SELECT ...
0
votes
0answers
121 views

How to extract files from Huawei backups to SD card

I've backed up my Huawei P9 lite to the SD Card using the native backup app provided by Huawei. It backs up each APK and along side each a sqlite DB file that seems to contain all of the files that ...
2
votes
1answer
397 views

High resolution contact pictures in Marshmallow - what is their size and where are they stored

Trying to answer this question How to backup large contact photos?, I wanted to compare the picture size after restore I do see a database for contacts , as mentioned in Narayanan's answer here - ...
0
votes
2answers
678 views

Is it possible to recover Google authenticator database

I am using 2 factor authentication through google authenticator and forgot to keep backup for one of the websites (cex.io). When I changed to new phone, I uninstalled Google authenticator from the old ...
1
vote
0answers
344 views

Is it impossible to pull a database file from non debuggable app in a non rooted device?

Here's what I tried: adb shell "run-as my.package ..." doesn't work because the app was installed without the android:debuggable option. adb backup doesn't work (it produces an empty file) I can't ...
0
votes
1answer
778 views

android thinks accounts.db is corrupted and deletes it

After a reboot, i lost all my accounts. i looked into the logcat and got: 04-02 11:54:01.535 5305 8068 E SQLiteLog: (11) statement aborts at 24: [SELECT key, value FROM extras WHERE accounts_id=(...
1
vote
2answers
2k views

How can I access veryfit app database on my device?

I have installed VeryFit2.0 app on my mobile.I want to see previous days heart beat data but there is no option.Is there are way by which I can get in to the database of the app as I know its an ...
-1
votes
1answer
571 views

2016 Colornote saving manual backup in .doc format

Hello I saw in another post from this site that I could open the colornote.db file that was stored here: /data/data/com.socialnmobile.dictapps.notepad.color.note/databases/ with a db sqlite browser. ...
2
votes
0answers
666 views

Batch script use sqlite3 to edit settings.db

I want to create batch script to enable hidden languages in a Huawei phone. But every time I stuck can you guys spot where is my problem @echo off color e cd "%~dp0" mode con:cols=90 lines=40 adb ...
-2
votes
1answer
31 views

Unable to launch sqlite3 in my sumsung phone

I have put the libncurses.so and sqlite3 in the /xbin , but it seems unable to load the library "libncurse.so". waiting for help !
1
vote
3answers
713 views

Where are Androids’ developer options stored?

Can anyone please tell me, where Androids’ developer options are stored? I’m trying to modify the Pointer Location developer option in this file. After recompiling Android, where is the file ...
1
vote
2answers
10k views

How to convert/encrypt WhatsApp .sqlite to .db.crypt8?

I have aa WhatsApp ChatStorage.sqlite file which was taken from an iPhone backup, and I don't exactly understand the structure of the data inside the database, but it's clearly not encrypted. I want ...
0
votes
1answer
2k views

Can't find webview.db file for android browser to view saved passwords in internet app

I can't find this file anywhere. Can anyone advise where this might be stored? I downloaded SQLITE editor on my note 3 but it says no database. When I see the internet icon under Apps in SQLite Editor ...
1
vote
1answer
2k views

SQLite database operation from Android terminal

I want to do SQLite command like sqlite3 myDb.db, or do other SQLite command from Android shell, like Terminal Emulator or something else. I have tried googling for these, but no luck. Is it possible ...
3
votes
0answers
253 views

Android Music Player - Does the default “Music Player” program store the timestamp of when a song was last played?

I have a question about the recently played items in the Android (specifically v4.2.2) media library. Does the default "Music Player" program store the timestamp of when a song was last played? Or ...
4
votes
1answer
19k views

Merging a Crypt7 and a Crypt8 whatsapp backup

I have been searching a lot in the past couple of weeks on how to merge two whatsapp backup. Last month I got a new phone, installed whatsapp along with my old backup. During installation, whatsapp ...
0
votes
1answer
195 views

Can you execute sqlite3 outside xbin directory?

When sqlite3 is installed you can execute the binary e.g. via a terminal emulator. If sqlite3 is not installed per default and you do not want to root the phone to install it, is there any ...
2
votes
0answers
798 views

Where is the data for S Health stored?

I'm making a personal fitness tracker but I want to grab the days for sleep and heartbeat that gets stored on s health. Where is this stored in the filesystem (maybe an SQL lite db)?
3
votes
2answers
10k views

Modify settings parameters through database

I have been able to successfully modify and update the settings in the Android phone using ADB commands such as these.. Enable GPRS data: adb shell sqlite3 -batch /data/data/com.android.providers....
0
votes
0answers
1k views

Can't recover my .db files

I did a backup before reseting my phone. I've got two .db files (contacts & text messages); I really want to put them back into my phone but when I try to open them it says "unable to open". How ...
2
votes
1answer
2k views

Trying to vacuum all databases under /data with sqlite3, but fails with error 14

I would like to vacuum all my database files under /data, to achieve somewhat better performance so I ran the following script: for i in $(find /data -iname "*.db"); do #echo $(basename $i); sqlite3 $...
1
vote
0answers
361 views

GTab with access denied to all app databases

I have a brand new GTAB (Android) that was working fine but suddenly, give a reboot while I was using anMoney, a very good application of financial organization. Until anything I'd like to observe ...
2
votes
0answers
785 views

Can Not Open mmssms.db

I have taken a copy of the mmssms.db from the /data/data/com.android.providers.telephony/databases/ I am trying to open this in sqliteman, but the database does not want to load in, I have taken ...
1
vote
1answer
2k views

open-gpstracker: Export all tracks or access the SQLite database

I am using open-gpstracker to track routes. After quite some time I have collected a large number of tracks that I like to export as GPX files. The application allows to do that, however, there is no ...
23
votes
1answer
19k views

Recover deleted content from userdata partition?

So it came to pass, that Amanda did have a blonde moment and deleted all her threads in the SMS app by mistake. Yeah, "Delete all threads" probably shouldn't be quite so easy to invoke. The phone's ...
4
votes
2answers
3k views

Transferring messages to android from a sqlite db on my laptop

I am a new android user. I switched from nokia to android today only. Been googling around for various solutions to transfer my sms (text messages only) from my old nokia to my new Android (Galaxy Ace ...
8
votes
2answers
3k views

Android apps keep crashing with android.database.sqlite.SQLiteDiskIOException

Starting yesterday, my Galaxy s2 device running Cyanogenmod 9 started to crash with android.database.sqlite.SQLiteDiskIOException exception for every running app. Does it means that my phone is dead ...
2
votes
0answers
884 views

Rooted Phone's data folder now empty

I used to see all the dbs in File Explorer , now all of a sudden the data folder is empty, What could have happened? Phone: Motorola Droid X (original). I have been debugging rigorously, the only ...
0
votes
1answer
1k views

How to extract sqlite file

My Samsung Galaxy S was having an error on the notification bar saying sd card blank or has unsupported file system, so I was required to format my sd card. However, I couldn't format it using the ...
16
votes
4answers
26k views

Android Read recent SMS messages from command line

I have recently broken my Android's screen. (Again) Its a T-Mobile G2 Trying to keep up with my busy technology related life is hard enough without losing my link with everyone. I have rooted the ...
16
votes
9answers
15k views

Where can I obtain an SQLite 3 command line binary for Android?

When I read documentation such as examining SQLite 3 databases from a remote shell I get the impression an SQLite command-line binary should exist on my phone. Sadly I can't seem to find it on my ...