maemo.org - Talk - [Announce] dbBrowser

maemo.org - Talk (https://talk.maemo.org/index.php)

- Applications (https://talk.maemo.org/forumdisplay.php?f=41)

- - [Announce] dbBrowser - Sqlite database browser (https://talk.maemo.org/showthread.php?t=63366)

[Announce] dbBrowser - Sqlite database browser

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

Re: [Announce] dbBrowser - Sqlite database browser

Nice work fcrochik. Look forward to seeing this app evolving - saving changes would be nice so we can really screw up our phones ;)

Re: [Announce] dbBrowser - Sqlite database browser

Quote:

Originally Posted by fcrochik (Post 833466)

Sqlite Database Browser is probably the most complete I found but it seems to depend on qt3

The latest version of Sqlite Database Browser seems to depend on Qt 4.6.

Re: [Announce] dbBrowser - Sqlite database browser

Quote:

Originally Posted by pelago (Post 833646)

The latest version of Sqlite Database Browser seems to depend on Qt 4.6.

It says on the web site that is based on Qt 4.6. but when I try to compile it on scratchbox I get errors because of the missing "Qt3Support" classes. I assume it uses features from qt4.6. but still has dependencies on the old qt3 support classes.

I tried to install the libqt4-qt3support but it fails (seems that was not updated with the latest qt4.6. release).

At any rate, I don't think it would be possible to port it - it would require a complete revamp of the UI.

Re: [Announce] dbBrowser - Sqlite database browser

How do I execute an sql statement after I write it? Should there be a button or something?

Re: [Announce] dbBrowser - Sqlite database browser

shift+enter work's for me
nice app, help me to work with sql base in my player

Re: [Announce] dbBrowser - Sqlite database browser

@fcrochik

In application.cpp, I had to change:

Code:

#else

    m_pMainWindow->show();

#endif

Code:

#elif defined(Q_WS_MAEMO_5) || defined(Q_WS_MAEMO_6)

    m_pMainWindow->showMaximized();

#else

    m_pMainWindow->show();

#endif

in order to stop seg faulting on an n900. I'm guessing this has to do with changes in the most recent Qt libraries and/or development tools.

Love the app!

Re: [Announce] dbBrowser - Sqlite database browser

Quote:

Originally Posted by daperl (Post 1019074)

@fcrochik

In application.cpp, I had to change:

Code:

#else

    m_pMainWindow->show();

#endif

Code:

#elif defined(Q_WS_MAEMO_5) || defined(Q_WS_MAEMO_6)

    m_pMainWindow->showMaximized();

#else

    m_pMainWindow->show();

#endif

in order to stop seg faulting on an n900. I'm guessing this has to do with changes in the most recent Qt libraries and/or development tools.

Love the app!

If that is the case it is a really big bug with Qt. What do you mean by new Qt libraries? CSSU libraries?

Re: [Announce] dbBrowser - Sqlite database browser

Quote:

Originally Posted by fcrochik (Post 1019323)

If that is the case it is a really big bug with Qt. What do you mean by new Qt libraries?

Sorry, by new I meant that I'm using QtCreator 2.1 (Feb 2011?) and the Fremantle PR 1.3 SDK that it installs, but the problem persists when using Scratchbox.

The dbbrowser from the last package you created runs fine, it's when I try and rebuild it "as is" that I get the seg fault. Also, it seems that qmake hardcodes some environment-specific stuff into the Makefile, so I had to first blow away the Makefile from dbbrowser_0.0.3-1.diff.gz and let qmake make me a new one.

Anyway, with the one-line change I mentioned above, everything works fine, but I encourage you to see for yourself. Maybe the Makefile shouldn't be part of the source distribution and the debian/rules file should call qmake. Not sure.

Quote:

CSSU libraries?

No, I'm running a clean PR 1.3.

Re: [Announce] dbBrowser - Sqlite database browser

Im using dbbrowser on sms n900 db and i have a problem:
Does Anybody know how to convert the field storage_time (integer like 1325710163 that contains date and time info) from table 'Events', from el-v1.db, to Datetime format?