FloppyShop online - ALPHA
Myself and my girlfriend have spend many days in reorganising the floppyshop database into a online searchable one. The entire floppyshop gold series is now online with a searchable database and every file is downloadable. http://exxoshost.co.uk/atari/PDL/FLOPPYSHOP/index.htm
I had to put captcha in there to stop leechers as there are some GB's of files. I don't know why people leeching the stuff on my site as mostly the ISO's are available on other sites anyway. Anyway, you can search by key word or phrase, or browse the entire section. Keywords are highlighted in the search results. Be warned that the browse section can output a LOT of pages, so if you have a crappy PC it will most probably crash it. In that case, tough
Search results can be limited to 10 or 50 results anyway.
There are a lot of disk (mostly ST ones) where the info was just one large block of text. But it is separated into separate lines on the Falcon disks. I'm not going to spend time on tidying up the ST info's at least not anytime soon, as there are thousands of files where there can be several or more programs on each floppy, thats a huge undertaking. A lot of text files I had to write scripts to extract the info and sort it out into separate disk chunks. That took a huge amount of time in itself.
I also was planning on having a SQL database for this stuff, but after doing some testing, it was over 10 times faster to do a simple text file read and read in the whole file and parse it than calling a single read on a SQL database. Sometimes SQL was over 100 times slower, probably a slow down in opening up a connection to the database. Anyway, after much faffing about, I just went with plain text files for the database. At least then making changes to text files is easy, and I don't have to write a script to do the changes
The timings were done in milliseconds, so either method is fast anyway. But for this particular setup, text file database is a whole lot easier and faster.
In anycase, AFAIK there isn't any bugs, but no doubt there will be some somewhere.. If the site screws up unexpectedly, I may be working on the scripts, but probably will be no tweaks until I get some bug reports back from people.
Once the core is stable (It should be now anyway) I may look into putting up other PDL's online in a similar way. I guess it depends if people find the site useful or not.