Announce - New app datable - (Personal Database utility)
 

I have released 0.0.1 alpha version of datable.

datable is a gui front end to sqlite3.

you can create new databases, open existing databases ad and delete tables and add and delete rows. There is the start of a query builder ( this is where development will be concentrated ). The app can be downloaded from :-

EDIT:- Fri 25 Jan -I will keep the link below at the latest version.

EDIT:- Fri 18 Jul 16:00 changed link to version 0.4-1

EDIT:- Tue 29 Jul 1800 fixed screen size problem and also a small presentation bug on Default Form.

EDIT:- Mon 4 Aug 9:25 Pm Fixed SQL insensitive SQL exec button + improved GUI for Default Form

EDIT:- Tue 5 Aug 9:30 PM applied path from Dmitry Makovey to improve freestyle SQL + a couple of other bugs.

https://garage.maemo.org/frs/downloa...-0.4-4_all.deb

some screen shots:-

Attachment 859

Attachment 861

Attachment 863

Attachment 864

Attachment 865

EDIT: You will need python 2.5 installed.


THERE WILL BE BUGS.

All bug reports, improvements and suggestions gratefully recieved

A help doc will follow.

Thanks
Ric

Re: Announce - New app datable
 

When you have no databases (i.e. starting new), you get an error on the line that says "return true" (147 I think). It should be "return True" and it works.

Looking good, I will watch for updates!

Re: Announce - New app datable
 

Thanks BooOfSnoo
That must have slipped in at the last minute.

0.0.2 released to fix

Keep 'em coming

Rick

Re: Announce - New app datable
 

New bugfix release 0.0.3

https://garage.maemo.org/frs/downloa...-0.0.3.all.deb

This release should even be usable :) :)

Some help:-

Tab 0

Blatent advertising

Tab 1 ( Databases and Tables )

- This is where you will open/create databases.

- When selecting a database the list of contained tables will be displayed.

- When selecting a table a 'SELECT * FROM' query will be run
Tab 3 will be displayed and the records listed.

- There are 5 database icons on the toolbar with the following functions:-
1 Create New Database.
2 Open existing Database.
3 Remove selected Databse from the list ( does not delete the file ).
4 Insert a new table in the selected database.
5 Delete a table from the selected Database.

Tab 2 ( SQL )

The autogenerated SELECT query is displayed in an editable textbox. Any
valid SQL for the selected Database should be possible here ( beta software
alert ). The only available icon on the toolbar should be 'Run'.
Selection 'Run' should ( after completion of the Query ) switch to Tab 3.

Future developement will be concentrated here!

Tab 3 ( Records/Rows )

There are three selectable Icons here.
1 'Save' list to file (currently hardcoded to /home/user/recsout.csv)
This will also raise a confirmation dialog with two Buttons 'Ok' and
'Open in Gnumeric'. Gnumeric must of course be installed to use this.
The file will be saved either way.
2 'Insert' a new record into the currently selected table.
3 'Delete' the currently selected row from the currently selected table.
For now be carefull with 'Delete' with user defined SQL

Some Keybindings

Up - hide/reveal notebook tabs and toolbar (Toggle)
Down - hide/reveal notebook tabs and toolbar (Toggle)
Right - Notebook page right
Left - Notebook page left
Fullscreen - Fullscreen (Toggle)
Escape - Exit ( Escape is the rotating left arrow )

enjoy
Rick

Re: Announce - New app datable
 

Thank you Rick! I've been looking for a HandBase replacement.
Frank

Re: Announce - New app datable
 

FGol
If I end up with half the functionality of HandBase I'll be amazed :) :)
Rick

Re: Announce - New app datable
 

One word ;
Awesome !!

Re: Announce - New app datable
 

Has anyone been successful in importing data into sqlite? I've found some shareware utilities but wonder if there are other import options anyone's used.

Frank

Re: Announce - New app datable
 

FGol

If you have sqlite3 installed ( dbs are transferable so you can use your PC )

sqlite3 databasename
From the sqlite3> prompt
.mode csv ( or tabs,sql etc )
.import <filename> <tablename>

You must obviously have the right columns in the right order etc.

You could also wait a few days :) :)
I'm just finishing 0.0.4 ( open and save dialogs for dbs and output files + the start of a settings page ).

After that I intend to add an import facility (probably just comma or tab seperated).

Rick

Re: Announce - New app datable
 

There may be a slight delay in releasing 0.0.4. I have only now realised that gconf is not available in pymaemo and I have added gconf functionality to my settings page. I will have to look at gconftool-2 or maybe use the dtdb.db in ~/.datable - watch this space.

I may just bypass settings for now and concentrate on cvs input.

Rick