Re: Does a spreadsheet-like front end exist for MySQL?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

maybe this tools can help:

MySQL Administrator
MySQL Query Browser
MySQL Migration Toolkit

All are available on mysql site, try http://dev.mysql.com/downloads/gui-tools/5.0.html

HTH
Piotr

--- On Mon, 4/6/09, Bill Mudry <billmudry@xxxxxxxxxx> wrote:

From: Bill Mudry <billmudry@xxxxxxxxxx>
Subject:  Does a spreadsheet-like front end exist for MySQL?
To: php-windows@xxxxxxxxxxxxx
Date: Monday, April 6, 2009, 4:01 PM

I use phpmyadmin a lot. It lacks one feature that I wish existed. You can edit only
one record at a time, and when you are editing a lot of data manually, the amount
of time it takes to open up each record and the time for so many saves can add
up noticeably.

I remember using a front end for MySQL a few years ago that worked much like
a spreadsheet. You could hop around putting data into a page full of records at
will, just like you can with a spreadsheet. You then save at any frequency you
wish. I found this so efficient. It also gave a convenient overview of a whole
screenful of records.

I have and will have for some time to come a need to do a lot of manual data
input. The usual method of a form opening for editing only one record at a
time I find far slower and less efficient than this spreadsheet-like front end.
It was being used by a group of programmers in Albany, N.Y. and I have
no idea where they got it from.

I should mention ---- this was *not* simply a spreadsheet in which you added data
and then had to import into MySQL each time. The action of saving would update
the database in use every time (--- ie. really simple to use). I seem to remember
that you could even scroll through data. You could easily add, delete or change.
You didn't have to declare which one of these actions either.

Do any of you know of such a front end (to MySQL) that exists? Is there a
cost or is there an open systems free program that fits?

I imagine to create one would be fairly complicated since the whole sheet of
records is always present as you add data. You simply plopped in data in
cells randomly as you wish and saved once in a while. Any idea what it would
take to code such a program?

<fingers crossed> I hope there is such a program already instead.

Bill Mudry
Mississauga, Ontario


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux