|
Links
Tutorial(in italian)
| Learning to interface databases to the WebThe problemDatabase programs like Access or Filemaker let you manage the information in your organization:but now you want to make their data available on the Web and what is more important, let the people in charge of modifying the information, do this through a Web interface from every computer using the familiar Web form interface.This is a big problem for big databases in big organizations, but in this case we are interested only in small databases (~ 1000 records) in small organizations (a few hundred people). Unfortunately here we have two fields:databases and Internet with a lot of new words that we'll make understanding things very difficult:I'll try to write down a list of these specialized words in this glossary. Some first rough attempts at a solutionNot being a database expert, it is better to start with some simple, down to earth, application.Jon Udell describes in this document how to feed data collected with a Web form to a database for analysis. Instead of wiring the CGI script behind the form directly to the database, he creates a simple Ascii file. Then uses Perl to transform this file in a database input format (specifically a SQL load file). This file is then used to create a standard database and analyze the data. |