RRB <roberto.questovatolto@allservice.anchequesto.it> did eloquently scribble: > Hi to all. (i posted in a mysql NG but no result, so i try here...) > For a client that must change values in some table's fields, i need a simple > browser which allows him to open a mysql table, modify value of fields (or even > add and delete records, but that's not very important) then save and exit. > It should be simply character terminal based (no mysqlcc for example). > Ideally it should be like 'less -S'. Try searching freshmeat. There are some console based db tools. You need to go via environment, select text based console, curses, then search for mysql. -- ______________________________________________________________________________ | spike1@freenet.co.uk | "I'm alive!!! I can touch! I can taste! | |Andrew Halliwell BSc(hons)| I can SMELL!!! KRYTEN!!! Unpack Rachel and | | in | get out the puncture repair kit!" | | Computer Science | Arnold Judas Rimmer- Red Dwarf | ------------------------------------------------------------------------------

On 2007-11-26, rRB <roberto.questovatolto@allservice.anchequesto.it> wrote: > > > The Natural Philosopher wrote: > .... >> Webmin. >> Ideal for this. >> > > A very good tool, but it needs gui and it's web based, too > complicated, i really prefer my client work in a terminal in this > phase. > I'm not familiar with Webmin, but "web based" doesn't necessarily mean "gui". Can Webmin work with lynx or elinks as a browser?

On 2007-11-26, rRB <roberto.questovatolto@allservice.anchequesto.it> wrote: > Hans-Peter Diettrich wrote: >> >> 1. get the table description >> 2. create a screen layout >> 3. get first record >> 4. display the record >> 5. react on key presses >> 6. get and store modifications >> 7. get next record >> 8. goto 4 or terminate > > Depends on what one means for "simple". > In comparison to many other browsers and tools, yes, it is VERY simple; and, > again, simple or difficult, it *doesn't* exist, nobody has thought on such > program as useful, apparently. Either that, or it's too easy to code up. My guess is such a program written in Perl would be on the order of a few hundred lines (or even ~100 lines if you can simplify the layout issues). > I will search more and if i don't succeed, consider writing something on my own, > in the latter case i will ask in usenet which library to use, conveniently. If you have mysql and Perl, use DBI and DBD::mysql. Both are fairly easy to learn the basics, at least enough to write the above. --keith -- kkeller-usenet@wombat.san-francisco.ca.us (try just my userid to email me) AOLSFAQ=http://www.therockgarden.ca/aolsfaq.txt see X- headers for PGP signature information

On 2007-11-27, rRB <roberto.questovatolto@allservice.anchequesto.it> wrote: > Keith Keller wrote: >> >> If you have mysql and Perl, use DBI and DBD::mysql. Both are fairly >> easy to learn the basics, at least enough to write the above. > > This seems to be a good idea, i'll check it as soon as possible... Also, to be thorough, Python has similar libraries for simplifying database access and calls, so you could use that language too. (Java has the same, but I don't know if that would be a simple 100-liner.) --keith -- kkeller-usenet@wombat.san-francisco.ca.us (try just my userid to email me) AOLSFAQ=http://www.therockgarden.ca/aolsfaq.txt see X- headers for PGP signature information

rRB <roberto.questovatolto@allservice.anchequesto.it>: > > Ah, i forgot, something it should surely NOT have is some button with "drop > table" or "drop database"... 8-/ If you're doing backups, why do you care? You are doing backups? :-) -- Any technology distinguishable from magic is insufficiently advanced. (*) http://blinkynet.net/comp/uip5.html Linux Counter #80292 - - http://www.faqs.org/rfcs/rfc1855.html Please, don't Cc: me.

On 2007-11-29, s. keeling <keeling@nucleus.com> wrote: > rRB <roberto.questovatolto@allservice.anchequesto.it>: >> >> Ah, i forgot, something it should surely NOT have is some button with "drop >> table" or "drop database"... 8-/ > > If you're doing backups, why do you care? > > You are doing backups? :-) Instantaneous backups, which can be restored instantaneously? I do backups, but I don't like restoring unless I really have to. Preventing users from doing something stupid seems better than risking a data loss (which, if data is added after the backup is complete, is gone forever). --keith -- kkeller-usenet@wombat.san-francisco.ca.us (try just my userid to email me) AOLSFAQ=http://www.therockgarden.ca/aolsfaq.txt see X- headers for PGP signature information