Android Tutorial Android SQLite Viewer

SQLite Viewer is an open source application that allows you to view the contents of SQLite databases right from your Android device.

Choosing the database file is done with an external file manager or with agraham's FileDialog.

After choosing a database file, you will see a list with the database tables. Choosing a table will open the second activity which shows the table fields types and the table contents.

BLOB columns will display: "click to see image".
When you click on such a cell the program will try to convert the BLOB data to an image and show it.

The code uses DBUtils code module for most of the SQL statements.
Handling the BLOB columns adds some complexity. You can see it handled in TableActivity code.
The source code is included in the zip file.

 

[Merlot2309]

Erel,

A very useful tool for SQLite databases.
Thank you.

Helen.

 

[Deleted member 103]

Hi Erel,

Many many thanks, have been waiting a long time. :sign0060:

:sign0098:

 

[aklisiewicz]

While compiling this example I get following error
===============================================
Compiling code. Error
Error parsing program.
Error description: Unknown type: filedialog
Are you missing a library reference?
Occurred on line: 13
Dim FileDialog1 As FileDialog
===============================================
seems like I'm missing some library. Is there any way to download all available libraries and install all of the in one step, so I don't have to search for it every time I want to run some example app ? I think it should be a matter of good habit to include information with the example if any extra library is necessary to compile.

Thanks - Arthur

 

[Erel]

You are missing agraham's Dialogs library. Didn't you get an error when you opened the project?

The documentation page lists all objects types. You can search for FileDialog and then it will take you to its library.

 

[aklisiewicz]

no I did not get an error upon opening, but rather on compliling. I have found it and installed, mentioned library but I her the following error:

Compiling code. Error
Error parsing program.
Error description: Unknown type: contentchooser
Are you missing a library reference?
Occurred on line: 5
Dim cc As ContentChooser

I can't locate any library like ContentChooser

Arthur

 

[Erel]

Have you changed any code? Is it loading the blue layout?

 

[Rusty]

I too, had this problem. Where can I find the FileDialog1 library or code? I made no changes to the project included in the zip file. Thanks

 

[Erel]

The FileDialog is part of the Dialogs library and the ContentChooser is part of the Phone library.

 

[kickaha]

ContentChooser is part of the Phone library, ensure this is selected in the "libs" tab of the IDE.

The search function at the top of this page works guys:sign0060:

 

[AscySoft]

Not working!? I know is me, but why? Here's the error:

Compiling code.
Error parsing program.
Error description: Unknown type: filedialog
Are you missing a library reference?
Occurred on line: 13
Dim FileDialog1 As FileDialog

Why is not working? In libs tab I've got all the 3 libs checked(core.phone,sql)

 

[AscySoft]

Sorry, false alarm. I wasn't paying attention to the first posts...My bad
:sign0013:
I installed Dialogs Library 2.3 and now is working perfectly! Thanks

 

[Harris]

Weird..

I just tried the "apk" on my device (Flytouch 2).

It uses the filemanager and I can choose internal or external storage.
It opens the internal db with no problem, shows the contents of any table and images stored in blobs.

When I try to open the same db on the SD card, I get a toastmessage - "Error opening db" - and nothing shows.... The db is intact because my app uses it without any problems.

Thanks

 

[Erel]

You can remove the Try / Catch code in LoadDatabase. Try to load the database and check the error message.

 

[oleman108]

The FileDialog is part of the Dialogs library and the ContentChooser is part of the Phone library.

I have the same problem like aklisiewicz and in addition I am not finding this Dialogs library. It does not show in the Libs Tab. How can I reference this library?
Thanks for :sign0085: to a newbie, Oliver

 

[klaus]

Here.

Best regards.

 

[tcgoh]

Hi,

How do I upload a database file to the emulator?

Thanks

 

[Erel]

Please do not post duplicate questions. I answered here: Upload data file to emulator

 

[tamadon]

I created a sample database using SQLite manager Firefox addon. I can read the content fine when I have like 4 entries but when I have 10 entries I can no longer view the table list.

The table consists of 7 columns: ID, BLOP1, TEXT1, TEXT2, TEXT3, TEXT4, BLOP2. The database size is only 1120KB.

This problem only occur in the emulator, the emulator has 16MB SDcard. However I can view the tables using a real device.

What am I missing?

Thanks in advance for the help.

 

[tamadon]

Attached is the sample database. SQLiteViewer can read that but when I add more record, the table is no longer readable.

I've increased the Max application heap size to 64 and the SD Card size to 1GB but those don't help either.

Any ideas?