[htdig3-dev] Creating a SQL backend...

[tomi]

Hi guys,   This topic (creating a SQL backend) has been added to the TODO list. I studied a little the problem and I had a little discussion on it with Geoff Hutchinson. It is a great step forward creating databases directly in SQL based formats: 1) it is much more reliable; 2) considering many cases a webmaster or a system enginer could face (very huge databases, Clustering, RDBS, etc.), SQL is the best way to overflow any problem, thanks to the engines of databases as Postgres or mySQL (just to cite only GNU projects).   Creating an SQL database is not difficult: infact, if we want to create, for example, the table employee, we should simply follow the following statement:   create table employee (first varchar(15), last varchar(20), age number(3), address varchar(30), city varchar(20), state varchar(20));   The procedure to create a table than is the following: to create a new table, enter the keywords create table followed by the table name, followed by an open parenthesis, followed by the first column name, followed by the data type for that column, followed by any optional constraints, and followed by a closing parenthesis. It is important to make sure you use an open parenthesis before the beginning table, and a closing parenthesis after the end of the last column definition. Make sure you seperate each column definition with a comma. All SQL statements should end with a ";".   Will follow other specifics to insert and modificate datas if You'' ll require. Yhis e-mail was only to demonstrate the ease of creating SQL tables and databases.   Ciao tomi