1. Relational Database
- Posted by jondolar <lavigne.s at videotron.ca> Jun 29, 2003
- 479 views
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?
2. Re: Relational Database
- Posted by Derek Parnell <ddparnell at bigpond.com> Jun 29, 2003
- 473 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