Exploring Android embeded SQLite in the command line

Question

I am trying to exploring Android embedded SQLite database in the command line.

My Android emulator already created with a database named "notebase2" (see the screen shot), but the results in the command line does not reflect that.

The screen shot shows part of my Ubuntu terminal placed on the File Explorer view of my Exclipse DDMS perspective.

enter image description here

Graham Borland · Accepted Answer · 2012-05-28 14:42:17Z

4

.databases lists the attached databases. You haven't opened or attached any databases. Try this instead:

sqlite3 /data/data/your.applications.package/databases/notebase2

edited May 28, 2012 at 14:42

answered May 28, 2012 at 14:09

Graham Borland

60.8k21 gold badges144 silver badges184 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

siva636 Over a year ago

Still, it lists "main" as the (only) database and "~/notebase2.db" as the file (and further SQL commands fails)

Graham Borland Over a year ago

Is the database file called notebase2 or notebase2.db?

siva636 Over a year ago

File name is displayed exactly as this: /data/data/com.me.main/databases/notebase2.db

CommonsWare Over a year ago

@DUKE: Not according to your screenshot it isn't. Your filename is notebase2. Android does not automatically add file extensions to databases you create.

Graham Borland Over a year ago

I added the .db extension in my answer without thinking. Try without.

|

Collectives™ on Stack Overflow

Exploring Android embeded SQLite in the command line

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest