simple mysql table browser, no gui...

simple mysql table browser, no gui...

Post by RRB » Mon, 26 Nov 2007 21:03:09


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

I'm searching under sourceforge but it seems there are only graphic/php/java
applications.

Any idea?

TIA.

--
Faciait li signeur!

Roy Batty
http://www.yqcomputer.com/
 
 
 

simple mysql table browser, no gui...

Post by Hans-Peter » Mon, 26 Nov 2007 22:07:44


No problem so far.



Then you'll have to rewrite the whole GUI for console. Not a good idea,
IMO - unless you are paid for so much work.

DoDi

 
 
 

simple mysql table browser, no gui...

Post by spike » Tue, 27 Nov 2007 03:19:15

RRB < XXXX@XXXXX.COM > did eloquently scribble:



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.
--
______________________________________________________________________________
| XXXX@XXXXX.COM | "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 |
------------------------------------------------------------------------------
 
 
 

simple mysql table browser, no gui...

Post by rRB » Tue, 27 Nov 2007 08:15:29


...

http://www.yqcomputer.com/

Nice software here, but i did'nt find a table browser.... i will continue
searching in other categories, perhaps....

Thanks anyway...
--
Faciait li signeur!

Roy Batty
http://www.yqcomputer.com/
 
 
 

simple mysql table browser, no gui...

Post by The Natura » Tue, 27 Nov 2007 17:11:55


Webmin.
Ideal for this.
 
 
 

simple mysql table browser, no gui...

Post by spike » Wed, 28 Nov 2007 00:50:41

The Natural Philosopher < XXXX@XXXXX.COM > did eloquently scribble:

Is there ANYTHING it can't do?
--
______________________________________________________________________________
| XXXX@XXXXX.COM | |
|Andrew Halliwell BSc(hons)| "ARSE! GERLS!! DRINK! DRINK! DRINK!!!" |
| in | "THAT WOULD BE AN ECUMENICAL MATTER!...FECK!!!! |
| Computer Science | - Father Jack in "Father Ted" |
------------------------------------------------------------------------------
 
 
 

simple mysql table browser, no gui...

Post by rRB » Wed, 28 Nov 2007 03:04:42


....
...

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.

What i need is a very simple thing like less/mc/vfu style.
Something like: MySimpleBrowser Database TableToBeEdited

Somebody might remember there was something similar in clipper.

ALl the table (select * from ...) displayed. Browsing with arrows, fill the
fields, then save+exit. That's all. Can be limited in records or field, no
problem, the table to be edited aren't big.

Too simple, perhaps it does'nt exist... :-)

--
Faciait li signeur!

Roy Batty
http://www.yqcomputer.com/
 
 
 

simple mysql table browser, no gui...

Post by rRB » Wed, 28 Nov 2007 03:13:45


...
...

Ah, i forgot, something it should surely NOT have is some button with "drop
table" or "drop database"... 8-/

--
Faciait li signeur!

Roy Batty
http://www.yqcomputer.com/
 
 
 

simple mysql table browser, no gui...

Post by Bill Marcu » Wed, 28 Nov 2007 03:26:24


I'm not familiar with Webmin, but "web based" doesn't necessarily mean
"gui". Can Webmin work with lynx or elinks as a browser?
 
 
 

simple mysql table browser, no gui...

Post by Hans-Peter » Wed, 28 Nov 2007 05:34:34


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

Optionally: handle records that don't fit in one screen...

Simple? ;-)

DoDi
 
 
 

simple mysql table browser, no gui...

Post by rRB » Wed, 28 Nov 2007 07:18:10


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.

I'm sorry of this, but i think it's because most people like gui things, where
many application can better run in character/console mode, consuming far less
cpu and ram.

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.

Thanks anyway for the nice conversation.
--
Faciait li signeur!

Roy Batty
http://www.yqcomputer.com/
 
 
 

simple mysql table browser, no gui...

Post by Keith Kell » Wed, 28 Nov 2007 14:24:01


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


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

--
XXXX@XXXXX.COM
(try just my userid to email me)
AOLSFAQ= http://www.yqcomputer.com/
see X- headers for PGP signature information
 
 
 

simple mysql table browser, no gui...

Post by rRB » Thu, 29 Nov 2007 02:52:36


...

Approx it was my esteem, too. (it remains a "simple" task even if it has to be
doubled...)


This seems to be a good idea, i'll check it as soon as possible...

--
Faciait li signeur!

Roy Batty
http://www.yqcomputer.com/
 
 
 

simple mysql table browser, no gui...

Post by rRB » Thu, 29 Nov 2007 02:54:23


...
...


It's for a client, i cannot give him vi or even a simpler text editor, i'm
afraid it will end up in corrupted fields and lot of problems....

--
Faciait li signeur!

Roy Batty
http://www.yqcomputer.com/
 
 
 

simple mysql table browser, no gui...

Post by Florian Di » Thu, 29 Nov 2007 03:54:06


Dump the table with mysqldump to a text file, edit it and import it again
using mysqlimport



Florian
--
< http://www.yqcomputer.com/ ;
-----------------------------------------------------------------------
** Hi! I'm a signature virus! Copy me into your signature, please! **
-----------------------------------------------------------------------