phpMyAdmin suggestion
| From: | Daevid Vincent | Date: | Tue, 22 Aug 2000 23:58:04 +0000 |
| Subject: | phpMyAdmin suggestion | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-13044@lists.php.net to get a copy of this message | ||
First off, I love the program! it's a life saver, and makes maintenance a
breeze.
A suggestion I was thinking about would be a way to "fake" populate a table
with 'readable' data.
So there should be a way to say, populate a database table with 10,000 rows
easily with semi-predictable data.
For example, if there was a CHAR field, name it "testa1 - testz9" or
something, I could also see a need for naming things "aaaa" through "zzzz".
If a date field, pick a start date and let it rip through, perhaps with
duplicate dates (randomly?), and INT fields incremented (again, with
duplicates as an option).
One reason this would be helpful, as I'm sure you can imagine, would be to
test large tables and displays. Just recently, I built a database and it
worked just fine, until there were more than 50 rows. Winblows98 and IE5.0
would NOT display it correctly, the display was all kinds of fucked up --
all the select box columns would leave remnants of where they were when you
scrolled until it was unreadable -- yet Win2k worked fine. (for those who
care, upgrading to IE5.01 fixed this 'glitch'). (this was using PHP to
render to a web page). Another interesting thing I noticed is that Nutscrape
took almost 30 seconds to render the exact same page that IE took a mere 3
seconds. What a hunk of shite NS is (and believe me, I *LOVE* Linux and hate
M$ and all that, but let's be honest, there's a reason IE has taken the
market, and it isn't because of marketing. It's just a better product.
period).
Another reason would be to test server loads with millions of records say.
Or test various optimizations without fear of destroying real data.
Yes, I'm sure we all could write a script to do this type of thing, specific
to our own needs, but it seems that phpMyAdmin is a perfect vehicle to do
this sort of thing with, not to mention I don't see many other new features
it could incorporate. It's pretty robust as it is. I LOVE the ability the
new version has to insert a column after another column (vs. at the end of a
table).
daevid.com