Always about the program I descrived above… it was for a friend who is growing sweet basil and had just the need to print bills and to gather results from them.
We started in the '90 with a FoxPro database, and it ran perfectly on a single 486.
When Fox Software was bought by Microsoft, we try to convert the database to the less expensive Access, but it was a resource hog, five times slower than the older database.
Also, my friend moved from basic farming to "basil mashing", to supply some pesto sauce local makers with a product converted just a few hours after picking (sweet basil oxidize quickly and become dark when mashed, so the fast you work it the better is the result).
Did you ever see a sweet basil field? Here is one, almost ready to be picked:
While my friend was improving his "picking machine" to make it faster (he is mechanically skilled, too) I made that Perl+MySql program told before, to keep trace of everything, even things not required by law but useful for a farmer (including the weather and temperature when the basil was picked). I even add a PDF generator for bills, which automatically send them via e-mail too.
At that point the procedure went beyond an hobbyist phase, and I passed it to another friend who has a small software house.
The last "hack" I made was pretty hardware based: my friend bought a Zebra high-speed printer to label his sauce buckets, but it had just Windows drivers.
Being a serial printer, I "sniffed" the signals sent by Windows and wrote a very simple C program sending to the printer signals in the same format, but taking all the data from my database (my version made fancy drawings, too :biggrin
rather than having to compile every label set by hand.
The printer salesman was pretty impressed by that… but he told me the most of their income was from computer assistance (machines "tuned" by the usual know-it-all "computer genius" using the same PC for both working and keeping viruses on the net) so they prefer to keep their printers just under the most lucrative Windows…