On 2014/06/03 16:07, c...@isbd.net wrote:
I'm looking for an application (or *simple* development framework)
which will provide me with an easily accessible grid form for entering
data into a table.
Requirements:-
This can be a web app or a [Linux] desktop one though I have a
slight preference for a web app.
Must be able to launch straight into the grid, no navigation
through menus etc. This rules out OpenOffice/LibreOffice really.
I want to be able to say:-
gridform <database> <table>
or the equivalent in a link. A 'SELECT' in addition would be fine
just as long as it can all be done in one go when launched (or
linked to).
I want a 'clean' form, just the form, no menus or other clutter
(similarly rules out OpenOffice/LibreOffice).
Simple 'in form' data editing, just click on a field and change
its data, on exiting the field the data is saved. No pop-up boxes
for data entry, no 'Save' buttons.
Add rows at the bottom either by TABbing off the last field or
possibly have a blank row at the bottom (like MS Access).
That's it really, I've no need for the ability to add columns, modify
the database or anything like that (it will be done elsewhere). I'm
happy to do some programming, I'm resonably proficient in PHP and
Python (and C/C++ for that matter but I don't think I want to go
there). I don't really want to have to install a whole web (or other)
development framework just to do this though so I probably want
something that's specifically aimed at databases if I'm going to
program it.
Your requirement is unrealistic.
You do not want to install anything that makes this happen for you, yet you
want very complex abilities.
Usually, presenting a very "clean" interface to a user requiring no other interface goodies means that you need to do a lot of the
thinking for them - user simplicity means programming complicatedness, and programming simple things means the user ends up with
complicated GUI methods. Which do you want, simple to make, or simple to use? They are mutually exclusive.
I have done this a few times, using mostly flash (which I can send you demo log-ins for if interested) and in HTML5+PHP with a few
tricks you should be able to achieve similar if you are very familiar with web/html/php development. (I say PHP but it's doable in
ASP.Net etc. too if needed). I do not know if installing a web server or PEAR/PHP/ASP etc. services violates your "Don't want to
install stuff" requirement. Also, you cannot just load say 7 million edit fields into an HTML file... it will fail miserably.. so
you will need to use data windowing (simplicity--).
May I suggest plagiarising the open source MySQL viewer engine called phpMyAdmin, they have awesome generic table editors that
interfaces a MySQL DB on a web server based off PHP. Just install it onto your local system, all the PHP files which achieve the
fields editing will be in one folder. It will take some work still.
A desktop App will be easy too, but only usable on whatever platform it is
made. Web apps can work anywhere.
Not sure if this answers the question or raises more questions, either way I
hope it helps a bit.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
