Re: [U2] Why Pick U2?

2011-11-03 Thread DavidJMurray (mvdbs.com)


Dan,

Did you complete the article regarding ramdisks and U2?

djm


Daniel McGrath wrote:
 
 I've used them in development, but not in Production.
 
 I am just about to post an article that includes usage; I just haven't had
 time to finish proof-reading it.
 
 For windows, check it this question:
 http://superuser.com/questions/34388/whats-the-best-ramdisk-for-windows
 
 Regards,
 Dan
 
 -Original Message-
 
 Is anyone using a RAMDisk with U2 files?
 
 I have noticed that there are two types of ram disks within Linux - tmpfs
 and /dev/ram1 which can be used to create a small file system.
 
 Does anyone have any practical experience on these options?
 
 Is there an effective option for MS-Windows?
 
 Cheers,
 djm
 
 
 
 


-

Learn and Do
Excel and Share


http://mvdbs.com http://mvdbs.com 
-- 
View this message in context: 
http://old.nabble.com/Why-Pick-U2--tp32061959p32775910.html
Sent from the U2 - Users mailing list archive at Nabble.com.

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


Re: [U2] Why Pick U2?

2011-11-03 Thread Daniel McGrath (Home)

Hi David,

 I wrote this awhile ago:
http://u2tech.wordpress.com/2011/08/26/application-level-caching/

Regards,
Dan


DavidJMurray (mvdbs.com) wrote:
 
 
 Dan,
 
 Did you complete the article regarding ramdisks and U2?
 
 djm
 
 
 Daniel McGrath wrote:
 
 I've used them in development, but not in Production.
 
 I am just about to post an article that includes usage; I just haven't
 had time to finish proof-reading it.
 
 For windows, check it this question:
 http://superuser.com/questions/34388/whats-the-best-ramdisk-for-windows
 
 Regards,
 Dan
 
 -Original Message-
 
 Is anyone using a RAMDisk with U2 files?
 
 I have noticed that there are two types of ram disks within Linux - tmpfs
 and /dev/ram1 which can be used to create a small file system.
 
 Does anyone have any practical experience on these options?
 
 Is there an effective option for MS-Windows?
 
 Cheers,
 djm
 
 
 
 
 
 

-- 
View this message in context: 
http://old.nabble.com/Why-Pick-U2--tp32061959p32775912.html
Sent from the U2 - Users mailing list archive at Nabble.com.

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


Re: [U2] Why Pick U2?

2011-08-26 Thread Wols Lists
On 26/08/11 01:18, George Gallen wrote:
 But swap space isn't really memory, it's disk and nowhere near as fast as 
 memory, and (I don't know for sure) probably
 even far slower than SSD's.
 
 In reality, if your creating a tempfs partition for the speed of memory vs 
 disk, then using swap space defeats the purpose.
 
Agreed (partially :-)

If your access is lumpy, or (not in this case) you are creating zillions
of files, or probably some other reasons, it still makes sense. For
example, in my case (gentoo emerge) it creates lots of small files that
it creates, uses, then forgets about. By using tmpfs, they don't get
flushed to disk in the normal course of events, and if they do, chances
are I no longer care.

And the OP didn't mention speed. Maybe that's not why he wanted ramdisk?
After all, isn't the whole point of Pick that a memory-starved Pick
machine can still outrun an Oracle with ram coming out its ears? :-)

Cheers,
Wol

 George Gallen
 Senior Programmer/Analyst
 Accounting/Data Division
 ggal...@wyanokegroup.com
 ph:856.848.9005 Ext 220
 The Wyanoke Group
 http://www.wyanokegroup.com
 
 From: u2-users-boun...@listserver.u2ug.org 
 [u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists 
 [antli...@youngman.org.uk]
 Sent: Thursday, August 25, 2011 7:28 PM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Why Pick U2?
 
 On 25/08/11 16:47, George Gallen wrote:
 keep in mind:

 SSD drives have a limited number of writes (much better today than before)
 tempfs do not (or at least I don't think so)
 SSD drives however usually can store a LOT more than a tempfs file, which
 depends on your physical memory - You couldn't create a 100GB tempfs
 if you wanted to
 
 Completely wrong ... :-)
 
 My /tmp dir happens to be 8Gb in size - on a system with 8Gb of ram. I
 *also* have a 20Gb /var/tmp/portage. Both of these are tmpfs systems, so
 I have 28Gb of tmpfs on a system with only 8Gb of ram :-)
 
 That said, you must have sufficient total memory - I've got something in
 excess of 40Gb of total address space. I'm not sure how big my swap
 partitions are, but there's more than 32Gb (my rule is at least twice
 the mobo's max ram capacity, and with 1.5Tb of disk space, that's
 peanuts :-)
 
 But ram disks do default to half available ram, and that burnt me when I
 first hit it...
 
 SSD drives don't forget when you reboot

 But that's the whole point of ram disks :-)
 
 Cheers,
 Wol
 ___
 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


Re: [U2] Why Pick U2?

2011-08-25 Thread Daniel McGrath
I've used them in development, but not in Production.

I am just about to post an article that includes usage; I just haven't had time 
to finish proof-reading it.

For windows, check it this question: 
http://superuser.com/questions/34388/whats-the-best-ramdisk-for-windows

Regards,
Dan

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of DavidJMurray 
(mvdbs.com)
Sent: Thursday, August 25, 2011 9:19 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Why Pick U2?


Is anyone using a RAMDisk with U2 files?

I have noticed that there are two types of ram disks within Linux - tmpfs and 
/dev/ram1 which can be used to create a small file system.

Does anyone have any practical experience on these options?

Is there an effective option for MS-Windows?

Cheers,
djm


Daniel McGrath wrote:
 
 
 6) Not only can you use U2 in a relational manner, complete with SQL 
 access, but since its core data structure are hash tables, if you want 
 to use it just as a key-value store look no further. If you want to 
 run it is a key-value store in memory (aka Memcache), mount a RAMDisk 
 and place the file there. Voila. No need to configure separate 
 systems, as flexible as you want it to be. You can even replicate from 
 it to multiple other servers if you want. Want it encrypted too? Done!
 
 
 


-

Learn and Do
Excel and Share


http://mvdbs.com http://mvdbs.com
--
View this message in context: 
http://old.nabble.com/Why-Pick-U2--tp32061959p32335234.html
Sent from the U2 - Users mailing list archive at Nabble.com.

___
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


Re: [U2] Why Pick U2?

2011-08-25 Thread John Thompson
Well I guess I should rephrase...

It is seen as another block device to the OS, Windows, Linux or what have
you.

So, in Windows it would be a drive letter.
In Linux it would be a block device that you could partition and format.

I have not personally used it, but, there are folks out there using it in
the relational database world.

The cheaper route to go would be to create a ramdisk in Linux, in the RAM
itself... I have not done that in a long time.

I have never created a RAMDISK in windows... not since the DOS days anyway
at least.

On Thu, Aug 25, 2011 at 11:28 AM, John Thompson jthompson...@gmail.comwrote:

 Its expensive... and it seems fairly safe as IBM, HP, and Dell are all
 selling it now...

 Take a look at this:

 http://www.fusionio.com/


 http://www-304.ibm.com/shop/americas/content/home/store_IBMPublicUSA/en_US/ibmfusionio.html

 It basically acts just like a disk from what I understand, except that you
 can't boot from it.


 On Thu, Aug 25, 2011 at 11:19 AM, DavidJMurray (mvdbs.com) 
 nab...@mvdbs.com wrote:


 Is anyone using a RAMDisk with U2 files?

 I have noticed that there are two types of ram disks within Linux - tmpfs
 and /dev/ram1 which can be used to create a small file system.

 Does anyone have any practical experience on these options?

 Is there an effective option for MS-Windows?

 Cheers,
 djm


 Daniel McGrath wrote:
 
 
  6) Not only can you use U2 in a relational manner, complete with SQL
  access, but since its core data structure are hash tables, if you want
 to
  use it just as a key-value store look no further. If you want to run it
 is
  a key-value store in memory (aka Memcache), mount a RAMDisk and place
 the
  file there. Voila. No need to configure separate systems, as flexible as
  you want it to be. You can even replicate from it to multiple other
  servers if you want. Want it encrypted too? Done!
 
 
 


 -

 Learn and Do
 Excel and Share


 http://mvdbs.com http://mvdbs.com
 --
 View this message in context:
 http://old.nabble.com/Why-Pick-U2--tp32061959p32335234.html
 Sent from the U2 - Users mailing list archive at Nabble.com.

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




 --
 John Thompson




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


Re: [U2] Why Pick U2?

2011-08-25 Thread DavidJMurray (mvdbs.com)


I mean using the existing RAM within the system to create and mount a small
file system which a temporary U2 file can be created and used; rather than a
complete SSD device.



John Thompson-15 wrote:
 
 Its expensive... and it seems fairly safe as IBM, HP, and Dell are all
 selling it now...
 
 
 
 


-

Learn and Do
Excel and Share


http://mvdbs.com http://mvdbs.com 
-- 
View this message in context: 
http://old.nabble.com/Why-Pick-U2--tp32061959p32335366.html
Sent from the U2 - Users mailing list archive at Nabble.com.

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


Re: [U2] Why Pick U2?

2011-08-25 Thread John Thompson
Yes, but, old school ramdisks (i.e. creating disks in existing RAM),
aren't exactly reliable if something goes wrong (i.e. power anomalies, bad
memory block,  etc.).  So whatever you would be storing would have to be
temporary (which I guess you have already said), AND, you would have to NOT
care if you lost it in a production environment.

At least from what I remember of them... but like I said its been a while
for me.  I'm sure someone has tried it before :)

On Thu, Aug 25, 2011 at 11:35 AM, DavidJMurray (mvdbs.com) nab...@mvdbs.com
 wrote:



 I mean using the existing RAM within the system to create and mount a small
 file system which a temporary U2 file can be created and used; rather than
 a
 complete SSD device.



 John Thompson-15 wrote:
 
  Its expensive... and it seems fairly safe as IBM, HP, and Dell are all
  selling it now...
 
 
 
 


 -

 Learn and Do
 Excel and Share


 http://mvdbs.com http://mvdbs.com
 --
 View this message in context:
 http://old.nabble.com/Why-Pick-U2--tp32061959p32335366.html
 Sent from the U2 - Users mailing list archive at Nabble.com.

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




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


Re: [U2] Why Pick U2?

2011-08-25 Thread George Gallen
I use the following scripts with our Linux system

[george@alpha mbin]$ cat mount-temp
/bin/mount -t tmpfs -o size=1G,nr_inodes=5k tmpfs /usr/tmpfs
(cd /usr ; /bin/tar xvf /usr/drive1/tempfsbackup .)

[george@alpha mbin]$ cat unmount-temp
(cd /usr ; /bin/tar cvf /usr/drive1/tempfsbackup ./tmpfs)
/bin/umount /usr/tmpfs

First I created the /usr/tmpfs manually (by executing the first line of 
mount-temp)
Second, I cd'd into the directory, then UV to create a UV account
Third, I went into the UV login account, and linked it as a valid account (So I 
could reference Q pointers)

I run the unmount script to tar up the account first and save the tar file, 
then release the tempfs
I run the mount script to create the tempfs, then untar the account

I forget what the max size of the /tmpfs can be (I just set mine up with 1G)

George


 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com)
 Sent: Thursday, August 25, 2011 11:35 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Why Pick U2?
 
 
 
 I mean using the existing RAM within the system to create and mount a
 small
 file system which a temporary U2 file can be created and used; rather
 than a
 complete SSD device.
 
 
 
 John Thompson-15 wrote:
 
  Its expensive... and it seems fairly safe as IBM, HP, and Dell are
 all
  selling it now...
 
 
 
 
 
 
 -
 
 Learn and Do
 Excel and Share
 
 
 http://mvdbs.com http://mvdbs.com
 --
 View this message in context: http://old.nabble.com/Why-Pick-U2--
 tp32061959p32335366.html
 Sent from the U2 - Users mailing list archive at Nabble.com.
 
 ___
 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


Re: [U2] Why Pick U2?

2011-08-25 Thread George Gallen
keep in mind:

SSD drives have a limited number of writes (much better today than before)
tempfs do not (or at least I don't think so)
SSD drives however usually can store a LOT more than a tempfs file, which
depends on your physical memory - You couldn't create a 100GB tempfs
if you wanted to
SSD drives don't forget when you reboot

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com)
 Sent: Thursday, August 25, 2011 11:35 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Why Pick U2?
 
 
 
 I mean using the existing RAM within the system to create and mount a
 small
 file system which a temporary U2 file can be created and used; rather
 than a
 complete SSD device.
 
 
 
 John Thompson-15 wrote:
 
  Its expensive... and it seems fairly safe as IBM, HP, and Dell are
 all
  selling it now...
 
 
 
 
 
 
 -
 
 Learn and Do
 Excel and Share
 
 
 http://mvdbs.com http://mvdbs.com
 --
 View this message in context: http://old.nabble.com/Why-Pick-U2--
 tp32061959p32335366.html
 Sent from the U2 - Users mailing list archive at Nabble.com.
 
 ___
 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


Re: [U2] Why Pick U2?

2011-08-25 Thread John Thompson
It looks like you could do it in Windows 2000 Server natively...

http://social.technet.microsoft.com/Search/en-US?query=ramdiskac=8

Not sure what they did with it in 2003/2008 Server.  They may call it a
RAMDrive

On Thu, Aug 25, 2011 at 11:43 AM, George Gallen ggal...@wyanokegroup.comwrote:

 I use the following scripts with our Linux system

 [george@alpha mbin]$ cat mount-temp
 /bin/mount -t tmpfs -o size=1G,nr_inodes=5k tmpfs /usr/tmpfs
 (cd /usr ; /bin/tar xvf /usr/drive1/tempfsbackup .)

 [george@alpha mbin]$ cat unmount-temp
 (cd /usr ; /bin/tar cvf /usr/drive1/tempfsbackup ./tmpfs)
 /bin/umount /usr/tmpfs

 First I created the /usr/tmpfs manually (by executing the first line of
 mount-temp)
 Second, I cd'd into the directory, then UV to create a UV account
 Third, I went into the UV login account, and linked it as a valid account
 (So I could reference Q pointers)

 I run the unmount script to tar up the account first and save the tar file,
 then release the tempfs
 I run the mount script to create the tempfs, then untar the account

 I forget what the max size of the /tmpfs can be (I just set mine up with
 1G)

 George


  -Original Message-
  From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
  boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com)
  Sent: Thursday, August 25, 2011 11:35 AM
  To: u2-users@listserver.u2ug.org
  Subject: Re: [U2] Why Pick U2?
 
 
 
  I mean using the existing RAM within the system to create and mount a
  small
  file system which a temporary U2 file can be created and used; rather
  than a
  complete SSD device.
 
 
 
  John Thompson-15 wrote:
  
   Its expensive... and it seems fairly safe as IBM, HP, and Dell are
  all
   selling it now...
  
  
  
  
 
 
  -
 
  Learn and Do
  Excel and Share
 
 
  http://mvdbs.com http://mvdbs.com
  --
  View this message in context: http://old.nabble.com/Why-Pick-U2--
  tp32061959p32335366.html
  Sent from the U2 - Users mailing list archive at Nabble.com.
 
  ___
  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




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


Re: [U2] Why Pick U2?

2011-08-25 Thread George Gallen
as for windows - I used to use a program called clone drive or something like 
that
It would create a virtual drive from memory

http://virtual-clonedrive.en.softonic.com/

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
 boun...@listserver.u2ug.org] On Behalf Of DavidJMurray (mvdbs.com)
 Sent: Thursday, August 25, 2011 11:19 AM
 To: u2-users@listserver.u2ug.org
 Subject: Re: [U2] Why Pick U2?
 
 
 Is anyone using a RAMDisk with U2 files?
 
 I have noticed that there are two types of ram disks within Linux -
 tmpfs
 and /dev/ram1 which can be used to create a small file system.
 
 Does anyone have any practical experience on these options?
 
 Is there an effective option for MS-Windows?
 
 Cheers,
 djm
 
 
 Daniel McGrath wrote:
 
 
  6) Not only can you use U2 in a relational manner, complete with SQL
  access, but since its core data structure are hash tables, if you
 want to
  use it just as a key-value store look no further. If you want to run
 it is
  a key-value store in memory (aka Memcache), mount a RAMDisk and place
 the
  file there. Voila. No need to configure separate systems, as flexible
 as
  you want it to be. You can even replicate from it to multiple other
  servers if you want. Want it encrypted too? Done!
 
 
 
 
 
 -
 
 Learn and Do
 Excel and Share
 
 
 http://mvdbs.com http://mvdbs.com
 --
 View this message in context: http://old.nabble.com/Why-Pick-U2--
 tp32061959p32335234.html
 Sent from the U2 - Users mailing list archive at Nabble.com.
 
 ___
 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


Re: [U2] Why Pick U2?

2011-08-25 Thread DavidJMurray (mvdbs.com)


I was looking at writing a similar article/blog post as I am reading on
coalesced hashing at the moment.

I'll wait until yours appears.



Daniel McGrath wrote:
 
 
 I am just about to post an article that includes usage; I just haven't had
 time to finish proof-reading it.
 
 
 


-

Learn and Do
Excel and Share


http://mvdbs.com http://mvdbs.com 
-- 
View this message in context: 
http://old.nabble.com/Why-Pick-U2--tp32061959p32335579.html
Sent from the U2 - Users mailing list archive at Nabble.com.

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


Re: [U2] Why Pick U2?

2011-08-25 Thread Wols Lists
On 25/08/11 16:47, George Gallen wrote:
 keep in mind:
 
 SSD drives have a limited number of writes (much better today than before)
 tempfs do not (or at least I don't think so)
 SSD drives however usually can store a LOT more than a tempfs file, which
 depends on your physical memory - You couldn't create a 100GB tempfs
 if you wanted to

Completely wrong ... :-)

My /tmp dir happens to be 8Gb in size - on a system with 8Gb of ram. I
*also* have a 20Gb /var/tmp/portage. Both of these are tmpfs systems, so
I have 28Gb of tmpfs on a system with only 8Gb of ram :-)

That said, you must have sufficient total memory - I've got something in
excess of 40Gb of total address space. I'm not sure how big my swap
partitions are, but there's more than 32Gb (my rule is at least twice
the mobo's max ram capacity, and with 1.5Tb of disk space, that's
peanuts :-)

But ram disks do default to half available ram, and that burnt me when I
first hit it...

 SSD drives don't forget when you reboot
 
But that's the whole point of ram disks :-)

Cheers,
Wol
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why Pick U2?

2011-08-25 Thread Wols Lists
On 25/08/11 16:19, DavidJMurray (mvdbs.com) wrote:
 Is anyone using a RAMDisk with U2 files?
 
 I have noticed that there are two types of ram disks within Linux - tmpfs
 and /dev/ram1 which can be used to create a small file system.
 
 Does anyone have any practical experience on these options?

tmpfs on linux is pretty reliable. From my other post you can see I use
it by default :-)

Not sure what you're trying to do, but you might want to combine it with
union mounting. If you want to create temporary workspace, you might be
better creating it on disk and throwing it away when you're finished,
but if you really want to use ramdisk then ...

Create a set of empty files pointed to from your VOC (or VOCLIB)
elsewhere. Union mount a tmpfs over the directory containing your empty
files, and then you don't need to worry about whether they're there
after a reboot or anything like that. When the system comes up, it will
see the empty files on the hard disk. As the files are updated, they'll
be stored on ramdisk. When the system reboots, the updated files will be
lost and the system will once again see the empty files on disk ... usw
usw usw.

Cheers,
Wol
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why Pick U2?

2011-08-25 Thread George Gallen
But swap space isn't really memory, it's disk and nowhere near as fast as 
memory, and (I don't know for sure) probably
even far slower than SSD's.

In reality, if your creating a tempfs partition for the speed of memory vs 
disk, then using swap space defeats the purpose.

George Gallen
Senior Programmer/Analyst
Accounting/Data Division
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com

From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists 
[antli...@youngman.org.uk]
Sent: Thursday, August 25, 2011 7:28 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Why Pick U2?

On 25/08/11 16:47, George Gallen wrote:
 keep in mind:

 SSD drives have a limited number of writes (much better today than before)
 tempfs do not (or at least I don't think so)
 SSD drives however usually can store a LOT more than a tempfs file, which
 depends on your physical memory - You couldn't create a 100GB tempfs
 if you wanted to

Completely wrong ... :-)

My /tmp dir happens to be 8Gb in size - on a system with 8Gb of ram. I
*also* have a 20Gb /var/tmp/portage. Both of these are tmpfs systems, so
I have 28Gb of tmpfs on a system with only 8Gb of ram :-)

That said, you must have sufficient total memory - I've got something in
excess of 40Gb of total address space. I'm not sure how big my swap
partitions are, but there's more than 32Gb (my rule is at least twice
the mobo's max ram capacity, and with 1.5Tb of disk space, that's
peanuts :-)

But ram disks do default to half available ram, and that burnt me when I
first hit it...

 SSD drives don't forget when you reboot

But that's the whole point of ram disks :-)

Cheers,
Wol
___
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


Re: [U2] Why Pick U2?

2011-07-16 Thread Rob Sobers
 that will address some of the
 issues people have raised in this thread.

 UniObjects (COM) is an ancient interface. Don't forgot that there is now
 EDA, a SOAP-based web-service provider and a RESTful web-service provider
 (in beta).

 Better resources: more is coming. U2DevZone is up, it is now open (no sign
 in required anymore) with articles, video tutorials and podcasts. You can
 take this as a solid indication that the folks here are committed to
 providing material that makes U2 a more attractive option.

 Yes, times are interesting in the database world right now. There has not
 been this much attention and diversity for as long as I can remember. I'd
 love to see you (and everyone else) at U2U next year, meet some of
 management  engineering and see what is happening in the U2/MV world and
 maybe even provide some insight into what keeps you interested in the MV
 world and what doesn't. Obviously there is something in there that interests
 your technical mind for you still to be posting on this list. :)

 Cheers,
 Dan

 PS: Thanks also to all those that sent direct replies to me. If I haven't
 got back to you yet, I will endeavor to do so next week.

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:
 u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers
 Sent: Thursday, July 14, 2011 4:41 PM
 To: U2 Users List
 Subject: Re: [U2] Why Pick U2?

 Hey Dan,

 Great response! Thanks for chiming in.  Let me address some of your points.

 Cherry-picking individual features from one database to compare them, then
 cherry-picking from completely different database when counter-points are
 raised is not exactly a technically sound (or fair) way to do comparisons.

 You're certainly right, but that's not I'm doing.  I believe the only
 direct feature comparison I made was to MongoDB, which falls into the same
 class of database as U2.

 Besides, the discussion isn't purely about technical capabilities (though
 they certainly matter and U2 has been sluggish with new feature development)
 as much as it is about the overall value proposition.

 I'm not trying to be a troll, or incite the folks that love U2, or call out
 Rocket.  As a long-time U2 user, I'm simply making an honest and blunt
 statement that I  would not pick U2 as my database on a new product, and I'm
 curious to hear if others can argue in favor of U2 given the rise of lower
 cost, popular alternatives in the same niche.

 I think it's extremely hard to argue in favor of U2 give its price tag and
 underdeveloped ecosystem.

 For *me personally*, when I'm contemplating which technology to use on a
 new project, some of the things that are very important are:

 1.) Mainstream adoption.  If I have a wacky problem with U2, I basically 2
 places to go: Rocket support or this list.  That's it.  You can't overlook
 the beneifts of using mainstream technologies.


 http://www.google.com/trends?q=rocket+u2%2C+unidata%2C+mongodbctab=0geo=alldate=ytdsort=2

 Again, when I was working with U2 full-time, we were consistently finding
 core bugs in U2 that hampered business, and it would be months on end
 without any progress from IBM.

 (If you don't believe me, try using some of the SQL features in the latest
 build of UniData.)

 2) Ecosystem and accessibility.  Are there APIs, language bindings, and
 libraries available, or am I limited?

 I brought this up on another thread -- what if I need to parse JSON in
 UniBasic, or I want to generate a PDF document?  There simply aren't a
 wealth of UniBasic libraries available like there are in Java, Ruby, .NET,
 etc.

 This can be partially addressed by making U2 more accessible from modern
 languages or at the very least, provide better guidance and resources to
 help the users create their own.  Right now all we have is UniObjects, which
 is kinda crappy.

 c) Cost. U2 is expensive for what you get.  That might have been justified
 in the 90s, and 2000s when theren't were viable MV alternatives.  But now
 there are alternatives.  Free ones.

 It's easy to say that U2 has been around for a while, so it must be
 reliable and enterprise grade.  But I can't tell you how many times I've
 had to take my UniData system down and run guide because of database-level
 corruption.  Anecdotal yes, but so are your claims against MongoDB.  I
 believe Foursquare still uses it, and I'm going to venture a wild guess that
 their load is far greater than any single U2 customer's.

 I also don't buy the case for writing your business logic in what is
 basically a hamstrung stored procedure language.  This isn't necessary to
 get the benefits you're describing.  As long as you properly tier your code
 so that your business logic is separate from your presentation layer, it
 doesn't matter where the code lives physically.

 SQL access in U2 has been a pain point for me in the past, but maybe I was
 doing it wrong or things have changed lately.

 The idea of using U2 as in in-memory cache is an interesting idea

Re: [U2] Why Pick U2?

2011-07-16 Thread George Gallen
This essentially is what I was working on with my perl routines to interface 
with UV.

You would open a file giving the accout and filename and receive a token back
Then you could read items with an idname and the token getting an array back
pass a TCL command and be able to get back an array of ID's

Yes, it would be better if I could do these without having to write my own 
API..I agree.

George Gallen
Senior Programmer/Analyst
Accounting/Data Division
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.com

From: u2-users-boun...@listserver.u2ug.org 
[u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers 
[rsob...@gmail.com]
Sent: Saturday, July 16, 2011 12:37 PM
To: U2 Users List
Subject: Re: [U2] Why Pick U2?

It will be a big day for me when I can finally do something like I've
written below from programming language X and have a reasonably powerful,
user-friendly API for working with native U2 data.

db = UniData::Connection.new(localhost).db(mydb)
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why Pick U2?

2011-07-16 Thread Daniel McGrath (Home)

Play nice now Rob,

This is bordering on a 'holy war'. You seem to want to reiterate previous
points, ones that no one has argued with you.

As I already said, U2 cannot target all markets, but you appear to want to
discount that and focus on the market of you choosing. I believe you grossly
underestimate the size of U2's market, so let us just leave that at that.

Brian Leach as released several books, but that is neither here nor there.
No one is making claims that it is mainstream with the general public. In
fact, this leads to the next point.

No, I did not overlook your Google trends link, I dismissed it as baiting.
You know as well as I do that it doesn't mean anything. If you wish to
disagree, discuss that one with your boss first:
http://programmers.stackexchange.com/questions/70606/trends-of-java-and-javascript/70607#70607

U2 is not marketed as a standalone product like MDB, it is embedded in it.
Most people running it wouldn't even know.

I highly doubt that there will be a new acquirer for U2. I think it is safe
to safe that Rocket U2 will stay as is for a very, very long time. If you
want to know why, have a look at RS and have a look at the discussions
around why U2 was sold by IBM.

Once again, to address the majority of your post, I am not arguing that
there are things we can do better and we are working on it.

Tell Joel it is about networking at U2U, there is a whole market out there
that might not have heard of FogCreek or their offerings. :)

If you want further discussion on anything, feel free to continue it with my
privately. Not because I don't want it discussed openly, but because I'm
sure the rest of the people on this list would like this put to rest

Best regards,
Dan


Dan,

Let me me re-phrase my statement:

For 99% of software projects, MongoDB destroys U2 in every single aspect.
 And it's free.

The fact is, most people aren't developing emergency systems.  And even if I
were building a banking or emergency system today, despite U2's longevity,
I'd argue that up-time alone is not enough considering:

1. I can't find a book on U2 (how to administer, scale, interface, etc.).
2. I can't easily find technical talent who have experience with U2.
3. The technology has changed hands a number of times over the past decade.
(What prevents the next acquirer from ceasing development?)

Yes, you're right -- the people who have been using U2 for the last 20 years
successfully should probably stick with it for its reliability.  But someone
searching for a new database solution is going to be met with a multiple
barriers to entry (the first being discovering that U2 even exists).

Up-time is one aspect.  What about scaling?  Rapid development?  Community
support and involvement?  Look at what Craiglist is doing with MongoDB.  Did
you overlook my link to the Google search term comparison?

I browsed through the 116 page manual on EDA :-), but I don't want to have
to convert my data in order to access from anything but UniBasic.

It will be a big day for me when I can finally do something like I've
written below from programming language X and have a reasonably powerful,
user-friendly API for working with native U2 data.

db = UniData::Connection.new(localhost).db(mydb)

I digress.

I don't want to continue my argument in fear of sounding like I'm just here
to bash U2.  That's not the case.  I definitely interested in U2 at some
level even though I don't work with it much anymore.

Maybe it's something like Stockholm syndrome.  I worked in the U2 bubble for
so long.  Now that I'm out and benefiting widly from flexibility and
openness and thriving ecosystems, and I want U2 to be that way too.

The verdict is still out for me on Rocket, but I'd love to see the progress
you're talking about come to fruition.  I don't know if I can justify U2U to
Fog Creek, but we'll see. :-)

All the best,

-Rob
-- 
View this message in context: 
http://old.nabble.com/Why-Pick-U2--tp32061959p32075733.html
Sent from the U2 - Users mailing list archive at Nabble.com.

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


Re: [U2] Why Pick U2 ?

2011-07-15 Thread Symeon Breen
RE Eclipse 

Just about every programmer i know has eclipse installed.
Just about every .net programmer i know uses VS for their development
Just about every Java programmer i know use IntelJ IDEA for their
development
Just about every php programmer i lknow uses a php specific ide - there are
numerous

In fact i don't know of any programmer who uses eclipse as their main dev
environment. Sure they all have it installed, and use it occasionally  if
they want to delve into some language or something that they don't normally
use, but they all feel it tries to cater for everybody, but in so doing ends
up being a horrible cludge and nowhere near as effective as the top domain
specific ide's

I don't think Brian, or anyone, is suggesting we use AE/ED, but there should
be some great plugins into some other IDE's out there - or even a better
domain specific IDE not based on eclipse.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch
Sent: 14 July 2011 23:11
To: U2 Users List
Subject: Re: [U2] Why Pick U2 ?

Hi Brian:

Microsoft now has a plug-in for Eclipse see
http://msdn.microsoft.com/en-us/library/gg413285.aspx.  Eclipse just
released version 3.7 around June 22nd and they have had a million plus
downloads.  They released 62 projects with over 46 million lines of code
see http://www.eclipse.org/org/press-release/20110622indigo.php.

Eclipse is one of the premier IDE's out in the world.  Do want to teach
people to use ED/AE to create files, edit dictionaries, and edit code all in
that pretty wrapper called Telnet?  Or do you want to show them a MS based
editor that only does that?  Sorry, your free product does not cut the
mustard here.

We need to teach the young people coming into U2 world to use the finest
tool that allows continuous compiling, templates, outlines, bookmarks,
version control, copying and pasting data, listing files, and searching all
within a single IDE to name just a few functions.  Whether the Eclipse IDE
is from U2logic or Rocket Software there is no other tools on the market
that can compare feature to feature.

We know you can do all of the above with wrappers, amazing VOC items, and
scripts, but we must have time warped back to 1990's because we don't really
need to explain these to a newbie.  Those newbie's think we are just a bunch
of old men and old women.  We know we are the best so lets look like with
our state of the art tools.

Regards,
Doug
www.u2logic.com
Version control for the rest of us using Eclipse


 
  And get rid of Eclipse. It's horrible.
 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1390 / Virus Database: 1516/3764 - Release Date: 07/14/11

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


Re: [U2] Why Pick U2 ?

2011-07-15 Thread Rob Sobers
It's the least worst response to a bad situation - not having
business logic close to the database. It's more to test, develop, deploy and
change control. And to be successful it still needs to call stored
procedures at the back end.And to be successful it still needs to call
stored procedures at the back end.

Really?  I've worked on lots of successful products that didn't use stored
procedures at the back end.

Again, it doesn't matter where the code is *physically*.  What is this
close to the database catch phrase *really* mean anyway?  Are you talking
about speed?  I have to image you see some benefit, because IMHO you're
giving up a lot of flexibility by writing your business rules in stored
procedure languages like UniBasic and TSQL.  I'd also argue that having code
live with the database can make the application as a whole far less portable
as you scatter code around.  More moving parts is generally a bad thing.

Yes, you should tier your code and keep your business logic separate from
your presentation layer, but that doesn't mean it literally needs to be in a
stored procedure.  Look at the MVC pattern in Rails or ASP.NET MVC, for
instance.  In those frameworks, all of the business logic lives in model
classes in the main application, not the database.  It works really well --
if it didn't, people would break that mold and start putting code in sprocs.

-Rob

On Thu, Jul 14, 2011 at 3:41 PM, Brian Leach br...@brianleach.co.uk wrote:

 I've missed this discussion because I've been busy designing a website and
 app for a client.

 This being the real world, the site will eventually - of course - be
 delivered using SQL Server and C#, with the front end using AJAX calls to
 JSON services delivered through WCF. Which will no doubt take an age to
 develop, test, deploy and then reconfigure all over all again.

 So before getting to that stage, I've written a fully functioning
 prototype.
 Which is - of course - written in UniVerse and mvScript. Which means I've
 developed it all front to back in a few hours and it's robust and flexible
 enough that I can work through it sitting with the clients tomorrow and
 make
 changes in near real time as they come up with ideas.

 Which tells the story, in one, of what I do and don't like about U2.


 As to some of the other points:

 1. Someone mentioned SQL Server and the GUI word again. Please ... SQL
 Server has no UI. If you're coding a UI for SQL server you use C#. If
 you're
 coding a UI for U2 you can use C#. If you're coding business rules for SQL
 Server you can use SQL Manager. If you're coding business rules for U2 you
 can use BDT or mvDeveloper. It's a red herring.

 2. The other thread has been talking about locking. If there's one reason
 to
 use U2 over all else, it's pessimistic locking. The SQL world is full of
 script kiddies and wizard users who *think* they know SQL and don't have
 the
 first idea about concurrency, locking and merging.

 3. Yes, we now have CLR in SQL server, but how many SQL developers are
 actually using it? The initial push to add it was a horrible cludge and put
 off many of those who might have experimented, and for the rest of the
 community it's too alien. I think we'll see TSQL as the main language for
 back end work for a long, long time - and that doesn't begin to measure up
 to UniBasic. (but read on before you jump on this...)

 4. Having middle tier logic may be the norm but that does not mean it a
 good
 idea. It's the least worst response to a bad situation - not having
 business
 logic close to the database. It's more to test, develop, deploy and change
 control. And to be successful it still needs to call stored procedures at
 the back end.

 5. But if you really want a middle tier, you can still add one and use C#
 and it's 'proper libraries' with U2. If you really, really want.

 6. And either way, not having to stare at query optimizer output is a very
 good reason to like U2.

 BUT

 That doesn't mean U2 can't be improved by taking on some of the better
 features of the outside world.

 The indexing is still very primitive, the SQL support is weak, and it would
 be great to have some other languages built into the database runtime. Even
 java - shudder - would be better than nothing, and would provide those
 'missing' OO and library features that people think they want.

 Add OpenQM's version of objects into Basic while you're at it and make the
 Basic on the two products more similar. It's just a pain having to use two
 sets of syntax: Rocket could easily create a superset on both.

 Nowadays you can at least integrate the query and Basic language by using
 SQLExecute() function calls to @HSTMT - something that was always missing
 from the original Pick model. But it's not obvious and doesn't work from
 phantoms.

 For the client side, we need javascript bindings made easy - especially to
 JSON - as that is the most important language for new developers today.
 Look
 at all the new development platforms 

Re: [U2] Why Pick U2 ?

2011-07-15 Thread Charles_Shaffer
Bill
 But, obviously, not technology to a technologist!  :-)

It was a hard lesson to learn.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why Pick U2 ?

2011-07-15 Thread Tony Gravagno
 From: Steve Romanow
 When i look at an eclipse application I see 80% ui 
 that is not relevant to the task at hand.  I agree 
 that it and most every app implemented with it are 
 trash.

I agree with the first sentence that Eclipse is bloated, but
most every app implemented with it are trash ??  That's
unreasonable, as the IDE doesn't relate to the skills of the
developer, nor the end-product, unless the IDE inherently
precludes specific language/framework features from being used.

Miscellaneous: Eclipse is now the recommended platform for
Android apps and thus has attracted a new following.  Personally
I use NetBeans for both Java and PHP simply because it's
convenient (and VS for .NET).  It would be nice if we had more
options for MV-oriented development using mainstream tools.
There aren't enough companies building in such integration, and
not enough adoption in this market to make it worth it for more
companies to step up to the challenge.

T

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


Re: [U2] Why Pick U2 ?

2011-07-15 Thread Steve Romanow
On Fri, Jul 15, 2011 at 2:29 PM, Tony Gravagno 3xk547...@sneakemail.com wrote:
 From: Steve Romanow
 When i look at an eclipse application I see 80% ui
 that is not relevant to the task at hand.  I agree
 that it and most every app implemented with it are
 trash.

 I agree with the first sentence that Eclipse is bloated, but
 most every app implemented with it are trash ??  That's
 unreasonable, as the IDE doesn't relate to the skills of the
 developer, nor the end-product, unless the IDE inherently
 precludes specific language/framework features from being used.

 Miscellaneous: Eclipse is now the recommended platform for
 Android apps and thus has attracted a new following.  Personally
 I use NetBeans for both Java and PHP simply because it's
 convenient (and VS for .NET).  It would be nice if we had more
 options for MV-oriented development using mainstream tools.
 There aren't enough companies building in such integration, and
 not enough adoption in this market to make it worth it for more
 companies to step up to the challenge.

 T

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


That was a trollish unreasonable statement.  I apologize.  I think a
more appropriate statement would be:

overwhelmed by eclipses gargantuan size, and underwhelmed by the
applications presented.

Does it bother anyone that all of the Rocket provided eclipse apps
come with their own static copy of eclipse?

I mean the editor in BDT, is it that great of an editor, besides
being graphical and has syntax hilighting?

Real IDE's are necessary for some projects like java and (also java,
Droid) development since it helps with packaging and whatnot.  That
really doesnt seem necessary for an mv app.

I'll stick to my old school vim, mercurial, and ssh.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why Pick U2 ?

2011-07-15 Thread Symeon Breen
Re your Miscellaneous - eclipse may well be the recommended and i followed
that course last year when i started droid apps, but intelij IDEA, the
leading java ide, now does android out of the box, i have switched, and am
much happier :)




-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno
Sent: 15 July 2011 19:29
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Why Pick U2 ?

 From: Steve Romanow
 When i look at an eclipse application I see 80% ui 
 that is not relevant to the task at hand.  I agree 
 that it and most every app implemented with it are 
 trash.

I agree with the first sentence that Eclipse is bloated, but
most every app implemented with it are trash ??  That's
unreasonable, as the IDE doesn't relate to the skills of the
developer, nor the end-product, unless the IDE inherently
precludes specific language/framework features from being used.

Miscellaneous: Eclipse is now the recommended platform for
Android apps and thus has attracted a new following.  Personally
I use NetBeans for both Java and PHP simply because it's
convenient (and VS for .NET).  It would be nice if we had more
options for MV-oriented development using mainstream tools.
There aren't enough companies building in such integration, and
not enough adoption in this market to make it worth it for more
companies to step up to the challenge.

T

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1390 / Virus Database: 1516/3766 - Release Date: 07/15/11

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


Re: [U2] Why Pick U2 ?

2011-07-15 Thread Steve Romanow
Neat.  They have a community edition too.  Their charm product has a good
rep.
On Jul 15, 2011 4:24 PM, Symeon Breen syme...@gmail.com wrote:
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why Pick U2?

2011-07-15 Thread Daniel McGrath
Thanks for the reply Rob,

As to cherry picking, I wasn't calling out anyone in particular, but the thread 
in general. I believe some of our disagreement involves around the statement 
MongoDB, which falls into the same class of database as U2.: MongoDB is *not* 
an enterprise class database. As per Charles Shaffer post, would you honestly 
use MongoDB for his system? I wouldn't. You would either go with a major SQL DB 
or an MVDB (such as a U2 system). As I and others have noted, U2 gives you a 
unique value proposition in that it generally has faster change turn-around,  
cheaper associated costs and stability of platform (it will still be fine in 20 
years without major architectural changes). MongoDB just doesn't fit into this 
realm. It isn't enterprise class; it doesn't have the maturity to provide the 
guarantees needed in serious enterprise systems, even if only for the mere fact 
it hasn't been around long enough to prove it. As to FourSquare, please re-note 
the link to FS's 11 hour outage caused by MongoDB as an actual example. Can you 
imagine Bank of America having an 11 hour outage on all money transactions and 
how much money/customers they would lose? People have been conditioned to 
accept website outages from time to time. No-one is going to die because FS is 
down for a day. Other things in life are not forgiven/forgotten so easily. 
Emergency systems run on U2. I would consider myself insanely negligent if I 
convinced those emergency services to drop U2 and replace it with an immature 
(even if exciting) database such as MongoDB.

I cannot really comment on your issues with UniData, not knowing when or what 
they were. We ran UD at a Bank and out of our 20+ systems (most on MS SQL) it 
was by far the most stable with the least down time. It had to be, lest it put 
us out of business. 

U2 does not (and cannot) target EVERY market out there. Comparing it to other 
databases outside of the its core markets and saying MongoDB destroys U2 in 
every single aspect.  And it's free (http://goo.gl/7O5Hm) is a catchy, yet 
ultimately flawed statement.

I don't think anyone would argue that 'Big Blue' and 'Agile'  are the wine and 
cheese combination of the tech world. Please remember that U2 is now Rocket U2, 
not IBM U2. Rocket Software is an amazingly agile company in comparison. How 
long did it take them to release DataVu? Also remember that in the company 
scale of time U2 hasn't been with Rocket for that long. Take into account ramp 
up time for a new working environment, complete office move, rebranding of all 
products and documentation when determining how sluggish U2 is. Expect more 
developments to come out quicker. There are some exciting changes coming down 
the pipes that will address some of the issues people have raised in this 
thread.

UniObjects (COM) is an ancient interface. Don't forgot that there is now EDA, a 
SOAP-based web-service provider and a RESTful web-service provider (in beta).

Better resources: more is coming. U2DevZone is up, it is now open (no sign in 
required anymore) with articles, video tutorials and podcasts. You can take 
this as a solid indication that the folks here are committed to providing 
material that makes U2 a more attractive option.

Yes, times are interesting in the database world right now. There has not been 
this much attention and diversity for as long as I can remember. I'd love to 
see you (and everyone else) at U2U next year, meet some of management  
engineering and see what is happening in the U2/MV world and maybe even provide 
some insight into what keeps you interested in the MV world and what doesn't. 
Obviously there is something in there that interests your technical mind for 
you still to be posting on this list. :)

Cheers,
Dan

PS: Thanks also to all those that sent direct replies to me. If I haven't got 
back to you yet, I will endeavor to do so next week. 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers
Sent: Thursday, July 14, 2011 4:41 PM
To: U2 Users List
Subject: Re: [U2] Why Pick U2?

Hey Dan,

Great response! Thanks for chiming in.  Let me address some of your points.

Cherry-picking individual features from one database to compare them, then 
cherry-picking from completely different database when counter-points are 
raised is not exactly a technically sound (or fair) way to do comparisons.

You're certainly right, but that's not I'm doing.  I believe the only direct 
feature comparison I made was to MongoDB, which falls into the same class of 
database as U2.

Besides, the discussion isn't purely about technical capabilities (though they 
certainly matter and U2 has been sluggish with new feature development) as much 
as it is about the overall value proposition.

I'm not trying to be a troll, or incite the folks that love U2, or call out 
Rocket.  As a long-time U2 user, I'm simply making an honest and blunt 
statement

Re: [U2] Why Pick U2 ?

2011-07-14 Thread Mecki Foerthmann

So what are libraries?
They are nothing but a collection of subroutines that somebody else has 
written.
And what do you do if you can't find a function in your library that 
does exactly what you need?

You write your own, right?
And by the time you have found the right function in your library you 
could have written the 3 lines of code in Basic that do the same thing 
already.
I write Databasic code every day and have done so for over 20 years and 
hardly ever have use for functions, because if I needed them I would 
have written my own library by.


Mecki



On 14/07/2011 02:25, Rob Sobers wrote:

I have to heartily disagree that U2 has a sophisticated business rules
engine.  U2 Basic is such a limited language.  It barely has functions, and
you have to home brew almost everything.

Microsoft's T-SQL stored procedures are just as horrible to write as U2
Basic programs.  As Jeff Atwood put it -- Stored procedures should be
considered database assembly language. [1] Why do you think Microsoft now
allows you to call CLR code from stored procedures?  Because it's so much
more efficient to work with the data (i.e., enforce the business rules) in a
modern language like C# that has *actual libraries* for doing useful things.

I agree that business rules shouldn't be on the client -- but who says they
have to be in the database?  Look at the ever-so-popular MVC architecture.
  The models (i.e., the code that works with the database and enforces all of
the business rules) are isolated from the views (i.e., the
client/presentation code) entirely.

-Rob

[1]:
http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html

On Wed, Jul 13, 2011 at 7:29 PM, Kevin Kingprecisonl...@gmail.com  wrote:


+1 for what David said.  Yes, there's the limitation that BASIC is the
only native supported language (not factoring external connectors), but as
a
language native to the environment, this BASIC is really pretty rich by
comparison to the stored procedure languages of other DBs.
___
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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Charles Carroll
Amen Rob.

T-SQL bites. So  I write CLR Sprocs or do the heavy lifting in C# and
then call very minimal Sprocs.

On Wed, Jul 13, 2011 at 9:25 PM, Rob Sobers rsob...@gmail.com wrote:
 I have to heartily disagree that U2 has a sophisticated business rules
 engine.  U2 Basic is such a limited language.  It barely has functions, and
 you have to home brew almost everything.

 Microsoft's T-SQL stored procedures are just as horrible to write as U2
 Basic programs.  As Jeff Atwood put it -- Stored procedures should be
 considered database assembly language. [1] Why do you think Microsoft now
 allows you to call CLR code from stored procedures?  Because it's so much
 more efficient to work with the data (i.e., enforce the business rules) in a
 modern language like C# that has *actual libraries* for doing useful things.

 I agree that business rules shouldn't be on the client -- but who says they
 have to be in the database?  Look at the ever-so-popular MVC architecture.
  The models (i.e., the code that works with the database and enforces all of
 the business rules) are isolated from the views (i.e., the
 client/presentation code) entirely.

 -Rob

 [1]:
 http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html

 On Wed, Jul 13, 2011 at 7:29 PM, Kevin King precisonl...@gmail.com wrote:

 +1 for what David said.  Yes, there's the limitation that BASIC is the
 only native supported language (not factoring external connectors), but as
 a
 language native to the environment, this BASIC is really pretty rich by
 comparison to the stored procedure languages of other DBs.
 ___
 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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Symeon Breen
I think the power of Databasic can be (and is certainl seen as) the problem
- esp if you are from a computer science background, yes it is more powerful
than t-sql and other languages that 'sit inside the DB' but it is nowhere
near as powerful as a full language like c#, java etc. 

In other architectures they usually use three tiers, data, business,
presentation, mvc is an example of this, or just plain asp.net web forms you
would use a dal, a bll and then your presentation. 

Because databasic has a certain amount of power we write data access and
business logic all muddled up together in there, and then if we are also
using an api many put a bit more business logic in the upper layer
(java/.net). The split is usually fairly well defined, and that's fine, but
computer scientists (who don't live in the real world btw) would say it  was
broken and needed fixing.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers
Sent: 14 July 2011 02:26
To: U2 Users List
Subject: Re: [U2] Why Pick U2 ?

I have to heartily disagree that U2 has a sophisticated business rules
engine.  U2 Basic is such a limited language.  It barely has functions, and
you have to home brew almost everything.

Microsoft's T-SQL stored procedures are just as horrible to write as U2
Basic programs.  As Jeff Atwood put it -- Stored procedures should be
considered database assembly language. [1] Why do you think Microsoft now
allows you to call CLR code from stored procedures?  Because it's so much
more efficient to work with the data (i.e., enforce the business rules) in a
modern language like C# that has *actual libraries* for doing useful things.

I agree that business rules shouldn't be on the client -- but who says they
have to be in the database?  Look at the ever-so-popular MVC architecture.
 The models (i.e., the code that works with the database and enforces all of
the business rules) are isolated from the views (i.e., the
client/presentation code) entirely.

-Rob

[1]:
http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways
.html

On Wed, Jul 13, 2011 at 7:29 PM, Kevin King precisonl...@gmail.com wrote:

 +1 for what David said.  Yes, there's the limitation that BASIC is the
 only native supported language (not factoring external connectors), but as
 a
 language native to the environment, this BASIC is really pretty rich by
 comparison to the stored procedure languages of other DBs.
 ___
 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
-
No virus found in this message.
Checked by AVG - www.avg.com
Version: 10.0.1390 / Virus Database: 1516/3762 - Release Date: 07/13/11

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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Rob Sobers
Yes, and my point is that in the U2/UniBasic ecosystem, those collections of
subroutines are not readily available anywhere.

What if you want to use a web service that emits JSON?  Is it going to take
you 3 lines of code and 5 minutes to write a JSON parser?  And what about
serialization, compression, PDF generation?  These things are useful and not
trivial to write and maintain.

And what language features have been added to UniBasic lately?  I can't
think of any.  No objects, no regular expressions, no lambdas, etc.

-Rob

On Thu, Jul 14, 2011 at 3:27 AM, Mecki Foerthmann mec...@gmx.net wrote:

 So what are libraries?
 They are nothing but a collection of subroutines that somebody else has
 written.
 And what do you do if you can't find a function in your library that does
 exactly what you need?
 You write your own, right?
 And by the time you have found the right function in your library you could
 have written the 3 lines of code in Basic that do the same thing already.
 I write Databasic code every day and have done so for over 20 years and
 hardly ever have use for functions, because if I needed them I would have
 written my own library by.

 Mecki




 On 14/07/2011 02:25, Rob Sobers wrote:

 I have to heartily disagree that U2 has a sophisticated business rules
 engine.  U2 Basic is such a limited language.  It barely has functions,
 and
 you have to home brew almost everything.

 Microsoft's T-SQL stored procedures are just as horrible to write as U2
 Basic programs.  As Jeff Atwood put it -- Stored procedures should be
 considered database assembly language. [1] Why do you think Microsoft now
 allows you to call CLR code from stored procedures?  Because it's so much
 more efficient to work with the data (i.e., enforce the business rules) in
 a
 modern language like C# that has *actual libraries* for doing useful
 things.

 I agree that business rules shouldn't be on the client -- but who says
 they
 have to be in the database?  Look at the ever-so-popular MVC architecture.
  The models (i.e., the code that works with the database and enforces all
 of
 the business rules) are isolated from the views (i.e., the
 client/presentation code) entirely.

 -Rob

 [1]:
 http://www.codinghorror.com/**blog/2004/10/who-needs-stored-**
 procedures-anyways.htmlhttp://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html

 On Wed, Jul 13, 2011 at 7:29 PM, Kevin Kingprecisonl...@gmail.com
  wrote:

  +1 for what David said.  Yes, there's the limitation that BASIC is the
 only native supported language (not factoring external connectors), but
 as
 a
 language native to the environment, this BASIC is really pretty rich by
 comparison to the stored procedure languages of other DBs.
 __**_
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users

  __**_
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users

 __**_
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://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] Why Pick U2?

2011-07-14 Thread Daniel McGrath


_
From: Jackie Burhans
Sent: Thursday, July 14, 2011 8:55 AM
To: Daniel McGrath; Dave Peters
Cc: Vinnie Smith
Subject: RE: Post


Very thorough response. Minor edits below in red. One suggested cut noted like 
this {xxx}
One question--can you and Dave give some thoughts to conferences you might like 
to attend over the coming year. I'll talk with Susie about funding for that.

Jackie Burhans
Director, U2 Partner Enablement
Rocket Software
4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA
Tel: +1.720.475.8016 * Fax: +1.617.630.7392
Email: jburh...@rs.commailto:jburh...@rs.com
Web: www.rocketsoftware.com/u2http://www.rocketsoftware.com/u2

-Original Message-
From: Daniel McGrath
Sent: Thursday, July 14, 2011 8:07 AM
To: Jackie Burhans
Cc: Vinnie Smith
Subject: FW: Post

Morning Jackie,

I wrote this last night after reviewing all the messages to take a list of 
points out of them. Are you able to review it and see if you are okay with it 
or if there is anything you want added, changed or removed?

Thanks,
Dan

From: Dan McGrath 
[mailto:danmcg...@gmail.com]mailto:[mailto:danmcg...@gmail.com]
Sent: Thursday, July 14, 2011 12:27 AM
To: Daniel McGrath
Subject: Post

Hi all,

I have been reading all these posts, but I haven't had time to really respond 
until now.

First, let me introduce myself to those who don't know me already. I've just 
moved to Denver and started working as a Product Manager for U2 with Rocket 
Software. Prior to this I worked as a Systems Architect for a financial 
institute where we used UniData, UniVerse, *SQL, .NET, PHP, Windows  UNIX 
among other technologies. While I don't read Techmeme, I do read a lot of tech 
sites and I am somewhat active on QA sites (see my StackExchange profile: 
http://goo.gl/iLsPJ - Short link because the long one is UGLY). I've probably 
attended  10 conferences in the last year alone, including the World Computer 
Congress, so I do try to get out amongst what is happening in the industry as 
the whole.

There have been many valid points and issues raised in this discussion. At this 
point I think I should clarify: If you compare U2 to the feature list of all 
the other databases out there - aggregated - it would lose. Replace U2 with any 
database in the previous statement and it would also be true. Cherry-picking 
individual features from one database to compare them, then cherry-picking from 
completely different database when counter-points are raised is not exactly a 
technically sound (or fair) way to do comparisons.

Obviously, U2 will not cover EVERY use case. As was said earlier: Always...use 
the right tool, for the right job...one size doesn't fit all, etc., etc. 

Another point is that when comparing U2 to other mature technologies, such as 
MsSQL, don't compare it based on experiences with applications written on top 
of U2 from 1980. If you want to do that, please compare it to similar 
applications that where originally written for SQL-86. Not that I discredit 
those U2 apps. Not by a long shot - this is the first positive point I raise 
for U2 for why I would pick it.

1) Applications from 1980 are still healthily running today on the latest 
Linux, UNIX  Windows 7 systems and still with support. If I was investing a 
lot of money into an 'enterprise' system, I don't see why you would overlook 
that fact. You want to guarantee that you can keep your system running for the 
next 10, 20, 30 years, even if you don't have the money to re-architect in 
between; not many others give you that.

So, when comparing U2 applications, let us be real here. We are not exactly 
talking telnet anymore 
(http://www.rocketsoftware.com/u2/u2/products/datavu/resources/datasheets/datavu-datasheet.pdf).

So, if I was building an Enterprise grade solution that required 24/7 uptime, 
automatic data encryption, replication, ACID compliance I have some other 
interesting reasons to use U2.

2) You can modify your business logic and change your data schema(ta) all while 
your system is online with almost no impact. Due to how the tables are 
structured (essentially hash tables) modifying the schema can have no impact to 
as little impact as the overhead of written the extra data. It does not need to 
go an restructure the entire table to apply the change. Down time = money lost. 
People have come to expect 'maintenance windows'. I've worked with an Internet 
Banking system that had an SQL driven front-end that interfaced with a U2 
driven back-end. Changes required on the back-end? No problem, Bob's your uncle 
(or your dad, as per a person I met recently...) We only needed outages when 
changing something related to SQL.

Then comes performance, as others have mentioned before.

3) U2 allows you to denormalize the data until your denormalizing thirst has 
been quenched - while still being able to effectively handle it. Not that I am 
advocated being silly here. Following some basic rules you can 

Re: [U2] Why Pick U2?

2011-07-14 Thread Daniel McGrath
Ah, early morning. Obviously I missed some clean up... Sorry all 

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath
Sent: Thursday, July 14, 2011 9:04 AM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] Why Pick U2?



_
From: Jackie Burhans
Sent: Thursday, July 14, 2011 8:55 AM
To: Daniel McGrath; Dave Peters
Cc: Vinnie Smith
Subject: RE: Post


Very thorough response. Minor edits below in red. One suggested cut noted like 
this {xxx} One question--can you and Dave give some thoughts to conferences you 
might like to attend over the coming year. I'll talk with Susie about funding 
for that.

Jackie Burhans
Director, U2 Partner Enablement
Rocket Software
4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA
Tel: +1.720.475.8016 * Fax: +1.617.630.7392
Email: jburh...@rs.commailto:jburh...@rs.com
Web: www.rocketsoftware.com/u2http://www.rocketsoftware.com/u2

-Original Message-
From: Daniel McGrath
Sent: Thursday, July 14, 2011 8:07 AM
To: Jackie Burhans
Cc: Vinnie Smith
Subject: FW: Post

Morning Jackie,

I wrote this last night after reviewing all the messages to take a list of 
points out of them. Are you able to review it and see if you are okay with it 
or if there is anything you want added, changed or removed?

Thanks,
Dan

From: Dan McGrath 
[mailto:danmcg...@gmail.com]mailto:[mailto:danmcg...@gmail.com]
Sent: Thursday, July 14, 2011 12:27 AM
To: Daniel McGrath
Subject: Post

Hi all,

I have been reading all these posts, but I haven't had time to really respond 
until now.

First, let me introduce myself to those who don't know me already. I've just 
moved to Denver and started working as a Product Manager for U2 with Rocket 
Software. Prior to this I worked as a Systems Architect for a financial 
institute where we used UniData, UniVerse, *SQL, .NET, PHP, Windows  UNIX 
among other technologies. While I don't read Techmeme, I do read a lot of tech 
sites and I am somewhat active on QA sites (see my StackExchange profile: 
http://goo.gl/iLsPJ - Short link because the long one is UGLY). I've probably 
attended  10 conferences in the last year alone, including the World Computer 
Congress, so I do try to get out amongst what is happening in the industry as 
the whole.

There have been many valid points and issues raised in this discussion. At this 
point I think I should clarify: If you compare U2 to the feature list of all 
the other databases out there - aggregated - it would lose. Replace U2 with any 
database in the previous statement and it would also be true. Cherry-picking 
individual features from one database to compare them, then cherry-picking from 
completely different database when counter-points are raised is not exactly a 
technically sound (or fair) way to do comparisons.

Obviously, U2 will not cover EVERY use case. As was said earlier: Always...use 
the right tool, for the right job...one size doesn't fit all, etc., etc. 

Another point is that when comparing U2 to other mature technologies, such as 
MsSQL, don't compare it based on experiences with applications written on top 
of U2 from 1980. If you want to do that, please compare it to similar 
applications that where originally written for SQL-86. Not that I discredit 
those U2 apps. Not by a long shot - this is the first positive point I raise 
for U2 for why I would pick it.

1) Applications from 1980 are still healthily running today on the latest 
Linux, UNIX  Windows 7 systems and still with support. If I was investing a 
lot of money into an 'enterprise' system, I don't see why you would overlook 
that fact. You want to guarantee that you can keep your system running for the 
next 10, 20, 30 years, even if you don't have the money to re-architect in 
between; not many others give you that.

So, when comparing U2 applications, let us be real here. We are not exactly 
talking telnet anymore 
(http://www.rocketsoftware.com/u2/u2/products/datavu/resources/datasheets/datavu-datasheet.pdf).

So, if I was building an Enterprise grade solution that required 24/7 uptime, 
automatic data encryption, replication, ACID compliance I have some other 
interesting reasons to use U2.

2) You can modify your business logic and change your data schema(ta) all while 
your system is online with almost no impact. Due to how the tables are 
structured (essentially hash tables) modifying the schema can have no impact to 
as little impact as the overhead of written the extra data. It does not need to 
go an restructure the entire table to apply the change. Down time = money lost. 
People have come to expect 'maintenance windows'. I've worked with an Internet 
Banking system that had an SQL driven front-end that interfaced with a U2 
driven back-end. Changes required on the back-end? No problem, Bob's your uncle 
(or your dad, as per a person I met recently...) We only needed outages

Re: [U2] Why Pick U2?

2011-07-14 Thread Holt, Jake
If Rocket asked you what you want, what would you say

1. make the site publically available, stop hiding information and
ancillary tools (like whatever your new redback replacement is) behind
maintenance/registration.  Make these available publically
2. Offer a semi-crippled version of U2 that is usable in production
(size limit, connection marshaller, processor/memory limits, etc) for
free.
3 . Drop per-seat licensing
4. Change maintenance to support contracts and allow users to
patch/update within their current version.


-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel
McGrath
Sent: Thursday, July 14, 2011 10:04 AM
To: U2 Users List (u2-users@listserver.u2ug.org)
Subject: [U2] Why Pick U2?



_
From: Jackie Burhans
Sent: Thursday, July 14, 2011 8:55 AM
To: Daniel McGrath; Dave Peters
Cc: Vinnie Smith
Subject: RE: Post


Very thorough response. Minor edits below in red. One suggested cut
noted like this {xxx} One question--can you and Dave give some thoughts
to conferences you might like to attend over the coming year. I'll talk
with Susie about funding for that.

Jackie Burhans
Director, U2 Partner Enablement
Rocket Software
4600 S. Ulster Street **Suite 1100 **Denver, CO 80237 * USA
Tel: +1.720.475.8016 * Fax: +1.617.630.7392
Email: jburh...@rs.commailto:jburh...@rs.com
Web: www.rocketsoftware.com/u2http://www.rocketsoftware.com/u2

-Original Message-
From: Daniel McGrath
Sent: Thursday, July 14, 2011 8:07 AM
To: Jackie Burhans
Cc: Vinnie Smith
Subject: FW: Post

Morning Jackie,

I wrote this last night after reviewing all the messages to take a list
of points out of them. Are you able to review it and see if you are okay
with it or if there is anything you want added, changed or removed?

Thanks,
Dan

From: Dan McGrath
[mailto:danmcg...@gmail.com]mailto:[mailto:danmcg...@gmail.com]
Sent: Thursday, July 14, 2011 12:27 AM
To: Daniel McGrath
Subject: Post

Hi all,

I have been reading all these posts, but I haven't had time to really
respond until now.

First, let me introduce myself to those who don't know me already. I've
just moved to Denver and started working as a Product Manager for U2
with Rocket Software. Prior to this I worked as a Systems Architect for
a financial institute where we used UniData, UniVerse, *SQL, .NET, PHP,
Windows  UNIX among other technologies. While I don't read Techmeme, I
do read a lot of tech sites and I am somewhat active on QA sites (see
my StackExchange profile: http://goo.gl/iLsPJ - Short link because the
long one is UGLY). I've probably attended  10 conferences in the last
year alone, including the World Computer Congress, so I do try to get
out amongst what is happening in the industry as the whole.

There have been many valid points and issues raised in this discussion.
At this point I think I should clarify: If you compare U2 to the feature
list of all the other databases out there - aggregated - it would lose.
Replace U2 with any database in the previous statement and it would also
be true. Cherry-picking individual features from one database to compare
them, then cherry-picking from completely different database when
counter-points are raised is not exactly a technically sound (or fair)
way to do comparisons.

Obviously, U2 will not cover EVERY use case. As was said earlier:
Always...use the right tool, for the right job...one size doesn't fit
all, etc., etc. 

Another point is that when comparing U2 to other mature technologies,
such as MsSQL, don't compare it based on experiences with applications
written on top of U2 from 1980. If you want to do that, please compare
it to similar applications that where originally written for SQL-86. Not
that I discredit those U2 apps. Not by a long shot - this is the first
positive point I raise for U2 for why I would pick it.

1) Applications from 1980 are still healthily running today on the
latest Linux, UNIX  Windows 7 systems and still with support. If I was
investing a lot of money into an 'enterprise' system, I don't see why
you would overlook that fact. You want to guarantee that you can keep
your system running for the next 10, 20, 30 years, even if you don't
have the money to re-architect in between; not many others give you
that.

So, when comparing U2 applications, let us be real here. We are not
exactly talking telnet anymore
(http://www.rocketsoftware.com/u2/u2/products/datavu/resources/datasheet
s/datavu-datasheet.pdf).

So, if I was building an Enterprise grade solution that required 24/7
uptime, automatic data encryption, replication, ACID compliance I have
some other interesting reasons to use U2.

2) You can modify your business logic and change your data schema(ta)
all while your system is online with almost no impact. Due to how the
tables are structured (essentially hash tables) modifying the schema can
have no impact to as little impact as the overhead of written

Re: [U2] Why Pick U2?

2011-07-14 Thread Jacie Burhans

1. Do you mean U2DevZone? You should see an article on that next week in the
U2 News Flash--you are subscribed, right? If not, go to: http://goo.gl/G1uem
2. Please email us at u2as...@rs.com with more info on what you are thinking
of. We are doing some work in this area. Or you can post here. What would
you do with it?
3. And replace it with what? We are open to suggestions and actively looking
at other models but more in addition to rather than instead of
4. An interesting idea. I'll take it back to the team to discuss. A pretty
big change for us though.

Jackie Burhans
Rocket U2


Holt, Jake wrote:
 
 If Rocket asked you what you want, what would you say
 
 1. make the site publically available, stop hiding information and
 ancillary tools (like whatever your new redback replacement is) behind
 maintenance/registration.  Make these available publically
 2. Offer a semi-crippled version of U2 that is usable in production
 (size limit, connection marshaller, processor/memory limits, etc) for
 free.
 3 . Drop per-seat licensing
 4. Change maintenance to support contracts and allow users to
 patch/update within their current version.
 
 
 

-- 
View this message in context: 
http://old.nabble.com/Why-Pick-U2--tp32061959p32062398.html
Sent from the U2 - Users mailing list archive at Nabble.com.

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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Steve Romanow
Logging, unittesting,
On Jul 14, 2011 10:12 AM, Rob Sobers rsob...@gmail.com wrote:
 Yes, and my point is that in the U2/UniBasic ecosystem, those collections
of
 subroutines are not readily available anywhere.

 What if you want to use a web service that emits JSON? Is it going to take
 you 3 lines of code and 5 minutes to write a JSON parser? And what about
 serialization, compression, PDF generation? These things are useful and
not
 trivial to write and maintain.

 And what language features have been added to UniBasic lately? I can't
 think of any. No objects, no regular expressions, no lambdas, etc.

 -Rob

 On Thu, Jul 14, 2011 at 3:27 AM, Mecki Foerthmann mec...@gmx.net wrote:

 So what are libraries?
 They are nothing but a collection of subroutines that somebody else has
 written.
 And what do you do if you can't find a function in your library that does
 exactly what you need?
 You write your own, right?
 And by the time you have found the right function in your library you
could
 have written the 3 lines of code in Basic that do the same thing already.
 I write Databasic code every day and have done so for over 20 years and
 hardly ever have use for functions, because if I needed them I would have
 written my own library by.

 Mecki




 On 14/07/2011 02:25, Rob Sobers wrote:

 I have to heartily disagree that U2 has a sophisticated business rules
 engine. U2 Basic is such a limited language. It barely has functions,
 and
 you have to home brew almost everything.

 Microsoft's T-SQL stored procedures are just as horrible to write as U2
 Basic programs. As Jeff Atwood put it -- Stored procedures should be
 considered database assembly language. [1] Why do you think Microsoft
now
 allows you to call CLR code from stored procedures? Because it's so much
 more efficient to work with the data (i.e., enforce the business rules)
in
 a
 modern language like C# that has *actual libraries* for doing useful
 things.

 I agree that business rules shouldn't be on the client -- but who says
 they
 have to be in the database? Look at the ever-so-popular MVC
architecture.
 The models (i.e., the code that works with the database and enforces all
 of
 the business rules) are isolated from the views (i.e., the
 client/presentation code) entirely.

 -Rob

 [1]:
 http://www.codinghorror.com/**blog/2004/10/who-needs-stored-**
 procedures-anyways.html
http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html


 On Wed, Jul 13, 2011 at 7:29 PM, Kevin Kingprecisonl...@gmail.com
 wrote:

 +1 for what David said. Yes, there's the limitation that BASIC is the
 only native supported language (not factoring external connectors), but
 as
 a
 language native to the environment, this BASIC is really pretty rich by
 comparison to the stored procedure languages of other DBs.
 __**_
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/**mailman/listinfo/u2-users
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
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
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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Brian Leach
I've missed this discussion because I've been busy designing a website and
app for a client.

This being the real world, the site will eventually - of course - be
delivered using SQL Server and C#, with the front end using AJAX calls to
JSON services delivered through WCF. Which will no doubt take an age to
develop, test, deploy and then reconfigure all over all again.

So before getting to that stage, I've written a fully functioning prototype.
Which is - of course - written in UniVerse and mvScript. Which means I've
developed it all front to back in a few hours and it's robust and flexible
enough that I can work through it sitting with the clients tomorrow and make
changes in near real time as they come up with ideas. 

Which tells the story, in one, of what I do and don't like about U2.


As to some of the other points:

1. Someone mentioned SQL Server and the GUI word again. Please ... SQL
Server has no UI. If you're coding a UI for SQL server you use C#. If you're
coding a UI for U2 you can use C#. If you're coding business rules for SQL
Server you can use SQL Manager. If you're coding business rules for U2 you
can use BDT or mvDeveloper. It's a red herring.

2. The other thread has been talking about locking. If there's one reason to
use U2 over all else, it's pessimistic locking. The SQL world is full of
script kiddies and wizard users who *think* they know SQL and don't have the
first idea about concurrency, locking and merging.

3. Yes, we now have CLR in SQL server, but how many SQL developers are
actually using it? The initial push to add it was a horrible cludge and put
off many of those who might have experimented, and for the rest of the
community it's too alien. I think we'll see TSQL as the main language for
back end work for a long, long time - and that doesn't begin to measure up
to UniBasic. (but read on before you jump on this...)

4. Having middle tier logic may be the norm but that does not mean it a good
idea. It's the least worst response to a bad situation - not having business
logic close to the database. It's more to test, develop, deploy and change
control. And to be successful it still needs to call stored procedures at
the back end.

5. But if you really want a middle tier, you can still add one and use C#
and it's 'proper libraries' with U2. If you really, really want.

6. And either way, not having to stare at query optimizer output is a very
good reason to like U2.

BUT

That doesn't mean U2 can't be improved by taking on some of the better
features of the outside world. 

The indexing is still very primitive, the SQL support is weak, and it would
be great to have some other languages built into the database runtime. Even
java - shudder - would be better than nothing, and would provide those
'missing' OO and library features that people think they want.

Add OpenQM's version of objects into Basic while you're at it and make the
Basic on the two products more similar. It's just a pain having to use two
sets of syntax: Rocket could easily create a superset on both.

Nowadays you can at least integrate the query and Basic language by using
SQLExecute() function calls to @HSTMT - something that was always missing
from the original Pick model. But it's not obvious and doesn't work from
phantoms.

For the client side, we need javascript bindings made easy - especially to
JSON - as that is the most important language for new developers today. Look
at all the new development platforms like Titanium that are built on top of
it or that compile down from it. 

Just publishing the UniRPC protocol would be another good start, then
developers could write native binding in other socket-supporting languages.
Oh sorry - I've been asking for that for about a decade.

Linking to a distributed memory cache - like Oracle does with Coherence
(which it took as an open source product) - to give linear scalability and
failover. Temporary tables for workfiles, in memory and/or reserved per
session and cleared down on session end. Hint - per-session means no impact
on the lock table for concurrency or for extension.

And get rid of Eclipse. It's horrible.

And from the commercial angle - produce a version that get can entice people
into the product at the bottom level, with limits that will constrain it but
an upgrade path to the full version as the usage grows and the business
benefit becomes clear - like MS does with SQL Express. Allow developers to
redistribute it. And make it appealing for web development. Right now it's
not, whilst the charging model is still on a per-user and additional
connection pooling basis: that puts it out of scope for those zillions of
sites that need cheap lightweight data sourcing. 

My 2c.


Brian



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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Bill Brutzman
Brian

I tried a few times today and I am unable to get to the website there...

Oops! Google Chrome could not find www.brianleach.co.uk

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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Mecki Foerthmann


I don't even know what JSON is supposed to be good for, so why would I 
want to use a web service that emits it?

I don't have a need for a JSON parser, so why should I write one?
And what if I don't need serialization, compression and PDF generation?
Well, I have tools for generating PDFs, but why would I want to 
serialize or compress U2 data?
If I really needed to do things like that I would probably use java, C# 
or whatever language has been specifically developed for that purpose.

But for what I am doing day in day out Databasic does the job best for me.

You wouldn't use a hammer to drill a hole, would you?
Would you therefore call a hammer inferior to a drill?
Of course you may be able to drive a nail into a piece of wood with a 
drill, but I'd rather use the hammer.

Always use the right tool for the job at hand.


On 14/07/2011 15:11, Rob Sobers wrote:

Yes, and my point is that in the U2/UniBasic ecosystem, those collections of
subroutines are not readily available anywhere.

What if you want to use a web service that emits JSON?  Is it going to take
you 3 lines of code and 5 minutes to write a JSON parser?  And what about
serialization, compression, PDF generation?  These things are useful and not
trivial to write and maintain.

And what language features have been added to UniBasic lately?  I can't
think of any.  No objects, no regular expressions, no lambdas, etc.

-Rob

On Thu, Jul 14, 2011 at 3:27 AM, Mecki Foerthmannmec...@gmx.net  wrote:


So what are libraries?
They are nothing but a collection of subroutines that somebody else has
written.
And what do you do if you can't find a function in your library that does
exactly what you need?
You write your own, right?
And by the time you have found the right function in your library you could
have written the 3 lines of code in Basic that do the same thing already.
I write Databasic code every day and have done so for over 20 years and
hardly ever have use for functions, because if I needed them I would have
written my own library by.

Mecki




On 14/07/2011 02:25, Rob Sobers wrote:


I have to heartily disagree that U2 has a sophisticated business rules
engine.  U2 Basic is such a limited language.  It barely has functions,
and
you have to home brew almost everything.

Microsoft's T-SQL stored procedures are just as horrible to write as U2
Basic programs.  As Jeff Atwood put it -- Stored procedures should be
considered database assembly language. [1] Why do you think Microsoft now
allows you to call CLR code from stored procedures?  Because it's so much
more efficient to work with the data (i.e., enforce the business rules) in
a
modern language like C# that has *actual libraries* for doing useful
things.

I agree that business rules shouldn't be on the client -- but who says
they
have to be in the database?  Look at the ever-so-popular MVC architecture.
  The models (i.e., the code that works with the database and enforces all
of
the business rules) are isolated from the views (i.e., the
client/presentation code) entirely.

-Rob

[1]:
http://www.codinghorror.com/**blog/2004/10/who-needs-stored-**
procedures-anyways.htmlhttp://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html

On Wed, Jul 13, 2011 at 7:29 PM, Kevin Kingprecisonl...@gmail.com
  wrote:

  +1 for what David said.  Yes, there's the limitation that BASIC is the

only native supported language (not factoring external connectors), but
as
a
language native to the environment, this BASIC is really pretty rich by
comparison to the stored procedure languages of other DBs.
__**_
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users

  __**_

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


__**_
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Brian Leach
Bill

That's weird, it's up and I can see it (Chrome, FF, IE)

Looks crap, but that's the old cobblers shoes story .. one day I'll get time
to rewrite it.grin

Brian

-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: 14 July 2011 20:45
To: U2 Users List
Subject: Re: [U2] Why Pick U2 ?

Brian

I tried a few times today and I am unable to get to the website there...

Oops! Google Chrome could not find www.brianleach.co.uk

--Bill
___
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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread John Thompson
JSON is just another data exchange format like, csv, xml, etc.

The main advantage is that it is arguably better at passing name, valued
pairs of data (like Pick/MV in DataBASIC), than xml, etc.

It can also arguably make writing AJAX (i.e. FAST data entry web forms),
somewhat easier (with emphasis on the arguably of course), since most
Javascript libraries (i.e. client side subroutines for the web browser) work
so well with it.

So, as to why you need it?

It just depends on what you are trying to build.  Try and use the right tool
for the job as they say...

On Thu, Jul 14, 2011 at 4:01 PM, Mecki Foerthmann mec...@gmx.net wrote:


 I don't even know what JSON is supposed to be good for, so why would I want
 to use a web service that emits it?
 I don't have a need for a JSON parser, so why should I write one?
 And what if I don't need serialization, compression and PDF generation?
 Well, I have tools for generating PDFs, but why would I want to serialize
 or compress U2 data?
 If I really needed to do things like that I would probably use java, C# or
 whatever language has been specifically developed for that purpose.
 But for what I am doing day in day out Databasic does the job best for me.

 You wouldn't use a hammer to drill a hole, would you?
 Would you therefore call a hammer inferior to a drill?
 Of course you may be able to drive a nail into a piece of wood with a
 drill, but I'd rather use the hammer.
 Always use the right tool for the job at hand.



 On 14/07/2011 15:11, Rob Sobers wrote:

 Yes, and my point is that in the U2/UniBasic ecosystem, those collections
 of
 subroutines are not readily available anywhere.

 What if you want to use a web service that emits JSON?  Is it going to
 take
 you 3 lines of code and 5 minutes to write a JSON parser?  And what about
 serialization, compression, PDF generation?  These things are useful and
 not
 trivial to write and maintain.

 And what language features have been added to UniBasic lately?  I can't
 think of any.  No objects, no regular expressions, no lambdas, etc.

 -Rob

 On Thu, Jul 14, 2011 at 3:27 AM, Mecki Foerthmannmec...@gmx.net  wrote:

  So what are libraries?
 They are nothing but a collection of subroutines that somebody else has
 written.
 And what do you do if you can't find a function in your library that does
 exactly what you need?
 You write your own, right?
 And by the time you have found the right function in your library you
 could
 have written the 3 lines of code in Basic that do the same thing already.
 I write Databasic code every day and have done so for over 20 years and
 hardly ever have use for functions, because if I needed them I would have
 written my own library by.

 Mecki




 On 14/07/2011 02:25, Rob Sobers wrote:

  I have to heartily disagree that U2 has a sophisticated business rules
 engine.  U2 Basic is such a limited language.  It barely has functions,
 and
 you have to home brew almost everything.

 Microsoft's T-SQL stored procedures are just as horrible to write as U2
 Basic programs.  As Jeff Atwood put it -- Stored procedures should be
 considered database assembly language. [1] Why do you think Microsoft
 now
 allows you to call CLR code from stored procedures?  Because it's so
 much
 more efficient to work with the data (i.e., enforce the business rules)
 in
 a
 modern language like C# that has *actual libraries* for doing useful
 things.

 I agree that business rules shouldn't be on the client -- but who says
 they
 have to be in the database?  Look at the ever-so-popular MVC
 architecture.
  The models (i.e., the code that works with the database and enforces
 all
 of
 the business rules) are isolated from the views (i.e., the
 client/presentation code) entirely.

 -Rob

 [1]:
 http://www.codinghorror.com/blog/2004/10/who-needs-stored-http://www.codinghorror.com/**blog/2004/10/who-needs-stored-**
 procedures-anyways.htmlhttp:/**/www.codinghorror.com/blog/**
 2004/10/who-needs-stored-**procedures-anyways.htmlhttp://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html
 

 On Wed, Jul 13, 2011 at 7:29 PM, Kevin Kingprecisonl...@gmail.com
  wrote:

  +1 for what David said.  Yes, there's the limitation that BASIC is
 the

 only native supported language (not factoring external connectors), but
 as
 a
 language native to the environment, this BASIC is really pretty rich by
 comparison to the stored procedure languages of other DBs.
 ___
 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 http://listserver.u2ug.org/mailman/listinfo/u2-usershttp://listserver.u2ug.org/**mailman/listinfo/u2-users
 http**://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users
 

  ___

 U2-Users mailing list
 U2-Users@listserver.u2ug.org
 

Re: [U2] Why Pick U2 ?

2011-07-14 Thread Symeon Breen
Javascript inherently works with JSON regardless of any library used.

It is a fantastic serialisation of data that should be embraced in the MV
world. It fits very well in fact, it handles any level of array nesting so
can manage the 3 (or 4 inc @tm) levels of MV data, it is schemaless and
weakly typed and fairly compact, so a perfect fit for MV programmers and
data.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson
Sent: 14 July 2011 21:29
To: U2 Users List
Subject: Re: [U2] Why Pick U2 ?

JSON is just another data exchange format like, csv, xml, etc.

The main advantage is that it is arguably better at passing name, valued
pairs of data (like Pick/MV in DataBASIC), than xml, etc.

It can also arguably make writing AJAX (i.e. FAST data entry web forms),
somewhat easier (with emphasis on the arguably of course), since most
Javascript libraries (i.e. client side subroutines for the web browser) work
so well with it.

So, as to why you need it?

It just depends on what you are trying to build.  Try and use the right tool
for the job as they say...

On Thu, Jul 14, 2011 at 4:01 PM, Mecki Foerthmann mec...@gmx.net wrote:


 I don't even know what JSON is supposed to be good for, so why would I
want
 to use a web service that emits it?
 I don't have a need for a JSON parser, so why should I write one?
 And what if I don't need serialization, compression and PDF generation?
 Well, I have tools for generating PDFs, but why would I want to serialize
 or compress U2 data?
 If I really needed to do things like that I would probably use java, C# or
 whatever language has been specifically developed for that purpose.
 But for what I am doing day in day out Databasic does the job best for me.

 You wouldn't use a hammer to drill a hole, would you?
 Would you therefore call a hammer inferior to a drill?
 Of course you may be able to drive a nail into a piece of wood with a
 drill, but I'd rather use the hammer.
 Always use the right tool for the job at hand.



 On 14/07/2011 15:11, Rob Sobers wrote:

 Yes, and my point is that in the U2/UniBasic ecosystem, those collections
 of
 subroutines are not readily available anywhere.

 What if you want to use a web service that emits JSON?  Is it going to
 take
 you 3 lines of code and 5 minutes to write a JSON parser?  And what about
 serialization, compression, PDF generation?  These things are useful and
 not
 trivial to write and maintain.

 And what language features have been added to UniBasic lately?  I can't
 think of any.  No objects, no regular expressions, no lambdas, etc.

 -Rob

 On Thu, Jul 14, 2011 at 3:27 AM, Mecki Foerthmannmec...@gmx.net  wrote:

  So what are libraries?
 They are nothing but a collection of subroutines that somebody else has
 written.
 And what do you do if you can't find a function in your library that
does
 exactly what you need?
 You write your own, right?
 And by the time you have found the right function in your library you
 could
 have written the 3 lines of code in Basic that do the same thing
already.
 I write Databasic code every day and have done so for over 20 years and
 hardly ever have use for functions, because if I needed them I would
have
 written my own library by.

 Mecki




 On 14/07/2011 02:25, Rob Sobers wrote:

  I have to heartily disagree that U2 has a sophisticated business rules
 engine.  U2 Basic is such a limited language.  It barely has functions,
 and
 you have to home brew almost everything.

 Microsoft's T-SQL stored procedures are just as horrible to write as U2
 Basic programs.  As Jeff Atwood put it -- Stored procedures should be
 considered database assembly language. [1] Why do you think Microsoft
 now
 allows you to call CLR code from stored procedures?  Because it's so
 much
 more efficient to work with the data (i.e., enforce the business rules)
 in
 a
 modern language like C# that has *actual libraries* for doing useful
 things.

 I agree that business rules shouldn't be on the client -- but who says
 they
 have to be in the database?  Look at the ever-so-popular MVC
 architecture.
  The models (i.e., the code that works with the database and enforces
 all
 of
 the business rules) are isolated from the views (i.e., the
 client/presentation code) entirely.

 -Rob

 [1]:

http://www.codinghorror.com/blog/2004/10/who-needs-stored-http://ww
w.codinghorror.com/**blog/2004/10/who-needs-stored-**
 procedures-anyways.htmlhttp:/**/www.codinghorror.com/blog/**

2004/10/who-needs-stored-**procedures-anyways.htmlhttp://www.codinghorror.c
om/blog/2004/10/who-needs-stored-procedures-anyways.html
 

 On Wed, Jul 13, 2011 at 7:29 PM, Kevin Kingprecisonl...@gmail.com
  wrote:

  +1 for what David said.  Yes, there's the limitation that BASIC is
 the

 only native supported language (not factoring external connectors),
but
 as
 a
 language native to the environment, this BASIC is really pretty rich
by
 comparison

Re: [U2] Why Pick U2 ?

2011-07-14 Thread Charles_Shaffer
Symeon says

 Javascript inherently works with JSON regardless of any library used.

 It is a fantastic serialisation of data that should be embraced in the 
MV
 world. It fits very well in fact, it handles any level of array nesting 
so
 can manage the 3 (or 4 inc @tm) levels of MV data, it is schemaless and
 weakly typed and fairly compact, so a perfect fit for MV programmers 
and
 data.

Ijust wanted to voice my agreement with Symeon on this.  For me at least, 
a TO_JSON verb in UniBasic would be great.  Most of the programming I've 
done in the last few years has been web applications that use Javascript 
heavily.  I find XML cumbersome so I just rolled my own for data transfer 
from U2 to the browser.  JSON would be better.
 
Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why Pick U2?

2011-07-14 Thread John Thompson
I'm going to attempt to explain one scenario why the per seat licensing
won't win you any new customers...

Lets say, I'm a smaller company (or a bigger company for that matter), and
all I want to do is build my application for the web.
(I do not want to use terminal sessions for anything)
OR
I'm part of the younger crowd who has spent a lot of his/her time using
languages like C#, php, python, javascript, etc. etc.

Lets say I don't have the money to invest in WebDE, Redback, or whatever the
official Rocket ways of doing it are (and I probably got the names wrong).
A small disclaimer here is that, I do not know how the licensing for those
products work)

If I were Rocket U2, how would I market myself for that?

I can't see you or your resellers winning out, by saying...

Rocket Rep:
Well you need to buy user licenses based on how many website hits you think
you will have.
Each session that does some CRUD (creates, reads, updates, or deletes some
data) will require a license.
Now Mr./Mrs. User that session may stay persistent, or it may not, depending
on how you build your web application.
So lets, start with 10 users licenses...

Customer:
Ok, how many do you think that will support?

Rocket Rep:
Well, it could support up to 30 or more, it depends on what the user is
doing.
It will definitely support 10 concurrent sessions.

Customer:
So if 11 people all do some CRUD at once, then at least one of those
sessions would fail?

Rocket Rep:
Yes, you would need more licenses.

Customer:
So how much is each license?

Rocket Rep:
$XXX per user

Customer:
What if my site gets a 1,000 hits a day?

Rocket Rep:
Then you should probably start with 250 users.

Customer:
$XXX * 250 = Thats a lot of money for a database and one programming
language
-

All I'm saying is, if you want to spread the U2 gospel to a younger group
of techs/developers, and at the same time grab new customers that need web
applications (and not terminal applications), then you will have a hard
time competing.

In the above case, you just need to sell per processor core on the server,
OR
one flat fee, plus yearly support

You might even have different levels of support for smaller customers.
1) Email only
2) 8 to 5 phone support
3) 24/7 phone support

I know some of this is also done through your resellers too.

I think you have to come up with something, if you want to see a significant
growth in new U2 users/customers.

You might even just have a version that only allows 5 telnet/ssh logins, and
everything else is from your Universal Language Connector  (oh what a
dream! - but that idea is for another posting)



On Thu, Jul 14, 2011 at 12:03 PM, Jacie Burhans jackie.burh...@usa.netwrote:


 1. Do you mean U2DevZone? You should see an article on that next week in
 the
 U2 News Flash--you are subscribed, right? If not, go to:
 http://goo.gl/G1uem
 2. Please email us at u2as...@rs.com with more info on what you are
 thinking
 of. We are doing some work in this area. Or you can post here. What would
 you do with it?
 3. And replace it with what? We are open to suggestions and actively
 looking
 at other models but more in addition to rather than instead of
 4. An interesting idea. I'll take it back to the team to discuss. A pretty
 big change for us though.

 Jackie Burhans
 Rocket U2


 Holt, Jake wrote:
 
  If Rocket asked you what you want, what would you say
 
  1. make the site publically available, stop hiding information and
  ancillary tools (like whatever your new redback replacement is) behind
  maintenance/registration.  Make these available publically
  2. Offer a semi-crippled version of U2 that is usable in production
  (size limit, connection marshaller, processor/memory limits, etc) for
  free.
  3 . Drop per-seat licensing
  4. Change maintenance to support contracts and allow users to
  patch/update within their current version.
 
 
 

 --
 View this message in context:
 http://old.nabble.com/Why-Pick-U2--tp32061959p32062398.html
 Sent from the U2 - Users mailing list archive at Nabble.com.

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




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


Re: [U2] Why Pick U2?

2011-07-14 Thread Holt, Jake

1. Do you mean U2DevZone? You should see an article on that next week in
the
U2 News Flash--you are subscribed, right? If not, go to:
http://goo.gl/G1uem 
**

I mean products like DataVu, Web DE and VisualStudio add ins.  At least
offer scaled down solutions for public use (like the watered down
version of Reporting Services Microsoft gives away with SS Express 08
r2).  These are the products that attract users 'cause let's face it,
not many people get excited about dictionaries now-a-days.  

Anything related to connectivity shouldn't be sold separately, to me in
this day and age,  connectivity is one of the defining factors in what
makes a database.  

2. Please email us at u2as...@rs.com with more info on what you are
thinking of. We are doing some work in this area. Or you can post here.
What would you do with it?

**
I have a number of small applications that are currently using a SS 2008
express r2 database and probably could for the next 15 years and not run
into the limits imposed by the express version.  I would wager there is
a lot of applications out there like this.Wouldn't it be beneficial
to have a watered down version available that a least give people the
option of using U2?  I would think that having people on a free version
of U2 would be of more benefit to you then  people using SQL server
express, postgresql, etc. 

3. And replace it with what? We are open to suggestions and actively
looking at other models but more in addition to rather than instead
of

There has to be a reasonable middle ground and some options.  We
purchased UniVerse in 95 so I'm not sure where the prices are currently,
but there are like 8 different versions of SQL server --  All of varying
costs and limitations.  Having the per proc and CAL (which are more
flexible then seats) options helps as well.  I can buy a single proc web
only license for like $4k.  I can serve A LOT of requests with a single
proc web only database license.



-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacie Burhans
Sent: Thursday, July 14, 2011 11:04 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Why Pick U2?


1. Do you mean U2DevZone? You should see an article on that next week in
the
U2 News Flash--you are subscribed, right? If not, go to:
http://goo.gl/G1uem 2. Please email us at u2as...@rs.com with more info
on what you are thinking of. We are doing some work in this area. Or you
can post here. What would you do with it?
3. And replace it with what? We are open to suggestions and actively
looking at other models but more in addition to rather than instead
of
4. An interesting idea. I'll take it back to the team to discuss. A
pretty big change for us though.

Jackie Burhans
Rocket U2


Holt, Jake wrote:
 
 If Rocket asked you what you want, what would you say
 
 1. make the site publically available, stop hiding information and 
 ancillary tools (like whatever your new redback replacement is) behind

 maintenance/registration.  Make these available publically 2. Offer a 
 semi-crippled version of U2 that is usable in production (size limit, 
 connection marshaller, processor/memory limits, etc) for free.
 3 . Drop per-seat licensing
 4. Change maintenance to support contracts and allow users to 
 patch/update within their current version.
 
 
 

--
View this message in context:
http://old.nabble.com/Why-Pick-U2--tp32061959p32062398.html
Sent from the U2 - Users mailing list archive at Nabble.com.

___
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


Re: [U2] Why Pick U2?

2011-07-14 Thread David Jordan
I  developed a new application in U2 and I sell it.  I am not a dinosaur.   
What has been raised is technical comparisons, but if you are developing 
software to sell you need to think commercial advantages.  For instances, I 
never sell to IT, I sell to business decision makers, technology means nothing 
to them, they want results and they want delivery within budget and within time 
frames.  No one asks me what database I run on. You compete first on cost and 
second on functionality and thirdly they want reliability.   This is where U2 
shines for a new developer.

1.  I never fear that I will not meet cost and time targets, I don't have 
surprises that delay projects.
2.  Cost of Development,  I can achieve with 2 programmers in half the time 
what my competitors require 10+ programmers to do
3.  Support:  I sell a package and rarely go back to the site for years as it 
is self-maintaining.   Their IT rarely have to do anything with it.
4. Functionality, I can do complex business functionality that my competitors 
struggle with despite their modern programming languages and tools.
5. I can put a lot of fat into my quote and still undercut my competitors.
6. Code transports through technology changes.  If I had written something 15 
years ago in c++, VB for windows, I would have had to rewrite it several times 
to handle the evolution of windows technologies.   That is expensive.

The advantage of U2 is the KISS principal.  Use the right technologies for the 
right job.  For instances front ends, use .Net, Java, etc.

U2 Basic is a business programmers language, not a computer science programmers 
language.  It is good for people who are writing business rules as it is quick 
and simple to write and easy to read and debug.  I have written complex 
business logic that would have been difficult to manage in c#.

Sure there are many things that need to be improved in U2, but to think other 
technologies are perfect is a bit of the grass is greener on the other side.  I 
have worked with many databases and technologies over the years and have seen 
what looks good to start with often hits brick walls as you start to get 
serious with the technology and then there are massive costs to jump those 
brick walls.

I am winning with U2 and that's why I use it as do many others on this list.

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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Doug Averch
Hi Brian:

Microsoft now has a plug-in for Eclipse see
http://msdn.microsoft.com/en-us/library/gg413285.aspx.  Eclipse just
released version 3.7 around June 22nd and they have had a million plus
downloads.  They released 62 projects with over 46 million lines of code
see http://www.eclipse.org/org/press-release/20110622indigo.php.

Eclipse is one of the premier IDE's out in the world.  Do want to teach
people to use ED/AE to create files, edit dictionaries, and edit code all in
that pretty wrapper called Telnet?  Or do you want to show them a MS based
editor that only does that?  Sorry, your free product does not cut the
mustard here.

We need to teach the young people coming into U2 world to use the finest
tool that allows continuous compiling, templates, outlines, bookmarks,
version control, copying and pasting data, listing files, and searching all
within a single IDE to name just a few functions.  Whether the Eclipse IDE
is from U2logic or Rocket Software there is no other tools on the market
that can compare feature to feature.

We know you can do all of the above with wrappers, amazing VOC items, and
scripts, but we must have time warped back to 1990's because we don't really
need to explain these to a newbie.  Those newbie's think we are just a bunch
of old men and old women.  We know we are the best so lets look like with
our state of the art tools.

Regards,
Doug
www.u2logic.com
Version control for the rest of us using Eclipse


 
  And get rid of Eclipse. It's horrible.
 

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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Steve Romanow
When i look at an eclipse application I see 80% ui that is not relevant to
the task at hand.  I agree that it and most every app implemented with it
are trash.
On Jul 14, 2011 6:11 PM, Doug Averch dave...@gmail.com wrote:
 Hi Brian:

 Microsoft now has a plug-in for Eclipse see
 http://msdn.microsoft.com/en-us/library/gg413285.aspx. Eclipse just
 released version 3.7 around June 22nd and they have had a million plus
 downloads. They released 62 projects with over 46 million lines of code
 see http://www.eclipse.org/org/press-release/20110622indigo.php.

 Eclipse is one of the premier IDE's out in the world. Do want to teach
 people to use ED/AE to create files, edit dictionaries, and edit code all
in
 that pretty wrapper called Telnet? Or do you want to show them a MS based
 editor that only does that? Sorry, your free product does not cut the
 mustard here.

 We need to teach the young people coming into U2 world to use the finest
 tool that allows continuous compiling, templates, outlines, bookmarks,
 version control, copying and pasting data, listing files, and searching
all
 within a single IDE to name just a few functions. Whether the Eclipse IDE
 is from U2logic or Rocket Software there is no other tools on the market
 that can compare feature to feature.

 We know you can do all of the above with wrappers, amazing VOC items, and
 scripts, but we must have time warped back to 1990's because we don't
really
 need to explain these to a newbie. Those newbie's think we are just a
bunch
 of old men and old women. We know we are the best so lets look like with
 our state of the art tools.

 Regards,
 Doug
 www.u2logic.com
 Version control for the rest of us using Eclipse


 
  And get rid of Eclipse. It's horrible.
 

 ___
 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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Bill Haskett

Yea...and wouldn't it be nice of the TO.DELIM keyword in UniQuery worked!

Bill


- Original Message -
*From:* charles_shaf...@ntn-bower.com
*To:* U2 Users List u2-users@listserver.u2ug.org
*Date:* 7/14/2011 2:18 PM
*Subject:* Re: [U2] Why Pick U2 ?

Symeon says


Javascript inherently works with JSON regardless of any library used.
It is a fantastic serialisation of data that should be embraced in the MV
world. It fits very well in fact, it handles any level of array nesting so
can manage the 3 (or 4 inc @tm) levels of MV data, it is schemaless and
weakly typed and fairly compact, so a perfect fit for MV programmers and
data.

Ijust wanted to voice my agreement with Symeon on this.  For me at least,
a TO_JSON verb in UniBasic would be great.  Most of the programming I've
done in the last few years has been web applications that use Javascript
heavily.  I find XML cumbersome so I just rolled my own for data transfer
from U2 to the browser.  JSON would be better.

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
___
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


Re: [U2] Why Pick U2 ?

2011-07-14 Thread Tony Gravagno
David, what you're touching on here is one of the fundamental
differences between MV and relational: We use BASIC within the
engine to manage Referential Integrity (RI) and provide business
rules.  Simultaneously, our RI is contained in the business
rules, not at the DBMS level.  They use other languages outside
the engine for rules, and they rely on the DBMS to maintain RI.

As much as I'd like to climb on the pro-MV bandwagon on the
preferred methodology, I have to say that neither is right or
wrong, better or worse, they're just different methodologies,
equally qualified, equally falable.

The problem with MV is that we have not adapted to that other
common methodology.  Language bindings into the MV environment
need to come through a rather cludgy socket interface or other
mechanisms, where interfaces to other environments are
seemingly much more direct and elegant.  When we can advertise
that the rules can comfortably sit at any tier, then we will have
something to brag about.  We're almost there.  Right now, I am
comfortable with the practice of putting minimal validation
outside of the environment, but (despite the ability to have all
rules outside the environment) I choose to keep all real rules in
BASIC on the server.  It seems many people in this community
still think it needs to be entirely one way or the other.  This
seems to be a new mantra of mine here, but the problem isn't so
much with the technology, but how people think it should be used.

T


 From: David Jordan
 One thing that all the other database lack is that U2 
 has a sophisticated business rules engine.   The SQL 
 bastardise language in other databases is a nightmare 
 compared to unibasic.When everyone is talking 
 APIs, they are mostly talking about the presentation 
 layer.  Presentation layer interface to other 
 databases is better than U2, but U2 is better for 
 storing business logic in the database.   I am seeing 
 too many applications being developed out their that 
 are breaking the rules of client server where the 
 business logic is in the client.  Too many tools use 
 the database as a simple data repository and require 
 business rules to be built into the client.

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


Re: [U2] Why Pick U2 ?

2011-07-13 Thread Bill Brutzman
In the old days (when men were men) there were computer scientists and 
engineers who would analyze technologies and make design decisions... sometimes 
choosing one technology over another.  In those days, computers were a lot 
slower.  MulitValue always had tremendous speed advantages and was chosen by 
experts who were designing things like MRP (Material Requirements Planning) 
systems that had to handle a lot of complex data or say do complex calculations.

These days, a lot of talented computer scientists and engineers realize that 
MultiValue still has a lot to offer.  Design decisions for MultiValue now seems 
to have more to do with total costs.  When comparing U2 to Oracle or Microsoft 
SQL, U2 wins.  When comparing U2 to MySQL, U2 still wins.   Microsoft's Azure 
SQL is something of a new animal with a new costing model.  Will U2 win?

--Bill

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake
Sent: Wednesday, July 13, 2011 10:44 AM
To: U2 Users List
Subject: Re: [U2] Interesting Article

I'm not sure being cheaper than Oracle can really be touted as an advantage, 
there aren't many things out there that are more expensive than oracle =D.  And 
all of those things you just mentioned are also true of many FREE databases, so 
again, why pick U2?

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


Re: [U2] Why Pick U2 ?

2011-07-13 Thread Rob Sobers
When comparing U2 to Oracle or Microsoft SQL, U2 wins.  When comparing U2
to MySQL, U2 still wins.

That's a pretty blanket statement with no supporting reasoning.

-Rob

On Wed, Jul 13, 2011 at 12:34 PM, Bill Brutzman bi...@hkmetalcraft.comwrote:

 In the old days (when men were men) there were computer scientists and
 engineers who would analyze technologies and make design decisions...
 sometimes choosing one technology over another.  In those days, computers
 were a lot slower.  MulitValue always had tremendous speed advantages and
 was chosen by experts who were designing things like MRP (Material
 Requirements Planning) systems that had to handle a lot of complex data or
 say do complex calculations.

 These days, a lot of talented computer scientists and engineers realize
 that MultiValue still has a lot to offer.  Design decisions for MultiValue
 now seems to have more to do with total costs.  When comparing U2 to Oracle
 or Microsoft SQL, U2 wins.  When comparing U2 to MySQL, U2 still wins.
 Microsoft's Azure SQL is something of a new animal with a new costing model.
  Will U2 win?

 --Bill

 -Original Message-
 From: u2-users-boun...@listserver.u2ug.org [mailto:
 u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake
 Sent: Wednesday, July 13, 2011 10:44 AM
 To: U2 Users List
 Subject: Re: [U2] Interesting Article

 I'm not sure being cheaper than Oracle can really be touted as an
 advantage, there aren't many things out there that are more expensive than
 oracle =D.  And all of those things you just mentioned are also true of many
 FREE databases, so again, why pick U2?

 ___
 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


Re: [U2] Why Pick U2 ?

2011-07-13 Thread Kevin King
I'm a fan of U2 - MV in general even.  But in this case I have to agree with
Rob: We really need to quantify what it means to win otherwise the words
do little more than tickle an emotional response.

Having had some time with several MV systems as well as several SQL systems,
there are areas of each that in a head-to-head comparison, one would win
over the other based on price, performance, flexibility, scalability, and
reliability.  And it's not always U2/MV and it's not always SQL.  For
getting right to work without extensive tuning, I'd say U2 holds the upper
hand.  In terms of indexing and application of multiple indexes to queries,
I'd put PostgreSQL over MySQL and both over U2.  For clustering, Oracle.
 For the GUI, SQL Server.  For that matter, I'd rank the flexibility of
triggers in Unidata over triggers in Universe, and they're both MV.  So it's
a complex task to assign a winner carte blanche without looking deeply
into the eyes of specific areas of the products and their applicability to
specific problems to be solved.

My personal opinion is that there are benefits to all of it.  So in that way
picking a winner really doesn't do much more than polarize.  I know if I
were creating an application from scratch today, the criteria I might use to
make the decision would be different from anyone else making the same
decision even if it were the same application.  There is better and there
is worse but all of it must be considered in the larger context of the
problem to be solved to mean anything at all.

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


Re: [U2] Why Pick U2 ?

2011-07-13 Thread Bill Brutzman
Let's focus on costs for a moment.   While of course MySQL is widely 
available... businesses that are seriously using MySQL generally buy 
maintenance for the year.  While I suppose that, pricewise,  MySQL support 
rather reasonable, it is also not free... and I suppose is approx. the same 
price as U2 maintenance.

There other support costs to consider.  A lot of shops have say a programmer 
and a DBA.  When these shops find that there are comparable companies doing  U2 
who have one guy who is both the programmer and the DBA... they wonder...  That 
then is (some of) the supporting reasoning.

--Bill

-Original Message-

Sent: Wednesday, July 13, 2011 1:06 PM
Subject: Re: [U2] Why Pick U2 ?

When comparing U2 to Oracle or Microsoft SQL, U2 wins.  When comparing U2 to 
MySQL, U2 still wins.

That's a pretty blanket statement with no supporting reasoning.

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


Re: [U2] Why Pick U2 ?

2011-07-13 Thread Rob Sobers
I don't think the flavor of DB is a great indicator of whether you need a
dedicated DBA role.  Scale of deployment is probably a far better indicator.

If we're talking about personnel costs -- have you ever been able to hire a
college freshman for $20 bucks an hour who already has 2 years of U2 under
his belt from building WordPress sites?  The point being that there is much
more qualified MySQL and SQL Server talent available than U2 talent.

Also, DBs like MySQL are battle tested.  You'll rarely find a core bug in
MySQL if you're using a stable version.  Why?  Because hundreds of thousands
of developers are using it and thus finding the bugs (likely) before they
hit you.  When I was working with U2 every day, we consistently found and
were affected by core bugs.  Costly ones, too.

-Rob

On Wed, Jul 13, 2011 at 1:43 PM, Bill Brutzman bi...@hkmetalcraft.comwrote:

 Let's focus on costs for a moment.   While of course MySQL is widely
 available... businesses that are seriously using MySQL generally buy
 maintenance for the year.  While I suppose that, pricewise,  MySQL support
 rather reasonable, it is also not free... and I suppose is approx. the
 same price as U2 maintenance.

 There other support costs to consider.  A lot of shops have say a
 programmer and a DBA.  When these shops find that there are comparable
 companies doing  U2 who have one guy who is both the programmer and the
 DBA... they wonder...  That then is (some of) the supporting reasoning.

 --Bill

 -Original Message-

 Sent: Wednesday, July 13, 2011 1:06 PM
 Subject: Re: [U2] Why Pick U2 ?

 When comparing U2 to Oracle or Microsoft SQL, U2 wins.  When comparing U2
 to MySQL, U2 still wins.

 That's a pretty blanket statement with no supporting reasoning.

 ___
 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


Re: [U2] Why Pick U2 ?

2011-07-13 Thread David Jordan
One thing that all the other database lack is that U2 has a sophisticated 
business rules engine.   The SQL bastardise language in other databases is a 
nightmare compared to unibasic.When everyone is talking APIs, they are 
mostly talking about the presentation layer.  Presentation layer interface to 
other databases is better than U2, but U2 is better for storing business logic 
in the database.   I am seeing too many applications being developed out their 
that are breaking the rules of client server where the business logic is in the 
client.  Too many tools use the database as a simple data repository and 
require business rules to be built into the client.   

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


Re: [U2] Why Pick U2 ?

2011-07-13 Thread Kevin King
+1 for what David said.  Yes, there's the limitation that BASIC is the
only native supported language (not factoring external connectors), but as a
language native to the environment, this BASIC is really pretty rich by
comparison to the stored procedure languages of other DBs.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Why Pick U2 ?

2011-07-13 Thread Rob Sobers
I have to heartily disagree that U2 has a sophisticated business rules
engine.  U2 Basic is such a limited language.  It barely has functions, and
you have to home brew almost everything.

Microsoft's T-SQL stored procedures are just as horrible to write as U2
Basic programs.  As Jeff Atwood put it -- Stored procedures should be
considered database assembly language. [1] Why do you think Microsoft now
allows you to call CLR code from stored procedures?  Because it's so much
more efficient to work with the data (i.e., enforce the business rules) in a
modern language like C# that has *actual libraries* for doing useful things.

I agree that business rules shouldn't be on the client -- but who says they
have to be in the database?  Look at the ever-so-popular MVC architecture.
 The models (i.e., the code that works with the database and enforces all of
the business rules) are isolated from the views (i.e., the
client/presentation code) entirely.

-Rob

[1]:
http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html

On Wed, Jul 13, 2011 at 7:29 PM, Kevin King precisonl...@gmail.com wrote:

 +1 for what David said.  Yes, there's the limitation that BASIC is the
 only native supported language (not factoring external connectors), but as
 a
 language native to the environment, this BASIC is really pretty rich by
 comparison to the stored procedure languages of other DBs.
 ___
 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