HomePage RecentChanges Schema

In a recent chat with Dr-Chuck database schema design came up, and the style used in Rails. And I mentioned it is a fairly standard style, but then I found it difficult to find references on the net. So here is my rules...

Rules?

These rules are good:

Schema

Simple Rules

The Bad and the Ugly

Special Cases

SQL

When writing SQL we also have rules.

Simple rules

Coding style

Perl

Specifically I have a perl example: You can put this in a variable or directly.

#!Perl
my $sth = $dbh->prepare(q{
  SELECT
    id, name
  FROM
    user
  WHERE
   email LIKE ?
});
$sth->execute('%@dd.com.au');

See Also

Software error:

Can't locate object method "endform" via package "CGI" at /data/scott.dd.com.au/wiki/modules/search.pl line 15.

For help, please send mail to the webmaster (webmaster@dd.com.au), giving this error message and the time and date of the error.