[sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite
Chris Green
database using a 'grid' layout of the data. I.e. I want the existing
contents of the database displayed as a table and I want to be able to
click on a field in a row and just edit the data in place. In addition
I want to be able to use the TAB key to move from field to field
(another key would be OK, just not the mouse). There should be an empty
row at the bottom for entering a new row.
I'm happy to use a design tool of some sort to do this although a ready
made application would be easier/quicker of course. I don't want to
code the whole thing from scratch though.
What I want is what MS Access calls a tabular form in its design wizard
and is also what it presents you with by default if you open a table
directly.
I need this to run under Linux as a desktop application or alternatively
a web application would be fine, I have apache2 with PHP etc. running on
my desktop machine here.
I've searched around quite a lot for something that can do this for me
but haven't found anything yet. There are lots of database management
programs (such as sqlitebrowser and sqliteman) but while they do a good
job of managing a database they're really not built for entering data.
I just want an executable I can run with database name and table name as
parameters, e.g.:-
myDataEditor somedatabase.db tablexyz
... and it fires up a window with the rows/columns in a grid and allows
me to edit. I don't want to have to navigate through menus and options
to get there.
Any ideas or suggestions would be very welcome.
--
Chris Green
_______________________________________________
sqlite-users mailing list
sqlite...@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Matt Young
Looks great if you operate from a browser. Can we still get sqlite
embedded into the browser, or do we have to plug it in?
Chris Green
> http://javascriptsource.com/forms/dynamic-table.html
> Looks great if you operate from a browser. Can we still get sqlite
> embedded into the browser, or do we have to plug it in?
>
row you have to click on the row and then move up to the row at the top
and change the values there. ... and *then* you have to click on the
Update Table button to put the values back into the table.
noel.frankinet
Hello Chris,
You should look at Dojo javascript library, I think they have the widget
you are looking for. Of course you still need the back-end plumbing (PHP
I suppose).
Best wishes
Noël
Chris Green
> Le 17/01/2012 18:15, Chris Green a écrit :
>
> Hello Chris,
>
> You should look at Dojo javascript library, I think they have the
> widget you are looking for. Of course you still need the back-end
> plumbing (PHP I suppose).
That seems rather a long way (in terms of the amount of programming that
would be involved) from where I want to be. Dojo appears to be an
excellent general purpose Javascript framework but doesn't really
address my requirement directly.
Note that while I *could* use a web application that isn't a
requirement, a native Linux application running on my desktop is all I
actually need.
David L
If you want MS Access-like functionality, it might be worth a try.
Note that Base uses HSQLDB as it's default backend, but you can replace
it with SQLite
Please see:
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Using_SQLite_With_OpenOffice.org
Regards,
David
_______________________________________________
da...@dandymadeproductions.com
entered via keyboard for add, edit, delete, etc. for data manipulation.
Free and open source.
http://sourceforge.net/projects/myjsqlview/
To use with SQLite download Xerial JDBC and install in java/lib/ext/
directory.
http://www.xerial.org/trac/Xerial/wiki/SQLiteJDBC#WhatisdifferentfromZentussSQLiteJDBC
danap.
> -- Chris Green