Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

2012-01-18 Thread danap 
I think MyJSQLView should do what you suggest. Most of the commands can be
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.

> I'm after an application which will allow me to enter data into a sqlite
> 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-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

2012-01-18 Thread David L 

Have you checked out "Base" from OpenOffice.org?
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


Chris Green skrev 2012-01-17 17:05:

I'm after an application which will allow me to enter data into a sqlite
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.



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

2012-01-17 Thread Chris Green 
On Tue, Jan 17, 2012 at 06:21:48PM +0100, noel.frankinet wrote:
> 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.

> Best wishes
> 
> Noël
> 
> >On Tue, Jan 17, 2012 at 08:36:11AM -0800, Matt Young wrote:
> >>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?
> >>
> >That doesn't really do it for me, it doesn't edit in situ.  To edit a
> >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.
> >
> >>On Tue, Jan 17, 2012 at 8:05 AM, Chris Green  wrote:
> >>
> >>>I'm after an application which will allow me to enter data into a sqlite
> >>>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-users@sqlite.org
> >>>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >>>
> >>___
> >>sqlite-users mailing list
> >>sqlite-users@sqlite.org
> >>http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

-- 
Chris Green
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

2012-01-17 Thread noel.frankinet 

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).

Best wishes

Noël


On Tue, Jan 17, 2012 at 08:36:11AM -0800, Matt Young wrote:

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?


That doesn't really do it for me, it doesn't edit in situ.  To edit a
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.


On Tue, Jan 17, 2012 at 8:05 AM, Chris Green  wrote:


I'm after an application which will allow me to enter data into a sqlite
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-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

2012-01-17 Thread Chris Green 
On Tue, Jan 17, 2012 at 08:36:11AM -0800, Matt Young wrote:
> 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?
> 
That doesn't really do it for me, it doesn't edit in situ.  To edit a
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.

> On Tue, Jan 17, 2012 at 8:05 AM, Chris Green  wrote:
> 
> > I'm after an application which will allow me to enter data into a sqlite
> > 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-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

-- 
Chris Green
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

2012-01-17 Thread Matt Young 
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?

On Tue, Jan 17, 2012 at 8:05 AM, Chris Green  wrote:

> I'm after an application which will allow me to enter data into a sqlite
> 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-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

2012-01-17 Thread Chris Green 
I'm after an application which will allow me to enter data into a sqlite
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-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users