RSmith <[email protected]> wrote: > > On 2014/06/03 16:07, [email protected] 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. > MS Access provides *exactly* what I want 'out of the box' a grid view of the database table that is editable in place. What I see as 'complex' is all the database adminstration bits that I specifically don't want.
OK, I know Access is a huge application but the grid editing form is the *default* way to edit data. > 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, Er no, I'm just asking for no other function than the ability to enter and edit data. What I want to be rid of is all of the ability that most applications provide for creating tables, creating and editing queries, changing tables, etc. etc. > 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--). > I already have a 'LAMP' system, i.e. a web server (with several apps running on it), database, PHP, etc. I don't mind installing things but I don't want to have to 're-invent the wheel'. > May I suggest plagiarising the open source MySQL viewer engine called > phpMyAdmin, > they have awesome generic table editors that I have phpmyadmin and use it a lot but it's *MILES* away from what I want. This is what I've been trying to explain, firstly I want none of the database administration stuff, secondly I want it to be easy to edit the data, in phpmyadmin editing data is clumsy. > 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. > Both places where I want to run this are Linux boxes so a desktop application would be fine, however I have yet to see a desktop API that makes it easy to do this. -- Chris Green ยท _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
