pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedWe all are looped on Internet: request + transport = invariant
29+ messages / 9 participants
[nested] [flat]
* We all are looped on Internet: request + transport = invariant
@ 2007-04-13 07:58 Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 29+ messages in thread
From: Dmitry Turin @ 2007-04-13 07:58 UTC (permalink / raw)
To: pgsql-sql
Usage of database consist of
request and transportation of results into visualizer.
We all are looped on Internet, thus visualizer should be remoted.
The most general format for data is XML.
We also need to choose transport protocol:
the most widespread is HTTP.
SQL could send data so.
Now SQL don't make this, thus we need one more language (php,etc).
It's very, very bad for un-experienced user.
We dream, that we simplify SQL by reject of this feature,
but really we only carry un-triviality into other language.
Un-triviality is saved !
But in addition to un-triviality, you have place of dock
between SQL and other language.
I offer the following way:
http://sql40.by.ru/site/sql40/en/author/introduction_eng.htm
http://sql40.by.ru/site/sql40/en/author/determination_eng.htm
Representation of data as tree (instead of as matrix) is not aim itself,
it's sideline-result.
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
@ 2007-04-13 15:09 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
0 siblings, 1 reply; 29+ messages in thread
From: Andrew Sullivan @ 2007-04-13 15:09 UTC (permalink / raw)
To: pgsql-sql
On Fri, Apr 13, 2007 at 10:58:12AM +0300, Dmitry Turin wrote:
> The most general format for data is XML.
Surely not. In particular, XML is actually miserably bad at
capturing certain kinds of relations between items. It's in fact
this assumption that has made this conversation seem like we're
talking past one another.
> Now SQL don't make this, thus we need one more language (php,etc).
> It's very, very bad for un-experienced user.
So what? If a user has no experience, and wants to do something new,
why should they not have to do some work to learn how to do those
things? SQL is not so fantastically hard that you can't learn it.
Indeed, I'm pretty sure that if someone as foolish as I can learn it,
anyone can.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
If they don't do anything, we don't need their acronym.
--Josh Hamilton, on the US FEMA
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
@ 2007-04-19 06:08 ` sql4-en@narod.ru
2007-04-19 06:26 ` Re: We all are looped on Internet: request + transport = invariant Andrej Ricnik-Bay <andrej.groups@gmail.com>
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 2 replies; 29+ messages in thread
From: sql4-en@narod.ru @ 2007-04-19 06:08 UTC (permalink / raw)
To: pgsql-sql
>In particular, XML is actually miserably bad at capturing certain kinds of relations between items.
Write examples, please.
P.S. By the way, XML is mentioned as tool for traffic (for transport).
But i agree to forget about that to learn what are you imply in your
quoting.
>SQL is not so fantastically hard
You don't understand, i speak not about SQL!
Problem consist of transportation data, received by SQL, into external
world. As i already wrote, it's very difficalt for users (in practice)
to use libraries of additional language (php , perl, etc) for that.
I offer to put one feature into SQL to avoid mentioned libraries.
>why should they not have to do some work to learn how to do those things?
For what user agonizes, if it's possible to avoid torments?
Assembler turns Fortran by this reason.
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
@ 2007-04-19 06:26 ` Andrej Ricnik-Bay <andrej.groups@gmail.com>
1 sibling, 0 replies; 29+ messages in thread
From: Andrej Ricnik-Bay @ 2007-04-19 06:26 UTC (permalink / raw)
To: sql4-en@narod.ru; +Cc: pgsql-sql
On 4/19/07, sql4-en@narod.ru <sql4-en@narod.ru> wrote:
> Problem consist of transportation data, received by SQL, into external
> world. As i already wrote, it's very difficalt for users (in practice)
> to use libraries of additional language (php , perl, etc) for that.
>
> I offer to put one feature into SQL to avoid mentioned libraries.
And you offer latex and all other kind of things, too?
That's the whole issue: you don't understand. SQL is for
information retrieval, presentation thereof is and should (for
a clean design) be independent of the retrieval. There's
already a highly popular database out there that breaks
and "enhances" standards. And there are tools available
that will take tabular textual data and convert it into other
file formats; no need to turn postgres into an egg-laying
wool-bearing milk-sow.
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
@ 2007-04-19 13:48 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Bart Degryse <Bart.Degryse@indicator.be>
1 sibling, 2 replies; 29+ messages in thread
From: Andrew Sullivan @ 2007-04-19 13:48 UTC (permalink / raw)
To: pgsql-sql
On Thu, Apr 19, 2007 at 09:08:27AM +0300, sql4-en@narod.ru wrote:
> >In particular, XML is actually miserably bad at capturing certain
> >kinds of relations between items.
>
> Write examples, please.
>
> P.S. By the way, XML is mentioned as tool for traffic (for transport).
> But i agree to forget about that to learn what are you imply in your
> quoting.
That's irrelevant to what you are proposing, because what you are
proposing is to alter SQL -- or at least, PostgreSQL -- to break the
relational model of SQL in order to make it look more like XML.
An obvious example of the way XML is not _good_ at expressing kinds
of relations is that it simply doesn't have a way of expressing
foreign key relations. If you want that sort of thing, you write a
DTD that somehow says two things go together; but it can't enforce
it, because that has to be left to the implementation. Moreover,
since you seem to want to make this perfectly generalizable to any
XML at all, what you really are saying is that you'll give up the
feature.
Every time someone helpfully comes along and says that SQL doesn't
"really need" this or that feature because of some special purpose
application that they have dreamed up, I have exactly the same
reaction: those proposing picked a SQL database because it's what
they had, rather than what they need. This case is no exception.
You have so far completely failed to explain why any of what you are
proposing ought to be stored in PostgreSQL in the first place. What
is wrong with flat files? Or bdb? Or something like that? Not
every datum belongs in a relational database.
More importantly. . .
> You don't understand, i speak not about SQL!
>
> Problem consist of transportation data, received by SQL, into external
> world.
. . .you have completely missed the point of SQL, then. It's a
special-purpose language, unconcerned with transport, that is there
to perform queries on relational data. If you want some magic
transport thing that doesn't need a special library to get it out of
Postgres (and you seem here to have completely overlooked that you
_always_ have to have one: someone who won't learn DBI and won't
learn SQL sure as heck isn't gonna learn enough C to program libpq,
which is actually how you talk to the PostgreSQL back end), then
write that. Don't bollocks up the back end and change the syntax of
SQL to achieve what is, IMNVHO, a really bad idea.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
Users never remark, "Wow, this software may be buggy and hard
to use, but at least there is a lot of code underneath."
--Damien Katz
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
@ 2007-04-20 09:08 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
1 sibling, 1 reply; 29+ messages in thread
From: Dmitry Turin @ 2007-04-20 09:08 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; +Cc: pgsql-sql
>you are proposing is to ... break the relational model of SQL
No. I'm proposing to add new thinking about relational model
(primary i want to write "to add new view", but i remember, that
"view" is reserved word in SQL :) ).
Сonvince yourself, please:
create table a (
id num primary key;
data float;
);
create table b (
id num primary key;
ref num references a(id);
data float;
);
create table c (
id num primary key;
link num references b(id);
data float;
);
insert into a values (1, 12.3);
insert into b values (10, 1, 23.4);
insert into b values (20, 1, 34.5);
insert into b values (30, 1, 45.6);
insert into c values (100,10,56.7);
insert into c values (101,10,67.8);
insert into c values (200,20,78.9);
insert into c values (201,20,89.1);
insert into c values (300,30,91.2);
My suggest is "a.b.c"-request. Output is
<a id=1 data=12.3>
<b id=10 data=23.4>
<c id=100 data=56.7/>
<c id=101 data=67.8/>
</b>
<b id=20 data=34.5>
<c id=200 data=78.9/>
<c id=201 data=89.1/>
</b>
<b id=30 data=45.6>
<c id=200 data=91.2/>
</b>
</a>
I wrote about that in
http://sql4.by.ru/site/sql40/en/author/introduction_eng.htm
http://sql4.by.ru/site/sql40/en/author/determination_eng.htm
>to make it look more like XML
Understand: XML is not model of data (in my suggest), XML is format of output.
Can you offer better format for output of tree?
If you can, write please, i listen.
>because of some special purpose application
Reception of tree from database is really often case.
For example, open several schemes of database (in Erwin, in
RationalRose, in other modeller) - scheme is net (count).
After that, look at source of server programs, servicing this databases.
These programs get part of net (not part of one table!, not part of
joined tables! not part of one view!) and put it into program-visualizer.
In back direction, server program get tree (records for several tables, not for one table!)
and put it into database.
>SQL ... It's ... language, unconcerned with transport
I agree. Now it's so.
>change the syntax of SQL
SQL remains inviolate.
I offer addition to it - i offer Tree Manipulation Language.
Look once more:
create table a (
id num primary key;
data float;
);
create table b (
id num primary key;
ref1 num references a(id);
ref2 num references a(id);
data float;
);
create table c (
id num primary key;
lnk1 num references b(id);
lnk2 num references b(id);
data float;
);
insert into a values (1, 12.3);
insert into a values (2, 23.4);
insert into b values (10, 1, 2, 34.5);
insert into b values (20, 1, 2, 45.6);
insert into b values (30, 1, 2, 56.7);
insert into b values (40, 1, 2, 67.8);
insert into c values (100,10,20,78.9);
insert into c values (101,10,20,89.1);
insert into c values (200,30,40,91.2);
insert into c values (201,30,40,88.8)
But TML is:
a.b/ref1.c/lnk1
---
P.S.
I'm very glad to get acquainted with you, and i'm much interesting to talk with you.
Let's to write maximum simply, let's to use maximum simple expressions
to understand each other better.
Dmitry Turin
http://html60.chat.ru
http://sql40.chat.ru
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
@ 2007-04-20 11:14 ` Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-20 14:49 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
0 siblings, 2 replies; 29+ messages in thread
From: Richard Huxton @ 2007-04-20 11:14 UTC (permalink / raw)
To: Dmitry Turin <sql4-en@narod.ru>; +Cc: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
Dmitry Turin wrote:
>> you are proposing is to ... break the relational model of SQL
>
> No. I'm proposing to add new thinking about relational model
> (primary i want to write "to add new view", but i remember, that
> "view" is reserved word in SQL :) ).
> Сonvince yourself, please:
>
> create table a (
> id num primary key;
> data float;
> );
> create table b (
> id num primary key;
> ref num references a(id);
> data float;
> );
> create table c (
> id num primary key;
> link num references b(id);
> data float;
> );
> insert into a values (1, 12.3);
> insert into b values (10, 1, 23.4);
> insert into b values (20, 1, 34.5);
> insert into b values (30, 1, 45.6);
> insert into c values (100,10,56.7);
> insert into c values (101,10,67.8);
> insert into c values (200,20,78.9);
> insert into c values (201,20,89.1);
> insert into c values (300,30,91.2);
>
> My suggest is "a.b.c"-request. Output is
>
> <a id=1 data=12.3>
> <b id=10 data=23.4>
> <c id=100 data=56.7/>
> <c id=101 data=67.8/>
> </b>
> <b id=20 data=34.5>
> <c id=200 data=78.9/>
> <c id=201 data=89.1/>
> </b>
> <b id=30 data=45.6>
> <c id=200 data=91.2/>
> </b>
> </a>
>
> I wrote about that in
> http://sql4.by.ru/site/sql40/en/author/introduction_eng.htm
> http://sql4.by.ru/site/sql40/en/author/determination_eng.htm
>
>> to make it look more like XML
>
> Understand: XML is not model of data (in my suggest), XML is format of output.
> Can you offer better format for output of tree?
> If you can, write please, i listen.
Your format seems to have thrown away all type information. How do I
know with the "id=200" that 200 is an int rather than a byte or string?
Also, how do we add the new table?
CREATE TABLE d (
aref num references a,
bref num references b,
cref num references c
);
>> because of some special purpose application
>
> Reception of tree from database is really often case.
Well it's sometimes the case. I'm not sure you've given any evidence
that *most* (or even many) accesses to a database want to retrieve a
simple tree. And only a tree - presumably your alternative access method
doesn't let me grab "nets" (directed graphs, possibly cyclic).
> For example, open several schemes of database (in Erwin, in
> RationalRose, in other modeller) - scheme is net (count).
So - not a tree?
> After that, look at source of server programs, servicing this databases.
> These programs get part of net (not part of one table!, not part of
> joined tables! not part of one view!) and put it into program-visualizer.
Also not trees (necessarily)
> In back direction, server program get tree (records for several tables, not for one table!)
> and put it into database.
I'm not sure that anyone is clear why you just don't write this as a
simple php/perl/ruby/whatever script? There are libraries that will
output XML for you in most of these I'd suspect, and if not it's just an
afternoon's work.
I mean, your application is written in *some* language, isn't it?
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
@ 2007-04-20 12:42 ` Joe <dev@freedomcircle.net>
2007-04-20 12:50 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
1 sibling, 2 replies; 29+ messages in thread
From: Joe @ 2007-04-20 12:42 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: Dmitry Turin <sql4-en@narod.ru>; Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
Hi Richard,
On Fri, 2007-04-20 at 12:14 +0100, Richard Huxton wrote:
> I'm not sure that anyone is clear why you just don't write this as a
> simple php/perl/ruby/whatever script? There are libraries that will
> output XML for you in most of these I'd suspect, and if not it's just an
> afternoon's work.
>
> I mean, your application is written in *some* language, isn't it?
It appears that Dmitry wants that an application, written in whatever
language, will issue an SQL query (or maybe a TML "query" such as
"a.b.c") and get back the XML. He's not concerned about loss of
datatype information because from his perspective the application will
just "present" the XML and similarly he's not concerned about DDL
features because TML is a "transport" mechanism.
I hope I haven't totally misrepresented Dmitry's words, but it seems he
wants to create a universal "database to web" interface language, so
that you and I won't have to deal with the pesky complications of
retrieving data in C with libpq or with PHP, Python and what not
libraries or "adapters", and then have to transform that data for
display to the user.
However, IMHO this appears to be rather simplistic and not completely
grounded in actual experience. In other words, Dmitry, have you written
a TML parser or a libpq prototype that given a TML "query" produces the
XML and tested it with datatypes other than integer and float. Or do
you have feedback from actual average users that TML is indeed easier to
use than SQL?
Two other items to think about. One is that the scheme apparently
requires that tables be defined in a special way, but no indication is
given as to how this will be accomplished or ensured that it is correct.
Second is how does TML handle relational manipulations such as
restriction, projection or aggregation. It appears TML is primarily for
joins.
Lastly, Dmitry, I think you'll be better off discussing this in
comp.databases.theory.
Joe
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
@ 2007-04-20 12:50 ` Richard Huxton <dev@archonet.com>
2007-04-20 13:14 ` Re: We all are looped on Internet: request + transport = invariant Achilleas Mantzios <achill@matrix.gatewaynet.com>
2007-04-20 13:21 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-20 16:52 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
1 sibling, 3 replies; 29+ messages in thread
From: Richard Huxton @ 2007-04-20 12:50 UTC (permalink / raw)
To: Joe <dev@freedomcircle.net>; +Cc: Dmitry Turin <sql4-en@narod.ru>; Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
Joe wrote:
> Hi Richard,
>
> On Fri, 2007-04-20 at 12:14 +0100, Richard Huxton wrote:
>> I'm not sure that anyone is clear why you just don't write this as a
>> simple php/perl/ruby/whatever script? There are libraries that will
>> output XML for you in most of these I'd suspect, and if not it's just an
>> afternoon's work.
>>
>> I mean, your application is written in *some* language, isn't it?
>
> It appears that Dmitry wants that an application, written in whatever
> language, will issue an SQL query (or maybe a TML "query" such as
> "a.b.c") and get back the XML. He's not concerned about loss of
> datatype information because from his perspective the application will
> just "present" the XML and similarly he's not concerned about DDL
> features because TML is a "transport" mechanism.
>
> I hope I haven't totally misrepresented Dmitry's words, but it seems he
> wants to create a universal "database to web" interface language, so
> that you and I won't have to deal with the pesky complications of
> retrieving data in C with libpq or with PHP, Python and what not
> libraries or "adapters", and then have to transform that data for
> display to the user.
OK, but I'm still not seeing how this avoids me having to use
PHP/Perl/etc anyway. I mean, I'm going to need some application logic at
some point, in which case who cares whether the RDBMS has this specific
layout as a format. I can see how it might be useful as a library, but
then there are libraries that provide plenty of XML formatting.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-20 12:50 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
@ 2007-04-20 13:14 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2 siblings, 0 replies; 29+ messages in thread
From: Achilleas Mantzios @ 2007-04-20 13:14 UTC (permalink / raw)
To: pgsql-sql
Just some thoughts on the matter:
Dmitry, you should acknowledge the fact that in databses you have two kinds of
hierarchies:
a) The hierarchy denoted by the referential constraints between tables which
constitute a Directed Graph (DG), with tables as nodes and FKeys as arrows.
b) Hierarchies applying to data, e.g.
create table ppl (
id serial PRIMARY KEY,
name text not null,
parentid integer REFERENCES ppl(id)
); (with GOD himself having parentid = null :).
I think that the second type is of interest at the application level.
(For system applications however, such as DB mirroring the first type of table
hierarchy is important as well).
Speaking of postgresql there is a fine package by the GiST/tsearch creators,
contrib/ltree whose main task is to provide the primitives
(functions/operators) for tree manipulation.
Dont know if i am irrelevant in this thread, but i hope i helped a little bit.
--
Achilleas Mantzios
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-20 12:50 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
@ 2007-04-20 13:21 ` Joe <dev@freedomcircle.net>
2 siblings, 0 replies; 29+ messages in thread
From: Joe @ 2007-04-20 13:21 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: Dmitry Turin <sql4-en@narod.ru>; Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-sql
Hi Richard,
On Fri, 2007-04-20 at 13:50 +0100, Richard Huxton wrote:
> OK, but I'm still not seeing how this avoids me having to use
> PHP/Perl/etc anyway. I mean, I'm going to need some application logic at
> some point, in which case who cares whether the RDBMS has this specific
> layout as a format. I can see how it might be useful as a library, but
> then there are libraries that provide plenty of XML formatting.
But if TML catches on so that "even a caveman can do it" *, i.e., query
a database from just a browser, then you and I (and most everyone on
this list) will be out of a job and PHP/Perl/etc. will be relegated to
the dustbin of programming languages. [Sorry, couldn't resist :-) ]
Joe
* see http://en.wikipedia.org/wiki/Geico
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-20 12:50 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
@ 2007-04-20 16:52 ` Dmitry Turin <sql4-en@narod.ru>
2 siblings, 0 replies; 29+ messages in thread
From: Dmitry Turin @ 2007-04-20 16:52 UTC (permalink / raw)
To: pgsql-sql
> he wants to create a universal "database to web" interface language, so
> that you and I won't have to deal with the pesky complications of
> retrieving data in C with libpq or with PHP, Python and what not
> libraries or "adapters", and then have to transform that data for
> display to the user.
Yes.
Especially about adapters !
>OK, but I'm still not seeing how this avoids me having to use
>PHP/Perl/etc anyway.
TML stored function get XML from external world (DBMS listen port #80),
work, than make output of other XML into external world.
Transport is executed through HTTP.
>who cares whether the RDBMS has this specific layout as a format.
I want to answer, but i don't understood phrase "layout as a format".
Please, explain your question.
>I can see how it might be useful as a library
I don't see, how to use TML as library :)
>there are libraries that provide plenty of XML formatting
Once more: XML is side effect! If you know better format for tree,
please describe it.
Gold is ejection of shim (gasket): php, perl, etc.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
@ 2007-04-23 08:20 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
1 sibling, 1 reply; 29+ messages in thread
From: Dmitry Turin @ 2007-04-23 08:20 UTC (permalink / raw)
To: pgsql-sql
Good day, Joe.
>> Table must be created in traditional way (by "create table, alter
>> table") and not through browser.
>> User must use "create table", etc in database-terminal like "psql.exe".
> By "in a special way" I meant that tables have referential constraints
> to other tables and they appear to rely on synthetic keys.
Referential constraints must be created also in traditional way and
also not through browser (by "psql.exe").
>your examples have invalid PG SQL
Yes, i know.
I copy this examples from my page
http://sql40.chat.ru/site/sql40/en/author/introduction_eng.htm
(i wrote this page for all DBMS in general).
>I would change your examples to use less abstract
> data, like department/employee, customer/product/order/order_line
This will not help.
To my mind, forum of real database is place,
when i can find programmer, which can (and maybe would like) add parser to database.
We all together can make that, i hope to that.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
@ 2007-04-23 11:57 ` Joe <dev@freedomcircle.net>
2007-04-24 12:31 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
0 siblings, 1 reply; 29+ messages in thread
From: Joe @ 2007-04-23 11:57 UTC (permalink / raw)
To: Dmitry Turin <sql4-en@narod.ru>; +Cc: pgsql-sql
Hi Dmitry,
On Mon, 2007-04-23 at 11:20 +0300, Dmitry Turin wrote:
> >I would change your examples to use less abstract
> > data, like department/employee, customer/product/order/order_line
>
> This will not help.
> To my mind, forum of real database is place,
"What we got here is ... failure to communicate."
I may be wrong, but I suspect most of the people in this forum take a
look at
create table a (
id num primary key;
data float;
);
create table b (
id num primary key;
ref num references a(id);
data float;
);
create table c (
id num primary key;
link num references b(id);
data float;
);
or even
create table a (
id integer primary key,
data float);
create table b (
id integer primary key,
ref integer references a(id),
data float);
create table c (
id integer primary key,
link integer references b(id),
data float);
and your attempts to derive XML from them and ask questions like "how
will this help me in my day-to-day job" and "what do a, b and c
represent or are analogous to?" and all they'll see is a hierarchy of
some sort (as evident by several of the responses) and they'll dismiss
it because they have to deal with more complex relationships and the
relational model allows them to express such connections.
OTOH, if you were to take a real-life example, and show you can generate
XML from your proposed TML, I contend that then you'd find more people
receptive to your ideas or at least able to criticize them from more
concrete viewpoints.
Take a look for example at Philip Greenspun's "SQL for Web Nerds". It's
dated and its examples are based on Oracle syntax, but it's based on a
real web application. Show us what TML can do for the users, bboard and
classified_ads tables
(http://philip.greenspun.com/sql/data-modeling.html), and how it can
answer the simple and complex queries in the next two chapters (or as I
said, pick a real-life example of your own) and then maybe we'll have a
more fruitful conversation.
Joe
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
@ 2007-04-24 12:31 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-24 13:55 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
0 siblings, 1 reply; 29+ messages in thread
From: Dmitry Turin @ 2007-04-24 12:31 UTC (permalink / raw)
To: pgsql-sql
Good day, Joe.
J> "Fictional" is IMO not a good choice for
J> describing aggregates, because it means "a story that is not true",
J> whereas an SQL aggregate is something that is "true" (in the
J> mathematical sense) but is "derived" from other values.
It means, that TML and DDL aggregates have different sense.
J> (I'm not sure what the special symbols mean -- maybe what you need first
J> is a syntax reference for TML)
http://sql4.by.ru/site/sql40/en/author/tree_eng.htm
J> sum of the employees salaries?
yes.
"amount" is quantity of employees
J> How do I see employees in just one department?
department[id="1"].employee >>;
or
department[name="Technical"].employee >>;
J> How do I see a single employee?
employee[id="31"] >>;
or
employee[name="Tomson"] >>;
-- maybe several employee with surname Tomson
J> How do I see all employees that have a salary greater than 3500
department.employee[salary>3500] >>;
J> ordered by their names?
Now sorting for output is absent.
I'm not sure, that it's necessary,
but i already thought about this and continue to think.
J> How do I actually retrieve SUM(salary)
Declare field "sum" as not fictional.
You can always declare field "sum" as not fictional and
put sign "#" before field to prevent output of field.
J> GROUP BY department?
It is always "group by", because it is field of record "department"
P.S.
If you don't like to put sign "#" before field "sum",
or you don't like absence of sorting NOW
(it's possible, that i add sorting),
then remember, that advantage is absence of gasket
(php, etc) between DBMS and external world.
That is more important for un-experienced users.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-24 12:31 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
@ 2007-04-24 13:55 ` Joe <dev@freedomcircle.net>
2007-04-25 07:47 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
0 siblings, 1 reply; 29+ messages in thread
From: Joe @ 2007-04-24 13:55 UTC (permalink / raw)
To: Dmitry Turin <sql4-en@narod.ru>; +Cc: pgsql-sql
Hi Dmitry,
On Tue, 2007-04-24 at 15:31 +0300, Dmitry Turin wrote:
> J> How do I see employees in just one department?
>
> department[id="1"].employee >>;
>
> or
>
> department[name="Technical"].employee >>;
How is that any different or better than a standard SQL SELECT (or to
use another context, a Tutorial D statement)?
> J> How do I see a single employee?
>
> employee[id="31"] >>;
>
> or
>
> employee[name="Tomson"] >>;
> -- maybe several employee with surname Tomson
What if I want to see specific columns of the employee row or see the
name of the department that Tomson works in or the name of Tomson's
manager?
> J> How do I actually retrieve SUM(salary)
>
> Declare field "sum" as not fictional.
>
> You can always declare field "sum" as not fictional and
> put sign "#" before field to prevent output of field.
This "fictional" attribute of yours implies a change to SQL DDL.
> J> GROUP BY department?
>
> It is always "group by", because it is field of record "department"
That is only in *your* view of the data. What if someone comes along
and wants to do SELECT name, SUM(salary) FROM employee GROUP BY name?
Or GROUP BY date_trunc('year', hire_date)?
The point is that SQL has been refined (although some may disagree :-)
over the past quarter century to answer this and many other questions
and I don't see how TML improves on that (for an enhanced answer to SQL,
take a look at Tutorial D). And XML is *not* the only answer to viewing
or even "transporting" data. Some people prefer a tabular
representation, others may prefer a hierarchical view, and yet others
want to see a chart (and even the same person may prefer a different
view for various purposes or at various times).
And there's nothing wrong with Perl, PHP, Python and the myriad
interface languages. That's what "free" software is all about. The
POSTGRES UCB project had a language called PostQUEL, which may have been
technically superior to SQL, but market forces (unfortunately not all
"free") pushed Postgres95 and then PostgreSQL to adopt the latter in
preference to PostQUEL. Maybe one day we'll have one (or two) interface
languages to PostgreSQL that 80% of the users will use, but it will not
be because you or I or even the PG Global Dev Group leaders say it's
"better" or "it's necessary", but because thousands of users may agree
and converge on those choices.
Joe
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-24 12:31 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-24 13:55 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
@ 2007-04-25 07:47 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-25 09:34 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
0 siblings, 1 reply; 29+ messages in thread
From: Dmitry Turin @ 2007-04-25 07:47 UTC (permalink / raw)
To: pgsql-sql
Good day, Joe.
>> J> How do I see employees in just one department?
>> department[id="1"].employee >>;
>> department[name="Technical"].employee >>;
J> How is that any different or better than a standard SQL SELECT
by absence of gasket (php, its library; perl, its library; etc)
J> XML is *not* the only answer to viewing or even "transporting" data.
it's nothing more simply: offer your decision !!
J> others want to see a chart
it's nothing more simply: offer format for data, on which chart will be created !!
J> And there's nothing wrong with Perl, PHP, Python and the myriad
J> interface languages.
I said many times, what is wrong:
applied users can not join sql and perl, can not use libraries,
and can not adjust web-server.
J> I don't see how TML improves
It characterizes not analysed situation, but you.
J> Some people prefer a tabular representation
<tablename field1= field2= field3= >
<tablename field1= field2= field3= >
<tablename field1= field2= field3= >
<tablename field1= field2= field3= >
<tablename field1= field2= field3= >
---
>> J> How do I see a single employee?
>> employee[id="31"] >>;
>> employee[name="Tomson"] >>;
J> I want to see specific columns of the employee row
Mark other fields (columns) by sign "#" to prevent output of them.
NOW there is no construction like
employee#[need_field]
i.e. to forbid all field and to allow necessary columns ("need_field").
Probably i add that.
J> or see the name of the department that Tomson works
department.#employee[name="Tomson"] >>;
or
#employee[name="Tomson"].department >>;
J> or the name of Tomson's manager?
Let table "employee" has additional field "manager"
create table employee {
id num primary key,
name string,
salary num,
department num references department (id),
manager bool
};
Request is (look at
http://sql4.by.ru/site/sql40/en/author/determination_eng.htm,
paragraph "Buckle")
(employee[manager=true].#department.#employee[name="Tomson"],
employee[manager=true name="Tomson"]) >>;
or
(#employee[name="Tomson"].#department.employee[manager=true],
employee[manager=true name="Tomson"]) >>;
If you seggest other scheme of data, i will write query for it.
J> This "fictional" attribute of yours implies a change to SQL DDL.
You are worried about technical realization or ideological orthodoxy ?
Or maybe about anything else ?
J> if someone comes along and wants to do
J> SELECT name, SUM(salary) FROM employee GROUP BY name?
create view x as SELECT name, SUM(salary) FROM employee GROUP BY name;
x >>;
J> thousands of users may agree and converge on those choices.
1. Not users, but programmers.
2. Needs are produced also, as goods and capital goods.
Karl Marks
For example, look at yourself.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-24 12:31 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-24 13:55 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-25 07:47 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
@ 2007-04-25 09:34 ` Joe <dev@freedomcircle.net>
2007-04-26 08:33 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
0 siblings, 1 reply; 29+ messages in thread
From: Joe @ 2007-04-25 09:34 UTC (permalink / raw)
To: Dmitry Turin <sql4-en@narod.ru>; +Cc: pgsql-sql
Hi Dmitry,
On Wed, 2007-04-25 at 10:47 +0300, Dmitry Turin wrote:
> J> And there's nothing wrong with Perl, PHP, Python and the myriad
> J> interface languages.
>
> I said many times, what is wrong:
> applied users can not join sql and perl, can not use libraries,
> and can not adjust web-server.
I strongly disagree. I have not taken any formal courses on PHP, HTML,
Apache or Python, and I only took a couple of week-long courses on SQL
ages ago (Perl I don't care for). Yet I've learned enough on my own to
"join" them and use their libraries and put up a website. And I believe
there are others on this list and elsewhere that have done so, to
varying degrees. And yet others may require the assistance of a
technical specialist or a full-time programming team, but what's wrong
with that?
> J> thousands of users may agree and converge on those choices.
>
> 1. Not users, but programmers.
> 2. Needs are produced also, as goods and capital goods.
> Karl Marks
> For example, look at yourself.
We are on diametrically opposed sides of that argument, but it's
off-topic, so I'll leave it alone.
Joe
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-24 12:31 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-24 13:55 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-25 07:47 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-25 09:34 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
@ 2007-04-26 08:33 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-26 12:08 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-26 16:57 ` Re: We all are looped on Internet: request + transport = invariant Adam Tauno Williams <adamtaunowilliams@gmail.com>
0 siblings, 2 replies; 29+ messages in thread
From: Dmitry Turin @ 2007-04-26 08:33 UTC (permalink / raw)
To: pgsql-sql
Good day, Joe.
>> J> And there's nothing wrong with Perl, PHP, Python and the myriad
>> J> interface languages.
>>
>> I said many times, what is wrong:
>> applied users can not join sql and perl, can not use libraries,
>> and can not adjust web-server.
J> II have not taken any formal courses
Joe, i speak not about you, but about statistics.
J> there are others on this list and elsewhere that have done so
Second question: why?
For what people must learn php, etc,
if they need only output data from database.
>others may require the assistance of a
J> technical specialist or a full-time programming team, but what's wrong
J> with that?
expenses of money, time, nerve to explain task to other man
P.S.
Joe, send letter only to mailing list, not to me.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-24 12:31 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-24 13:55 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-25 07:47 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-25 09:34 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-26 08:33 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
@ 2007-04-26 12:08 ` Joe <dev@freedomcircle.net>
2007-05-02 05:05 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
1 sibling, 1 reply; 29+ messages in thread
From: Joe @ 2007-04-26 12:08 UTC (permalink / raw)
To: pgsql-sql
Dmitry,
On Thu, 2007-04-26 at 11:33 +0300, Dmitry Turin wrote:
> Joe, i speak not about you, but about statistics.
Do you actually have statistics of how many people in the general
population have learned SQL? And furthermore, how many of those people
didn't already know or didn't want to bother learning another
computer-related language?
> J> there are others on this list and elsewhere that have done so
>
> Second question: why?
> For what people must learn php, etc,
> if they need only output data from database.
If people only need to examine or visualize data, they can use any
number of "user friendly" tools: PgAdmin, Excel with ODBC, etc. (and
these may not be the best examples). However, someone will still have
to learn SQL and C, PHP, Python, etc., to create an application to input
and maintain the data.
> >others may require the assistance of a
> J> technical specialist or a full-time programming team, but what's wrong
> J> with that?
>
> expenses of money, time, nerve to explain task to other man
I believe your worldview is affected by the people you interact with.
The average man or woman on the street doesn't want to know about SQL,
relational databases, third normal form or, with all due respect, TML.
If they have Internet access, they want to enter a query string into
something like Google or Amazon and look at the results. Do you think
if Amazon gave raw read access to their underlying database, many people
would jump to query it with SQL, TML or any computer language? And even
those who did, when they found a book of their choice they would still
need APPLICATION code to enter their order.
OTOH, I think you're dealing with a select group of scientists who have
these data and they would love to "mine" it and analyze it to the nth
degree but they don't want to jump through (too many) hoops to do so.
And maybe TML is just what they need.
And there are others (business people, for example) who also need to
analyze the data they have and they don't mind paying for programmers,
DBAs, etc. (even if sometimes it may be tough for them explaining *what*
they want). For those, TML may or may not be a solution. The
marketplace will decide.
Joe
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-24 12:31 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-24 13:55 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-25 07:47 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-25 09:34 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-26 08:33 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-26 12:08 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
@ 2007-05-02 05:05 ` Dmitry Turin <sql4-en@narod.ru>
2007-05-02 12:47 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
0 siblings, 1 reply; 29+ messages in thread
From: Dmitry Turin @ 2007-05-02 05:05 UTC (permalink / raw)
To: pgsql-sql
Good day, Joe.
Joe and other respected comrades,
don't be angry, when my letter will be late.
This is caused by technical schedule of our internet.
J> ... and C, PHP, Python, etc., to create an application to input
J> and maintain the data.
Question remains open:
for what people must learn php, if they need mainly
"table1.table2 >>;" or "create view x ...; x>>;"
I explain this thought.
For example, TML consist of two parts: SIMPLE and DIFFICULT.
Border between them is so: users will use mainly
"<tagname> >>;" or "tablename >>;"
Not all of TML will be used by low-skill users.
But this don't canceals, that users need simple part of TML.
J> Do you think
J> if Amazon gave raw read access to their underlying database,
J> many people would jump to query it with SQL, TML or any computer language?
I speak about situation,
when people need to create complex "database-visualizer"
(visualizer is a browser, spreadsheet, etc).
Practice show, that they use only database in this case
(by sql-terminal like "pgsql.exe").
J> you're dealing with a select group of scientists who have
J> these data and they would love to "mine" it and analyze it to the nth
J> degree but they don't want to jump through (too many) hoops to do so.
J> And maybe TML is just what they need.
You are right.
J> And there are others (business people, for example)
J> who also need to analyze the data
J> they have and they don't mind paying for programmers,
J> DBAs, etc. (even if sometimes it may be tough for them explaining *what*
J> they want). For those, TML may or may not be a solution. The
J> marketplace will decide.
I think, even high-skill users will prefer TML over php
in simple case like
"tablename>>;"".
I think, even you will prefer in this case.
---statistics
J> Do you actually have statistics of how many people in the general
J> population have learned SQL?
I imply phisicists, optics phisicists, biologists, zoologists,
ecologists, with which i work from 1992 year.
J> how many of those people didn't already know
People of all technical profession
(also chemists, technologists and others, which i meet, but with which i don't work)
already know some computer languages -
oldest generation: fortran, latex, shell (a little);
middle geeration: c, fortran (a little), shell (a little);
youngest generation: 1% use "c", 99% use "pascal"
(not both of them, but often use Delpi).
I speak about russian universities.
If youngest generation meet need to use DBMS,
all of them have learned by SQL
(not PL/SQL, not system tables of DBMS).
Deal with HTML is the same.
People of non-technical professsion don't learn languages in universities
(dispite of computer languages is part of program of universities).
When they meet a need,
half of them ask comarades to do task,
half of them ask comarades to help in studing of languages.
So situation is 50%-50%.
I don't know situation in colleges.
J> or didn't want to bother learning another
J> computer-related language?
People of all profession want to learn a little.
"A little" means the following:
they will learn SQL to work with data,
but will not direct output to browser, spreadsheet, etc by language -
they will use "pgsql.exe" -
despite of presentation in "pgsql.exe" is less comfortable,
than in browser, etc.
Using of tools like "Cristal Report" is very seldom
(i never meet, that russian applied specialist use such tools for databases).
>> For what people must learn php, etc,
>> if they need only output data from database.
J> they can use any number of "user friendly" tools: PgAdmin
"PgAdmin" is the same for visualization, as "pgsql.exe"
J> Excel with ODBC
Using this is over skills of users.
J> However, someone will still have to learn SQL
SQL is point, which may not be avoided (now).
Thus SQL is separate topic.
J> The average man or woman on the street
For what you say about street ?
Average people, which you can meet on street, make physical job.
Dmitry Turin
http://html6.by.ru
http://sql4.by.ru
http://computer2.by.ru
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-24 12:31 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-24 13:55 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-25 07:47 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-25 09:34 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-26 08:33 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-26 12:08 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-05-02 05:05 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
@ 2007-05-02 12:47 ` Joe <dev@freedomcircle.net>
0 siblings, 0 replies; 29+ messages in thread
From: Joe @ 2007-05-02 12:47 UTC (permalink / raw)
To: pgsql-sql
Hi Dmitry,
On Wed, 2007-05-02 at 08:05 +0300, Dmitry Turin wrote:
> J> The average man or woman on the street
>
> For what you say about street ?
> Average people, which you can meet on street, make physical job.
That is an American colloquialism to refer to just about anyone,
regardless of what kind of work they do. The point is that --using the
Pareto principle-- 80% (probably much more) of the people don't know SQL
or are fluent in other programming languages, and they don't want to be
bothered with *any* of it except to use the products and services that
are made possible through them.
According to the U.S. Bureau of Labor Statistics (BLS) there were
455,000 programming jobs in 2004. Even if you raise that by an order of
magnitude you're still talking about less than 2% of the U.S.
population. The BLS estimates there were 16,000 physicists/astronomers
and 77,0000 biological scientists. So the software/programming and
scientist populations may be roughly comparable. While the ratios may
be better in some other countries, I doubt that they're much off.
The bottom line is: the markets for PHP/etc. and TML are not too large,
but you seem to be having a hard time convincing those of us who've
taken even a mild interest in TML that it's really needed or is a better
solution than what exists today.
Joe
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-23 08:20 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-24 12:31 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-24 13:55 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-25 07:47 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-25 09:34 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-26 08:33 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
@ 2007-04-26 16:57 ` Adam Tauno Williams <adamtaunowilliams@gmail.com>
1 sibling, 0 replies; 29+ messages in thread
From: Adam Tauno Williams @ 2007-04-26 16:57 UTC (permalink / raw)
To: pgsql-sql
> >> J> And there's nothing wrong with Perl, PHP, Python and the myriad
> >> J> interface languages.
> >> I said many times, what is wrong:
> >> applied users can not join sql and perl, can not use libraries,
> >> and can not adjust web-server.
> J> II have not taken any formal courses
> Joe, i speak not about you, but about statistics.
> J> there are others on this list and elsewhere that have done so
> Second question: why?
> For what people must learn php, etc,
> if they need only output data from database.
They don't; there are a myriad options. I've got numerous 'normal
users' who use a database to do reasonably sophisticated things. All
you need is a good client; we use DbVisualizer
[ http://www.minq.se/products/dbvis/ ]. There are others, you don't
need a programming language at all if all you want is "output data from
database". Many of these, including DbVisualizer include GUI
drag-n-drop query builders.
Yes, you have to learn some SQL, but there is no case where you get
something for nothing; and almost all humans are reliably
quick-studies, even innovative, when they are properly motivated.
> >others may require the assistance of a
> J> technical specialist or a full-time programming team, but what's wrong
> J> with that?
> expenses of money, time, nerve to explain task to other man
--
Adam Tauno Williams, Network & Systems Administrator
Consultant - http://www.whitemiceconsulting.com
Developer - http://www.opengroupware.org
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
@ 2007-04-20 14:49 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-20 15:52 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
1 sibling, 1 reply; 29+ messages in thread
From: Dmitry Turin @ 2007-04-20 14:49 UTC (permalink / raw)
To: pgsql-sql
>How do I know with the "id=200" that 200 is an int rather than a byte or string?
Field (of database) and attribute (of tag) are put into one-to-one
correspondence.
Thus datatype of attribute is datatype of field (which is specified
during "create table" or "alter table").
>how do we add the new table?
by DDL, of course.
TML don't create/alter/drop table/index.
>accesses to a database want to retrieve a simple tree
It's difficult to bring inverse example - when it's necessary to get
records of only one table. Really, in life (not in math problems).
>your alternative access method doesn't let me grab "nets" (directed graphs, possibly cyclic)
Yes.
You must inquere records of two tables (nodes and bonds) separately.
>> After that, look at source of server programs, servicing this databases.
>> These programs get part of net (not part of one table!, not part of
>> joined tables! not part of one view!) and put it into program-visualizer.
>Also not trees (necessarily)
No. Server program inqueries tree (as part of graph).
>why you just don't write this as a simple php/perl/ruby/whatever script?
Not me.
Not programmer.
I speak about appied specialists (physicists, biologists, etc), which
can NOT do that.
Join of SQL and php (using libraries) is problem for them.
>it's just an afternoon's work
Not for mentioned people.
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 14:49 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
@ 2007-04-20 15:52 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 17:04 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
0 siblings, 1 reply; 29+ messages in thread
From: Andrew Sullivan @ 2007-04-20 15:52 UTC (permalink / raw)
To: pgsql-sql
On Fri, Apr 20, 2007 at 05:49:08PM +0300, Dmitry Turin wrote:
> I speak about appied specialists (physicists, biologists, etc), which
> can NOT do that.
> >it's just an afternoon's work
>
> Not for mentioned people.
I think part of the reason I'm sceptical of your plan is that every
physicist or biologist I ever knew, who had anything to do with
storing large volumes of data, all knew a great deal of Perl. What
they didn't know, they got the computer-support staff (that was my
job) to build for them. People who work with data have to learn to
use the tools for processing it. Nobody ever suggests that stats is
just too hard, so we should make an easy-stats course that just
covers the teeny bit that (say) biologists need to know. That seems
to be what you are suggesting be done to SQL.
Now, anyone who knows anything about biology -- or physics, for that
matter -- knows that you actually have to have a good handle on stats
to do any interesting work. You don't need everything economists
use, though, so you don't learn those bits. Similarly, I don't
expect a biologist to learn (for instance) the Net::DNS modules for
Perl. That doesn't mean they can get away without learning a bit
about XML, Perl, and Pg.pm.
Anyway, I've said enough on this topic. When you have the start of a
user library that implements your proposal, perhaps you can post it
to -hackers for the response you'll get there.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 14:49 ` Re: We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-20 15:52 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
@ 2007-04-20 17:04 ` Dmitry Turin <sql4-en@narod.ru>
0 siblings, 0 replies; 29+ messages in thread
From: Dmitry Turin @ 2007-04-20 17:04 UTC (permalink / raw)
To: pgsql-sql
>every physicist or biologist ... knew a great deal of Perl
They spend own time and force for that.
Next generation will not have this need.
>they got the computer-support staff (that was my job)
And your money.
Besides money, they spend own time to explain task to you.
>People ... have to learn
They must nothing, they are forced
>That doesn't mean they can get away without learning a bit about ... Perl
Why?
Dmitry Turin
http://html60.by.ru
http://sql40.by.ru
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request + transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
@ 2007-04-20 11:14 ` Bart Degryse <Bart.Degryse@indicator.be>
2007-04-23 06:46 ` Re: We all are looped on Internet: request +transport = invariant Bart Degryse <Bart.Degryse@indicator.be>
1 sibling, 1 reply; 29+ messages in thread
From: Bart Degryse @ 2007-04-20 11:14 UTC (permalink / raw)
To: pgsql-sql
Trees like you seem to suggest are called hierarchies. If you prefer hierarchies over relationnality you could use a hierarchical database instead of a relational database. When you search the internet you can find plenty of information on eg Adabas, GT.M., IMS, DMSII, Focus, Metakit and many others.
>>> Dmitry Turin <sql4-en@narod.ru> 2007-04-20 11:08 >>>
>you are proposing is to ... break the relational model of SQL
No. I'm proposing to add new thinking about relational model
(primary i want to write "to add new view", but i remember, that
"view" is reserved word in SQL :) ).
*onvince yourself, please:
create table a (
id num primary key;
data float;
);
create table b (
id num primary key;
ref num references a(id);
data float;
);
create table c (
id num primary key;
link num references b(id);
data float;
);
insert into a values (1, 12.3);
insert into b values (10, 1, 23.4);
insert into b values (20, 1, 34.5);
insert into b values (30, 1, 45.6);
insert into c values (100,10,56.7);
insert into c values (101,10,67.8);
insert into c values (200,20,78.9);
insert into c values (201,20,89.1);
insert into c values (300,30,91.2);
My suggest is "a.b.c"-request. Output is
<a id=1 data=12.3>
<b id=10 data=23.4>
<c id=100 data=56.7/>
<c id=101 data=67.8/>
</b>
<b id=20 data=34.5>
<c id=200 data=78.9/>
<c id=201 data=89.1/>
</b>
<b id=30 data=45.6>
<c id=200 data=91.2/>
</b>
</a>
I wrote about that in
http://sql4.by.ru/site/sql40/en/author/introduction_eng.htm
http://sql4.by.ru/site/sql40/en/author/determination_eng.htm
>to make it look more like XML
Understand: XML is not model of data (in my suggest), XML is format of output.
Can you offer better format for output of tree?
If you can, write please, i listen.
>because of some special purpose application
Reception of tree from database is really often case.
For example, open several schemes of database (in Erwin, in
RationalRose, in other modeller) - scheme is net (count).
After that, look at source of server programs, servicing this databases.
These programs get part of net (not part of one table!, not part of
joined tables! not part of one view!) and put it into program-visualizer.
In back direction, server program get tree (records for several tables, not for one table!)
and put it into database.
>SQL ... It's ... language, unconcerned with transport
I agree. Now it's so.
>change the syntax of SQL
SQL remains inviolate.
I offer addition to it - i offer Tree Manipulation Language.
Look once more:
create table a (
id num primary key;
data float;
);
create table b (
id num primary key;
ref1 num references a(id);
ref2 num references a(id);
data float;
);
create table c (
id num primary key;
lnk1 num references b(id);
lnk2 num references b(id);
data float;
);
insert into a values (1, 12.3);
insert into a values (2, 23.4);
insert into b values (10, 1, 2, 34.5);
insert into b values (20, 1, 2, 45.6);
insert into b values (30, 1, 2, 56.7);
insert into b values (40, 1, 2, 67.8);
insert into c values (100,10,20,78.9);
insert into c values (101,10,20,89.1);
insert into c values (200,30,40,91.2);
insert into c values (201,30,40,88.8)
But TML is:
a.b/ref1.c/lnk1
---
P.S.
I'm very glad to get acquainted with you, and i'm much interesting to talk with you.
Let's to write maximum simply, let's to use maximum simple expressions
to understand each other better.
Dmitry Turin
http://html60.chat.ru ( http://html60.chat.ru/ )
http://sql40.chat.ru ( http://sql40.chat.ru/ )
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request +transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Bart Degryse <Bart.Degryse@indicator.be>
@ 2007-04-23 06:46 ` Bart Degryse <Bart.Degryse@indicator.be>
2007-04-23 10:18 ` Re: We all are looped on Internet: request+transport = invariant Bart Degryse <Bart.Degryse@indicator.be>
0 siblings, 1 reply; 29+ messages in thread
From: Bart Degryse @ 2007-04-23 06:46 UTC (permalink / raw)
To: pgsql-sql
A hierarchical is specialized in managing data which is hierarchically
structured, while a relational database is not.
Maybe this analogy is clearer: If you want to fly you could attach
wings to your sportscar, but it's more logical to use a plane.
>>> Dmitry Turin <sql4-en@narod.ru> 2007-04-20 16:21 >>>
>you could use a hierarchical database instead of a relational
database
why ?
why is impossible to make addition for relational database?
^ permalink raw reply [nested|flat] 29+ messages in thread
* Re: We all are looped on Internet: request+transport = invariant
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` Re: We all are looped on Internet: request + transport = invariant sql4-en@narod.ru
2007-04-19 13:48 ` Re: We all are looped on Internet: request + transport = invariant Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 11:14 ` Re: We all are looped on Internet: request + transport = invariant Bart Degryse <Bart.Degryse@indicator.be>
2007-04-23 06:46 ` Re: We all are looped on Internet: request +transport = invariant Bart Degryse <Bart.Degryse@indicator.be>
@ 2007-04-23 10:18 ` Bart Degryse <Bart.Degryse@indicator.be>
0 siblings, 0 replies; 29+ messages in thread
From: Bart Degryse @ 2007-04-23 10:18 UTC (permalink / raw)
To: pgsql-sql
I'll continue with the analogy
It is not impossible to attach wings to a sportscar. When you do, you
will probably get the sportscar flying.
However:
1. Why would you even try, if airplanes (which are designed from
scratch to fly) already exist. Just use them
2. If you try nevertheless, is getting your car to fly worth the effert
it will cost. It might fly in the end, but it will never be a Phantom
(or whatever plane you prefer). Making something that can fly, requires
you to focus on that from scratch. A car was never designed to fly. So
basically a flying car will still be a car and not a plane.
So, since hierarchical databases do exist, why even bother trying to
transform a relational database into something that resembles a
hierarchical database. A real hierarchical will always be better suited
to do the job than your addition to a relational database will be,
simply because the hierarchical database was designed from scratch to do
just that.
>>> Dmitry Turin <sql4-en@narod.ru> 2007-04-23 12:07 >>>
Good day, Bart.
> A hierarchical is specialized in managing data which is
> hierarchically structured, while a relational database is not.
You don't answer to question
(why is impossible to make addition for relational database?).
Dmitry Turin
http://html6.by.ru ( http://html6.by.ru/ )
http://sql4.by.ru ( http://sql4.by.ru/ )
http://computer2.by.ru ( http://computer2.by.ru/ )
^ permalink raw reply [nested|flat] 29+ messages in thread
end of thread, other threads:[~2007-05-02 12:47 UTC | newest]
Thread overview: 29+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-04-13 07:58 We all are looped on Internet: request + transport = invariant Dmitry Turin <sql4-en@narod.ru>
2007-04-13 15:09 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-19 06:08 ` sql4-en@narod.ru
2007-04-19 06:26 ` Andrej Ricnik-Bay <andrej.groups@gmail.com>
2007-04-19 13:48 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 09:08 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Richard Huxton <dev@archonet.com>
2007-04-20 12:42 ` Joe <dev@freedomcircle.net>
2007-04-20 12:50 ` Re: We all are looped on Internet: request + transport = invariant Richard Huxton <dev@archonet.com>
2007-04-20 13:14 ` Re: We all are looped on Internet: request + transport = invariant Achilleas Mantzios <achill@matrix.gatewaynet.com>
2007-04-20 13:21 ` Re: We all are looped on Internet: request + transport = invariant Joe <dev@freedomcircle.net>
2007-04-20 16:52 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-23 08:20 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-23 11:57 ` Joe <dev@freedomcircle.net>
2007-04-24 12:31 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-24 13:55 ` Joe <dev@freedomcircle.net>
2007-04-25 07:47 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-25 09:34 ` Joe <dev@freedomcircle.net>
2007-04-26 08:33 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-26 12:08 ` Joe <dev@freedomcircle.net>
2007-05-02 05:05 ` Dmitry Turin <sql4-en@narod.ru>
2007-05-02 12:47 ` Joe <dev@freedomcircle.net>
2007-04-26 16:57 ` Adam Tauno Williams <adamtaunowilliams@gmail.com>
2007-04-20 14:49 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-20 15:52 ` Andrew Sullivan <ajs@crankycanuck.ca>
2007-04-20 17:04 ` Dmitry Turin <sql4-en@narod.ru>
2007-04-20 11:14 ` Bart Degryse <Bart.Degryse@indicator.be>
2007-04-23 06:46 ` Re: We all are looped on Internet: request +transport = invariant Bart Degryse <Bart.Degryse@indicator.be>
2007-04-23 10:18 ` Re: We all are looped on Internet: request+transport = invariant Bart Degryse <Bart.Degryse@indicator.be>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox