Message-ID: <76@decwrl.UUCP>
Date: Thu, 27-Dec-84 10:03:10 EST
Article-I.D.: decwrl.76
Posted: Thu Dec 27 10:03:10 1984
Date-Received: Sat, 29-Dec-84 05:35:05 EST
Sender: daemon@decwrl.UUCP
Organization: DEC Engineering Network
Lines: 96

I have a relational database manager for the Atari which I am
making available via public domain, although I have it copyrighted
to avoid any commercial use of the software.  It is written in
Atari BASIC and consists of subroutines which can be included in the
source of BASIC application programs.

The manager is called RDBMS/AT and provides the following functions:

1.  A standalone builder program written in Atari BASIC to build the
    database.  You can have as many fields in each relation as you want,
    and the length of each field can be as long as you want.  The fields
    can be either REAL or CHARACTER values.  You can also have as many
    separate relations as you want.

2.  Six subroutines that can be included in the source of application
    programs.  These routines provide a "user view" of the database.

    Obtain ADEF Table.  The ADEF (A DEFinition) table is used by the
    standalone program to build the database.  Your application program uses
    this subroutine to learn the characteristics of the database.

    Get a New Record with Default Values.  Your application program uses
    this subroutine to obtain a new record from the database manager.  The
    fields in the record contain default values as specified by the ADEF
    table.  Your program places new values in the fields.

    Insert a Record into the Database.  Your application program uses this
    subroutine to request that the manager place the record in the specified
    relation.

    Select a Record from the Database.  Your application program uses this
    subroutine to obtain a record from the specified relation.

    Update a Record in the Database.  Your application program uses this
    subroutine to change values in a record in the specified relation.  The
    manager obtains the record from the database, updates the values, and
    returns the record to the database.

    Delete a Record from the Database.  Your application program uses this
    subroutine to remove a record from the specified relation.

3.  Various routines to support the linked lists that comprise the database
    and perform the disk I/O.  These routines provide a "physical view" of
    the database.

If you would like a copy of RDBMS/AT, send me a formatted diskette and a SASE.
Diskettes sent without the SASE will be considered gifts.

Note:  at the present time, I only have it available on 1050 DOS 3 diskettes.
I have no way to get it into DOS 2 diskettes.  If you have a utility to convert
DOS 3 files to DOS 2, please put it on your DOS 2 diskette and include a note
to me about it.  As soon as I have the ability to provide DOS 2 diskettes, I
will inform everyone via the net.

The DOS 3 diskette contains the following files:

1.  BLDRDBMS.V1  The builder program

2.  RDBMS1.V1    A template for an application program that contains the proper
                 interface for RDBMS/AT.

3.  RDBMS2.V1    The subroutines comprising the "user view".

4.  RDBMS3.V1    The subroutines comprising the "physical view".

5.  RDBMS0.DOC thru RDBMS5.DOC   The users manual, formatted by Atariwriter
                                 for the Gemini 10X printer.  The manual
                                 contains 25 double spaced pages.

6.  HANDLERS.SYS  The Atariwriter driver for the Gemini 10X.

The source code contains many comments to help you understand the code.
The comments do not have BASIC line numbers and are thus thrown away when the
code is loaded into memory.

This version of RDBMS/AT should be thought of as a prototype version to gain
functionality.  I've made no attempt to optimize the program in any way.  As a
result, the program takes up 15,683 bytes in memory leaving only 10,185 bytes
for your application program.  However, I feel it is a very useful tool and can
be the basis of some powerful application programs.

People who obtain RDBMS/AT are welcome and encouraged to modify and expand the
code and to convert it to other languages. There are only two restrictions that
I impose.  First, that your version contain an edit history containing the 
author's name and version number of EACH proceeding version back to my original
version which is V1.0.  This edit history must be in both the users manual and
each source file.  I feel that all persons involved with public domain programs
should be given credit for their work.  Second, that NO versions of RDBMS/AT
be used in ANY way for commercial purposes.  Public domain programs should 
remain free for all to use and enjoy.  

My address is Allen W. Leigh
              93 Shirley St. RFD 2
              Pepperell, MA 01463

...decwrl!rhea!cache!leigh