Ok so perhaps there is this and that. My point is a database like SQL server
is architected in a  very different manner to U2 - it is the actual central
sqlserver.exe process that does the majority of the work, it accesses the
tables and presents them to the api, its caching often used data, it obeys
the schema, transaction, referential, indexing rules, it map reduces
collations and totals, it looks after security, pools, licencing a whole
plethora of things. Thereis a lot more out of the box inside SQL server than
there is from U2 (again not saying it is better, just different) The central
U2 processes look after licencing, locks, shared memory subroutines and a
few other things. It is the udt or uvsh client process in which your
databasic runs that has built into it the DB access code this is the key
difference I feel, and hence why I feel clever unibasic code has a right to
do clever things with sockets and xml etc.



-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: 04 October 2012 09:20
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Consuming Web Services

A U2 Table *can* also have referential integrity, it's an option.
And SQL Table don't force referential integrity, you can turn that off :)


 

 

 

-----Original Message-----
From: Symeon Breen <syme...@gmail.com>
To: 'U2 Users List' <u2-users@listserver.u2ug.org>
Sent: Thu, Oct 4, 2012 1:17 am
Subject: Re: [U2] Consuming Web Services


I know - but you have to set it up against specific attributes and it
creates a fairly standard index for the specified attributes in hand,  you
do that on sql as well, but it does its own indexing to make row retrieval
optimised, has its own referential integrity rules around that etc. It's
quite a different beast altogether. I am not saying it is better, but it
does a lot more inside than U2 does.

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: 04 October 2012 09:05
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Consuming Web Services


 The U2 database does do indexing.


 

 

-----Original Message-----
From: Symeon Breen <syme...@gmail.com>
To: 'U2 Users List' <u2-users@listserver.u2ug.org>
Sent: Thu, Oct 4, 2012 12:56 am
Subject: Re: [U2] Consuming Web Services


But we all know U2 is much more than a DB, in fact it is also much less than
a DB.

The concept of having the DB just do DB stuff works fine for SQL server and
MySQL where the DB itself actually does a lot in terms of the data, and the
clients, written in .NET, C, Python Java etc do all the business logic. For
these stored procedures do exist but are usually kept to a minimum and
certainly only for data interaction.

The U2 databases are actually quite stupid, they store and retrieve data
from tables in a (hopefully) quick and efficient  manner, but they certainly
don't do any of the clever stuff you find inside Sql server like map reduce,
caching, indexing etc. The clever bits are what we do in the unibasic code.
So I firmly believe there  IS a case for the clever Unibasic code we write
to access data over http, read in xml and to then process all of these
different data streams. Yeah sure there are things which in theory are
easier to do outside It does not mean you should always do things outside of
unibasic.





-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: 03 October 2012 23:48
To: U2 Users List
Subject: Re: [U2] Consuming Web Services

Tony and Ben are right on...

Invoking Stephen Colbert's concept of... "The Word"... the word is...
"MiddleWare".   As legacy U2 was ahead of its time... by building-in
middleware technologies... it is easy to lose sight of what belongs where.

--Bill

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: Wednesday, October 03, 2012 6:31 PM
Subject: Re: [U2] Consuming web services

I do the same as Ben but with .NET:
-- Local U2 <> .NET client <web service> Remote server

Pick is a database server, not a communications protocol end-point. We
simply should not be doing direct comms from this platform anymore, given
the huge number of mainstream options. This is coming from someone who has
written all of the bi-directional comms interfaces to/from MV with sockets
and cURL and plugins and anything else I could create - because (in the
90's) people said it wasn't possible and because I figured it would be kewl
just to do it.

It _is_ all technically possible, but that doesn't mean it makes good
business sense: Doing things like this in BASIC creates a maintenance hassle
later. It leaves the environment subject to DBMS-specific issues that often
aren't addressed for quite a long time. Using mainstream tools vastly
increases the resources available for getting help and solving problems.

So these days I get MV to push a query or data payload out to a middle-tier
that uses the latest communications methods available.
The request goes out, the response comes back, it all just works - that That
should be our bottom line here.

HTH
T

> From: Ben Souther
> We use a middle layer written in Java.

> Jeff Schasny wrote:
> > I know we have both the SOAP and RESTful web services development
for
> > publishing web services from Universe but how are folks consuming 
> > other peoples web services into the database? Are there tools for
this
> > or am I going to just open a socket, read, and parse 'till I'm
blue in the face?


_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

 
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to