Notices

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:-











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

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!

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

0.0.2 released to fix

Keep 'em coming

Rick

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

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

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

One word ;
Awesome !!

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

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

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