OpenEuphoria

DBMS library in Euphoria

• Posted by Lewis Townsend <keroltarr at HOTMAIL.COM> Feb 25, 2000
• 576 views

Hello All,

    Because of the recent discussion, I am considdering
writing a DBMS lib and contributing it to the archive.
However, I need to know what features would be required
to be useful to others before I decide whether or not I'm
up to the challenge.
    First of all this lib would not have a user interface
(at least at first), but just consist of a bunch of routines
to do the following:

Create tables
    create a table file *.TBL
    identify the fields, their data type, and size
Create relationships
    relationships between tables (1:n)
    identifying primary and foreign keys.
    inforce referential integrity
Modify tables
    Add or delete or change fields
Data entry and deletion
    Add, delete, or change records
Data retreival
  search for records
  retrieve contents of fields in a record
  possibly query generation features

I only have a vague idea of what I want to do:
  The table files (and any others needed) would be
in my own format, basically random access files.
I am unsure what format the routines' input should be in:
  a script language or separate arguments for routines.

Please comment on whether or not a lib like this is needed
and the features that would be necesary and/or preferred.
I'll then decide if I can and want to do it.
I need to know if the gratification of providing a needed
tool to the community outways the trouble of creating it.
:)

later,
Lewis Townsend
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com