OpenEuphoria

Re: DBMS library in Euphoria

• Posted by Steve Mosher <goat at DEVIL.ISN.NET> Feb 25, 2000
• 394 views

Personally, I would write a lib for an existing RDBMS server.
PostGreSQL would be my choice, but it isn't the most popular. If I were going
to write the routines that actually manipulate the data, I'd write an XBase
lib. The reason being that these things are already in wide use, adding support
for popular things will make your lib more widely useful, and in genereal
better.
        There are a few ways to do this. There's many (free) libs like the
already written in C and Perl. I'd do the 'call C routine' thing and you won't
have to do much work =), just write a Euphoria wrapper.
        That's my (condensed) thoughts. I'd write more, but it's all theory and
babble and irrelevant and has lots of run-on sentances =P.

On Fri, 25 Feb 2000, you wrote:
> 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