We have moved to a new Sailfish OS Forum. Please start new discussions there.
15

[Request] SQLite Database app frontend

asked 2014-10-18 21:11:57 +0200

melg01 gravatar image

updated 2014-11-26 11:01:12 +0200

eric gravatar image

[Edit Nov. 16th] I've realized there is a sqlite3 client for the command line. Any hint or example how to use it (or libsqlite3) within a Qt program?

This wish is similar to the just posted question about a native Spreadsheet app (see https://together.jolla.com/question/59380/native-app-spreadsheet/): a native app offering a frontend interface to the installed SQLite database would be a great thing. Of course, it should not run as root, or you could mess with many important system DBs. But having a way to store data in a modern way and be able to query with some SQL based filters would be great. The output would have to be in some table format, hence the relation to the mentioned question about a spreadsheet (reusable widget).

edit retag flag offensive close delete

2 Answers

Sort by » oldest newest most voted
2

answered 2014-10-20 09:49:53 +0200

Rolfa gravatar image

There is an extension for Firefox (https://code.google.com/p/sqlite-manager/) but I'm not sure whether this would work with the Jolla browser.

edit flag offensive delete publish link more

Comments

1

This would probably only work well inside the Android/Dalvik container. I'm thinking more about something based on Qt-SQL and Qt-Widgets (both Qt5), like here:

http://qt-project.org/doc/qt-5/qtsql-sqlbrowser-example.html

Anyone interested in porting this example for Jolla? I think Sailfish-Silica might not be adequate for this kind of app.

melg01 ( 2014-10-20 10:46:46 +0200 )edit
2

answered 2014-11-17 20:29:36 +0200

toner_cloud gravatar image

I'm puzzled as to why you think Sailfish-Silica might not be adequate for this kind of app when there was a version for the N900. Take a look http://my-maemo.com/software/applications.php?fldAuto=1928&faq=58 for details.

Why not try and contact Felipe Crochik and ask if he's interested in porting it to Sailfish?

edit flag offensive delete publish link more

Comments

Thanks for the link! I will try to contact the author of this sqlite client. Regarding Sailfish-Silica, I am really a newbie on this, I had only a quick look at some Qt-Quick or Qt-Widgets grid components in Qt-Creator and didn't find equivalent ones in Sailfish-Silica. Any hint would be greatly appreciated.

melg01 ( 2014-11-18 01:53:13 +0200 )edit

Hi there. is there any progress on this?

groxxorg ( 2016-01-17 14:16:04 +0200 )edit
Login/Signup to Answer

Question tools

Follow
3 followers

Stats

Asked: 2014-10-18 21:11:57 +0200

Seen: 1,220 times

Last updated: Nov 17 '14