OpenEuphoria

Re: Relational Database

• Posted by Derek Parnell <ddparnell at bigpond.com> Jun 29, 2003
• 472 views

----- Original Message -----
From: "jondolar" <lavigne.s at videotron.ca>
To: "EUforum" <EUforum at topica.com>
Subject: Relational Database


>
>
> Hi everyones
>
> I'm new to Euphoria and particularly interested in the database part of
> the language. My question is: is it possible to use Euphoria database
> capabilities in a relational fashion such as a header table (master
> table) link to a line items table (child table)joined by a key field?
>

The database system supplied by Rapid Deployment Systems (RDS) is not a part
of the language, but it does demonstrate how verstile the language is. EDS
(the DB) is written entirely in Euphoria, and provides very low-level
database functionality. It does not implement indexes other than each table
has one, and only one, single-key (though not single-field) index. There is
no schema (meta- or otherwise) built into the database. In other words, each
application usually hard-codes the meaning of the fields and how they relate
to each other.

You would need to use one of the libraries that are add-ons to EDS that
support relational and other standard database functionality. Check the User
Contributions section of the RDS website for the various offerings.

--
Derek