Comments on: MySQL to set Falcon free

Open-source database company to provide technical details on homegrown storage engine, administration tools.

[SQL_Apprentice]

ANSI

Remember write ANSI SQL

Rows are not records; fields are not columns; tables are not files!!

http://joecelkothesqlapprentice.blogspot.com/

[Thomas, David]

Ummm

Look, I really don't want to throw cold water on you. The
implementation of an ANSI standard SQL DBMS, is not restricted
to a vision of "Rows are not records, etc", in truth its, well,
wrong.

However, I was intrigued by this statement, so I decided to take
a look at your site. There is nothing wrong with pushing
yourself, but you must be careful about forming strong views,
that could be based on an assumption. I guess I'm saying its ok
to be wrong, just be aware that sometimes, especially within the
first five years of coding, when you think you're absolutely right
you can be absolutely wrong. Unfortunately, this "affliction"
occurrs throughout ones career, but with far less frequency with
experience.

So, instead of being critical, which is a good thing if you can
learn from it, I am including something for you to look at (in
reference to your link):

CREATE TABLE [Suburbs]
(
[id] INT IDENTITY(1, 1) PRIMARY KEY,
[suburb] VARCHAR(50) NOT NULL,
[state] VARCHAR(2) NOT NULL
)
GO
CREATE TABLE [Surrounds]
(
suburb_id INT REFERENCES [Suburbs]([id]) ON DELETE CASCADE,
[n_suburb_id] INT REFERENCES [Suburbs]([id]) ON DELETE NO
ACTION
)
GO
CREATE UNIQUE INDEX ucix ON [Surrounds]([suburb_id],
[n_suburb_id]) WITH IGNORE_DUP_KEY
GO