From - Sun Oct 05 20:45:13 1997 Return-Path: Received: from punt-1.mail.demon.net by mailstore for rleyton@dogbert.demon.co.uk id 876047866:14:18684:1; Sun, 05 Oct 97 11:37:46 BST Received: from mail.acm.org ([199.222.69.4]) by punt-1.mail.demon.net id aa1418672; 5 Oct 97 11:37 BST Received: from brookes.ac.uk (csmail.brookes.ac.uk [161.73.1.1]) by mail.acm.org (8.8.5/8.7.5) with ESMTP id GAA122446 for ; Sun, 5 Oct 1997 06:42:01 -0400 From: majordomo@brookes.ac.uk Received: by brookes.ac.uk (8.8.7/SMI-SVR4) id LAA22051; Sun, 5 Oct 1997 11:37:37 +0100 (BST) Date: Sun, 5 Oct 1997 11:37:37 +0100 (BST) Message-Id: <199710051037.LAA22051@brookes.ac.uk> To: rleyton@acm.org Subject: Majordomo file: list 'leap' file 'leap.9702' Reply-To: majordomo@brookes.ac.uk X-Mozilla-Status: 2001 -- >From leap-owner Fri Feb 14 11:58:04 1997 Received: by brookes.ac.uk (8.8.4/SMI-SVR4) id LAA14303; Fri, 14 Feb 1997 11:55:46 GMT Message-Id: <33045281.6BC5@acm.org> Date: Fri, 14 Feb 1997 12:54:41 +0100 From: Richard Leyton Organization: AMS Management Systems X-Mailer: Mozilla 3.01 (X11; I; HP-UX B.10.20 9000/889) Mime-Version: 1.0 To: leap@brookes.ac.uk Cc: richard_leyton@mail.amsinc.com Subject: leap list: Final Beta Released today. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-leap@brookes.ac.uk Precedence: bulk Reply-To: leap@brookes.ac.uk Dear all, I'm pleased to be able to inform you that I have just completed uploading the latest version of LEAP to the various ftp sites. Please allow a day or two for the files to be placed by system administrators. If you'd like me to send you a uuencoded version, or upload to a specific ftp site, drop me a note at my normal e-mail address. Version 0.12 will be the very last beta version. The next version will be Version 1.0, and will only contain bug fixes and a different version number(!) from 0.12 New functionality/fixes includes: o Combination of variables/system settings o Configuration file withing which system settings can be changed. o Output format of relations can be defined as automatic, tabulated, or fixed length o Join/product now allow name padding to be enabled. This adds the relation name to *all* attributes in resulting relations. Previously it only occured when a duplicate tuple was added. o Natural join has been extensively debugged. o DB Change crash fix has been included(!) o Delete Relation functionality o Environment variable LEAP_DIR is read for LEAP directory if set. In addition: o The documentation has been rewritten to cover the Unix version. The old (DOS 0.10) documentation is included as an ASCII file. o Databases have been cleaned up of "debris" left over from my tests. o There is a new database "model" which can be used to create new databases. Changes you should be aware of: o Command line parameter definition for LEAP directory has been modified. Now specify -d directory, rather than simply a directory. o Natural join works two ways, ie. regardless of the order in which the relations are specified. The Windows version will be released in the next few days. Thankyou for your ongoing support and feedback. Hopefully you'll all find something in this that you wanted, or hoped for. The next release will be 1.0 - A release that has been two years in the making!!! I'm now at a cross roads, and your suggestions for new functionality to LEAP are more important now than they have ever been before. So please drop me a line. Thanks, and I look forward to hearing from you soon, Regards, Richard. -- Richard Leyton, AMS Management Systems Deutschland GmbH mailto:rleyton@acm.org http://www.brookes.ac.uk/~e0190404/home.html Opinions are my own, and not representative of AMS. >From leap-owner Fri Feb 14 13:05:05 1997 Received: by brookes.ac.uk (8.8.4/SMI-SVR4) id NAA24119; Fri, 14 Feb 1997 13:03:59 GMT Message-Id: <33046252.46A@acm.org> Date: Fri, 14 Feb 1997 14:02:10 +0100 From: Richard Leyton Organization: AMS Management Systems X-Mailer: Mozilla 3.01 (X11; I; HP-UX B.10.20 9000/889) Mime-Version: 1.0 To: leap@brookes.ac.uk Cc: richard_leyton@mail.amsinc.com Subject: leap list: FTP Sites Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-leap@brookes.ac.uk Precedence: bulk Reply-To: leap@brookes.ac.uk To download 0.12, the following URL's can be used immediately: ftp://sunsite.unc.edu/pub/Linux/Incoming/leap-0.12.tar.gz (and all mirrors as the update is distributed) ftp://ftp.demon.co.uk/pub/compsci/databases (Allow one or two days for the files to be relocated) In due course, the following will be valid: ftp://sunsite.unc.edu/pub/Linux/apps/databases/leap-0.12.tar.gz ftp://tsx.mit.edu/pub/linux/sources/usr.bin/leap-0.12.tar.gz ftp://ftp.demon.co.uk/pub/compsci/databases/leap-0.12.tar.gz Check out: http://ftpsearch.ntnu.no/ftpsearch For a WWW interface to a global archie server, and search on leap-0.12.tar.gz Regards, Richard. -- Richard Leyton, AMS Management Systems Deutschland GmbH mailto:rleyton@acm.org http://www.brookes.ac.uk/~e0190404/home.html Opinions are my own, and not representative of AMS. >From leap-owner Tue Feb 18 17:28:32 1997 Received: by brookes.ac.uk (8.8.4/SMI-SVR4) id RAA22165; Tue, 18 Feb 1997 17:26:34 GMT Message-Id: <3309E61F.476F@mail.amsinc.com> Date: Tue, 18 Feb 1997 18:25:51 +0100 From: Richard Leyton Organization: AMS Management Systems Deutschland GmbH X-Mailer: Mozilla 3.01Gold (WinNT; I) Mime-Version: 1.0 Newsgroups: comp.databases.theory,comp.databases,comp.edu,comp.lang.c Cc: rleyton@acm.org, leap@brookes.ac.uk Subject: leap list: ANNOUNCE: Release of LEAP RDBMS Final Beta Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-leap@brookes.ac.uk Precedence: bulk Reply-To: leap@brookes.ac.uk Dear all, This is to inform you that the final beta release (0.12) of LEAP has been made to various FTP sites. LEAP is a freely available (GNU) relational database management system that is increasingly being used in a wide variety of environments. Principally it is used as a learning tool to help in the understanding of relational databases. More recently it is being used as a prototyping tool, a research tool, and a light weight back end database engine. Full 'C' source code is included. At the heart of LEAP is the relational algebra in it's true form, and examples from various database books (including C.J.Date) are included. LEAP is distributed under the terms of the GNU General public license, and includes full C source code. LEAP is known to work on a multitude of platforms, including: Linux, Solaris, SunOS, Ultrix, HP-UX, Next, Windows (95/NT/3.1) - 16bit. To download this, download from the following URL's: ftp://ftp.demon.co.uk/pub/compsci/databases/leap-0.12.tar.gz (permanent) ftp://sunsite.unc.edu/pub/Linux/Incoming/leap-0.12.tar.gz (temporary) ftp://sunsite.unc.edu/pub/Linux/apps/databases/leap-0.12.tar.gz (permanent)* ftp://tsx.mit.edu/pub/linux/sources/usr.bin/leap-0.12.tar.gz (permanent)* * - Binary is currently awaiting positioning by ftp administrators. See the following URL for the above links, and more information: http://www.brookes.ac.uk/~e0190404/leap.html There is a mailing list for LEAP, which can be subscribed to by sending a one line e-mail to majordomo@brookes.ac.uk with one line in the body of the message reading "subscribe leap". For the initiated, here is a brief summary of the new functionality in 0.12. See the LEAP Web page for an exhaustive list of all LEAP functionality: o Combination of variables/system settings o Configuration file withing which system settings can be changed. o Output format of relations can be defined as automatic, tabulated, or fixed length o Join/product now allow name padding to be enabled. This adds the relation name to all attributes in resulting relations. Previously it only occured when a duplicate tuple was added. o Natural join has been extensively debugged. o DB Change crash fix (See below) has been included(!) o Delete Relation functionality o Environment variable LEAP_DIR is read for LEAP directory if set. o The documentation has been rewritten to cover the Unix version. The old (DOS 0.10) documentation is included as an ASCII file. Regards, Richard Leyton. -- Richard Leyton AMS Management Systems Deutschland GmbH mailto: rleyton@acm.org Opinions are my own, and not representative of AMS. >From leap-owner Wed Feb 19 17:38:44 1997 Received: by brookes.ac.uk (8.8.4/SMI-SVR4) id RAA11377; Wed, 19 Feb 1997 17:37:42 GMT Message-Id: <330B3A15.FB1@acm.org> Date: Wed, 19 Feb 1997 18:36:21 +0100 From: Richard Leyton Organization: AMS Management Systems X-Mailer: Mozilla 3.01 (X11; I; HP-UX B.10.20 9000/889) Mime-Version: 1.0 To: leap@brookes.ac.uk Subject: leap list: Fix Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-leap@brookes.ac.uk Precedence: bulk Reply-To: leap@brookes.ac.uk Dear all, A few things have become apparant since releasing 0.12, and here is a set of diffs to fix them. First - The file leap.c contains a #ifdef that some compilers don't like. You can remove this manually (line 344), or use the attached diff. Secondly - Timing option is pretty damn inaccurate. With the second patch, to parser.c - You can have accurate timing (11 decimal places) at last. This is a one line change to a printf which does some type casting and floating number output. Only the first item is likely to cause you headaches. The second is a "nice-to-have" more than anything else. Oh, and don't worry about the long command regression test failing. It's not supposed to, but it does. I know about it, and it will be fixed in the "proper" release. Regards, Richard. PS. The program "patch" is best used to apply these changes if you're confused. PPS. In order to prevent formatting getting upset, I have uuencoded the file, which is compressed. Apply the patch in the src directory. begin 640 leap121.diff.gz M'XL("(0W"S,"`VQE87`Q,C$N9&EF9@#-4F&+VD`0_9S[%7-7"HF::-3K5<5" MZWE0*E0\RWUH2UCC1)?F=L/NJCU*_WMG$M-Z/2CT2VD(9/=EWMN9MZ_1:$`A MC$43I=X=KN$&5Q`/('XYY/>2UH.KLS`,(8K:].8HBK`3Q=VV-6G[)W.YPXH9 M0[<[[/>(7#$;CQ_>0[_;:_6[`R@!`,_S"B.5R_R+F=[(5.2P0+&V0X#GZT]J MOGVPIR!C=T8ZY(+CP]A%J]+RE$X,E29Y)=:"&BB.2B5R(`F'*A@1Z^S\M(FE MO$,,];U?3_+M7`!JG7BZ&\0UHAUPK@*"]J3V?O)N]MD/ETDM]-)I5RV MY+03^:.FFN/?NAP]J:R[_55:(Z/R/FH7:1W^OR[FI:9?.Q>>&/8/_>+4<7*? M9OQJV(G_G/$C[Z\2WNO'K5[_195P%BZ!RY/+$F:3AF$YQ7>>NPG/9+;&##JT M]-H-N$/8BCU"872*UE+7(L]!9^"V"+IP4BL;P9(VN;`.#-X+J:3:,!T:QPJ0 MMJPOA-N"TS";OIZ#OV,UVJT0KM\NQB`5S(7E<.S1!$%0)^E=811/*JKB3A(YL/I6G$+G<108RUZ4X&GH^7BP_3 6H,IE&>UD2]%"X].Q/P"CU];:/`4``!8& ` end -- Richard Leyton, AMS Management Systems Deutschland GmbH mailto:rleyton@acm.org http://www.brookes.ac.uk/~e0190404/home.html Opinions are my own, and not representative of AMS. >From leap-owner Thu Feb 20 11:03:42 1997 Received: by brookes.ac.uk (8.8.4/SMI-SVR4) id LAA08538; Thu, 20 Feb 1997 11:02:12 GMT Message-Id: <330C2EE0.1F46@acm.org> Date: Thu, 20 Feb 1997 12:00:48 +0100 From: Richard Leyton Organization: AMS Management Systems X-Mailer: Mozilla 3.01 (X11; I; HP-UX B.10.20 9000/889) Mime-Version: 1.0 To: leap@brookes.ac.uk Subject: leap list: Getting previous messages Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-leap@brookes.ac.uk Precedence: bulk Reply-To: leap@brookes.ac.uk If you want to retrieve a file from the mailing list archive, send a mail to: majordomo@brookes.ac.uk - With no subject with the line: get leap leap.yymm You can include multiple commands, so you can download multiple files. To get an index of the files, send the line: index leap There is currently no way to download a copy of LEAP from the mailing list (I'm not the list owner, who is the only person who can do this), but you can get the previous messages that have been sent over the last 6 months, which might be of interest to the newer subscribers. Regards, Richard. -- Richard Leyton, AMS Management Systems Deutschland GmbH mailto:rleyton@acm.org http://www.brookes.ac.uk/~e0190404/leap.html Opinions are my own, and not representative of AMS. >From leap-owner Fri Feb 21 18:51:14 1997 Received: by brookes.ac.uk (8.8.4/SMI-SVR4) id SAA26310; Fri, 21 Feb 1997 18:50:26 GMT Message-Id: <330DD65A.DD5@acm.org> Date: Fri, 21 Feb 1997 18:08:36 +0100 From: Richard Leyton Organization: AMS Management Systems X-Mailer: Mozilla 3.01 (X11; I; HP-UX B.10.20 9000/889) Mime-Version: 1.0 To: leap@brookes.ac.uk Subject: leap list: FTP sites are now correct Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-leap@brookes.ac.uk Precedence: bulk Reply-To: leap@brookes.ac.uk Just a quicky to inform you that all of the primary ftp sites I mentioned in my earlier e-mail on ftp sites have relocated the binary accordingly. The LEAP web page has links to the main sites, and a new sub-page with links to the majority of ftp sites mirroring Sunsite/tsx in most countries. Have a nice weekend, Richard. -- Richard Leyton, AMS Management Systems Deutschland GmbH mailto:rleyton@acm.org http://www.brookes.ac.uk/~e0190404/leap.html Opinions are my own, and not representative of AMS. >From leap-owner Tue Feb 25 13:09:35 1997 Received: by brookes.ac.uk (8.8.4/SMI-SVR4) id NAA22626; Tue, 25 Feb 1997 13:06:46 GMT Message-Id: <3312E39B.7FB4@acm.org> Date: Tue, 25 Feb 1997 14:05:31 +0100 From: Richard Leyton Organization: AMS Management Systems X-Mailer: Mozilla 3.01 (X11; I; HP-UX B.10.20 9000/889) Mime-Version: 1.0 To: leap@brookes.ac.uk Cc: rleyton@acm.org Subject: leap list: Request Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Sender: owner-leap@brookes.ac.uk Precedence: bulk Reply-To: leap@brookes.ac.uk I'm in the process of putting some finishing touches to version 1.0 of LEAP, and I'd like to ask for your feedback before commiting LEAP to a it's first ever, non-beta, "real" release! Please send me feedback either directly to this list, or to rleyton@acm.org - Be careful of replying to this e-mail, as it defaults to replying to the entire list! If you have downloaded 0.12 (The final beta version) (if not, why not! :-) ), is there anything you have noticed that you think could be improved? Is there anything that *should* be included, that could be included - More documentation, perhaps? A section that is missing from the manual? Is there anything you don't think should be included? FYI I'm already stripping down the startup/shutdown messages to make it a little "quieter". I'm looking to releasing version 1.0 sometime in the first week or two of March. There will be very little difference between 0.12 and 1.0 (as you'd expect) - The only difference so far is the changes I posted here last week, and handling of signals (SIGINT and SIGTERM) to improve stability. Finally, I'd like to ask anybody who is using LEAP as a teaching tool, in a research capacity, as a development tool, in fact in any capacity at all, to let me know to what use you are putting it. Many of you already have informed me of the work you're doing, for which I am very grateful, but if you find LEAP of use, your establishments name will go a long way to help promote LEAP. A student, researcher or lecturer/teacher might be more inclined to try out LEAP if they see it being used actively elsewhere, and the more places/companies, the better. As always, I will only include your establishments name if you give me explicit permission to do so, and will assume you have permission to give me permission (Some establishments may not permit such promotion, even for non-profit, GPL purposes). The reason for this, is that I am putting together the usenet announcement that I will be posting to a large number of groups, which will get the widest audience of any LEAP announcements yet, so I want to make this the best yet (rather than the "0.12 is available" type announcements of the past). I am also revising (again) the LEAP home page. Thanks again for *all* your support, feedback and help, and I look forward to hearing from you soon, Regards, Richard. -- Richard Leyton, AMS Management Systems Deutschland GmbH mailto:rleyton@acm.org http://www.brookes.ac.uk/~e0190404/home.html Opinions are my own, and not representative of AMS.