View Single Post
fcrochik's Avatar
Posts: 722 | Thanked: 1,223 times | Joined on Apr 2010 @ USA
#1
dbBrowser - 0.0.3

Just uploaded to extras-devel a very simple utility to browse sqlite databases on the n900. I created it mainly to help me develop/debug my other applications.

It allows you to browse databases created by other applications or create new sqlite databases and run sql queries against them.
It automatically detects sqlite database files regardless of the filename extension and allows you to browse hidden folders.

Not sure if it will be helpful to non-developers as it is but, if nothing else, some people may find interesting to see what other applications are storing on their phones.

As always, please let me know your comments/suggestions....

Known Issues:
As now you can edit the data in a table but the changes will not be saved to the database.

Notes:

I tried to find a application that I could port to the n900 but didn't find anything suitable:
  • just found this one for the n8?0 but it seems to be written in python
  • QtSqlView is pretty simple but was the closest match to the n900 - unfortunately adapting the UI would be almost as hard as starting again. I copied the SqlHighlighter implementation from it and used it as an inspiration. Timo Bingmann: Thanks!
  • Sqlite Database Browser is probably the most complete I found but it seems to depend on qt3
__________________

My maemo work:
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
For Harmattan:
GeePS - native UI around google maps - GApp - access to optimized mobile "google apps".
Shutdown - shutdown and reboot with one click - QuickCall - one click call, skypeout and google voice integration using dial tones.
WakeOnLan - wake computers on your local network.
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
For Maemo/N900:
GApp - access to optimized mobile "google apps". - MobWebMail: browser optimized to access multiple gmail accounts
MyContacts: 75 Contacts on your desktop, ring tones per group and more - GeePS: native front-end for google maps
Macuco2 : web browser to access web sites optimized for the iphone - WakeOnLan: wake up computers on your local network
dbBrowser: Simple application to browse sqlite databases

Last edited by fcrochik; 2010-10-05 at 02:45.
 

The Following 22 Users Say Thank You to fcrochik For This Useful Post: