Re[2]: Fwd: Re[2]: New html-element: table3

Good day, Jonas.

>> Can low-skill users write program (for example, by perl or php),
>> which convert 3 rational table (from DBMS) into 1 browser table ?
>> No.
>> In better case, users can write 3 simple request to DBMS and
>> merge result into output
JS> Most DBMS'es can order data such that it can be outputted directly in a
JS> row-by-row order. At least I have never interacted with a DBMS where I
JS> couldn't take the output and directly dump it to HTML.

There is always gasket (shim) between SQL (pure DBMS) and HTML (browser).
Gasket is additional language,
which is often un-available for low-skill users.
It's very reasonable to turn job in intermediate language
into job in SQL.

Pay attention at low-skill users,
you always think about theory.
It's possible to do all - in theory,
but not possible with real low-skill users.

JS> "ORDER BY field_i, field_j"

Lets use term "name" for name of columns/rows,
and use term "data" for content of cells.

In real multi-dimensional case (10D, 15D)
"field_i, field_j" are not equal to
serial number (of columns, of rows) for visualization on display -
they exist only for bond with data (which will be in cell on display).

Usually table with names has one more field
(for example, "ser_i", "ser_j"),
which contain serial number of columns/rows.
It's necessary to write "order by ser_i, ser_j"
for output names of columns/rows.

Thus it's necessary to sort data by "ser_i, ser_j" of names.
It's additional (i think - un-necessary) job for low-skill users.

P.S.
Really programmers are small percent of all users.


Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru

Received on Thursday, 26 April 2007 09:09:27 UTC