On Tue, 31 Jul 2001 22:51:46 +0200, Bojidar Dimitrov wrote: > [...] Later on, when XML support is better, I can change my > script and come up with 220 XML lens pages in a matter of hours. :-) Why? Just modify the scripts to generate XML instead of HTML and create some ?XSL? style scripts. > When I then spoke of putting the entire DB on-line, I didn't mean > generating the pages in real-time, but running things like "SELECT > lensName, lensWeight FROM Lenses WHERE AL = 1" or "SELECT * FROM Lenses > WHERE lensImage = NULL". THis last one is important for me, for keeping > track of the missing data. You could also have the scripts put the generated file names back into the database in appropriate places. Then you could have search CGIs that could do some pretty intelligent searches and get a list of the page file names for the results. Stuff like "I want to see every lens that includes 300mm with a maximum aperture of at least f/4.0", and get back a list of references to the pages that exist instead of re-generating the presentation of all of the items in the hit list. > So, anyhow, the question stays. Is it worth it getting MySQL and Perl > to run on my Win98 machine for the purpose of doing what I have in > mind. Does Perl have a nice DB API? Does anyone have code examples of > DB access using Perl? Perl has a good interface to DBs, and MySQL integrates pretty well with that interface. It's also enough for the amount of data and transactions you're talking about. > I can easily do the same thing using C++ and MS Access, but I am an > anti-Microsoft creature by default. Ditto. :-) > As for typing in the data, I've started, and it goes very fast, so I > will not be needing help there. You could go ahead and XML-ize the actual data (and create yourself a DTD) then use an off the shelf XML parser to populate the MySQL database. :-) TTYL, DougF - This message is from the Pentax-Discuss Mail List. To unsubscribe, go to http://www.pdml.net and follow the directions. Don't forget to visit the Pentax Users' Gallery at http://pug.komkon.org .
