leigh@cache.DEC (Allen Leigh @SHR1-3/E29 DTN 237-3255) (12/27/84)
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