Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Android Android Data Storage with SQLite

Posted by orbyt
orbyt
10,358 Points

sqlite3 not found

Im unable to use sqlite3 command in adb shell as its done in the video, as sqlite3 isnt found. From what i've read, sqlite3 isnt included in consumer builds, only development builds, so sqlite3 would need to be installed manually on the device. This should probably be mentioned in the video or at least the notes.

1 Answer

Leandro Rodrigues
Leandro Rodrigues
3,177 Points
Leandro Rodrigues
Leandro Rodrigues
3,177 Points

You are right, but i did some research and found out that if you have a unlock phone rooted you can "install" the sqlite3.

There is a lot way to do this, the lazier is install the app on play store "Sqlite Installer for Root" and follow the instructions in the app.

Some people complain that doesn't work in some lolipop versions, i have a phone with lolipop 5.1.

The brazilian way that i found it to fix is:

  1. Install Titanium Backup Pro in play store
  2. Found the package in /data/data/com.keramidas.TitaniumBackup/files
  3. Copy the file sqlite3 (this is the builded binary)
  4. Paste in System/xbin/

Worked like a charm for me.

DISCLAIMER: I'm not responsible for what happens to your phone if you decide to proceed with the instructions above.