phpMyAdmin suggestion

From: 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

« previous php.general (#13044) next »