Re: SQL for presentation

frebe73_at_gmail.com wrote:

>>>At this forum, it is often claimed that almost all kind of data
>>>transformation could be done using SQL select statements.
>>
>>Many of us think SQL should be abandoned entirely so I am not quite sure
>>where you got that idea.

>>>In web applications, the presentation - HTML - is a data structure. If
>>>select statements could make almost any kind of data transformation,
>>>why couldn't we use select statements to produce the HTML text?
>>
>>Relations state facts. That is not to say that relations state the same
>>facts in any arbitrary structure or with any arbitrary formatting.

Yes, that was already implied further in my reply below.

>>  I see a
>>
>>>problem in the fact that HTML is hierachial and select statements
>>>doesn't seem suitable for returning hierachial results. But what if a
>>>relational version of HTML existed, would the select statement be
>>>suitable for buildning the GUI too?
>>
>>If you are asking whether one could devise a relational schema to
>>describe a document or user interface, the answer is obviously yes.

If one has a relational description of a document or user interface, why on earth would one bother with HTML? Received on Thu Jul 06 2006 - 00:21:02 CEST