[comp.sys.atari.st] Databases

sshurr@wellesley.edu.UUCP (03/01/87)

Has anyone out there used GRID from TDI?  This is a relational database
engine from ETH in Zurich, and supposedly allows one to write Modula-2
programs to access a database.  Information about any similar packages
would also be appreciated.  I'm looking for a package that will allow me
to write my own C or Modula-2 programs to read text files and put them
into a database, to edit the contents of the database, to create reports
from the contents of the database, etc.

Scott Shurr - Academic Computing   | internet: sshurr@wellesley.edu
Science Center, Wellesley College  | phone: 617-235-0320 X3262
Wellesley, MA 02181                |

krieg@jupiter.uucp (Andrew Krieg) (10/11/89)

Are there any database packages for the ST that allow you to access the
database through C programs (like Btrieve, etc. for the PC's)?  I would like
to use an SQL database if possible.  The only SQL db for the ST that I have
heard of is RegentBase.  Does it provide these C 'hooks' that I need?  Or is
this a lost cause for ST development?


=========================================================================
=									=
=	The Atari Addict				A. Krieg	=
=									=
=		G.E. Medical Systems - CT - New Berlin, WI		=
= 	   	     USENET: krieg@jupiter.med.ge.com			=
=									=
=========================================================================

ron@argus.UUCP (Ron DeBlock) (10/11/89)

In article <1179@mrsvr.UUCP> krieg@jupiter.uucp (Andrew Krieg) writes:
>Are there any database packages for the ST that allow you to access the
>database through C programs (like Btrieve, etc. for the PC's)?  I would like
>to use an SQL database if possible.  The only SQL db for the ST that I have
>heard of is RegentBase.  Does it provide these C 'hooks' that I need?  Or is
>this a lost cause for ST development?
>=									=
>=	The Atari Addict				A. Krieg	=

Regent (the RegentBase folks) sell the SQL Add On for GFA Basic.  You can
access it from C - I've done it.  It is a memory hog - about 400K.  Also,
it is nowhere near full SQL.  It works, tho, and it's cheap.  I bought my
copy from E. Arthur Brown for $25.  It is supposed to be compatible with
RegentBase files, but I can't comment on that since I don't have RegentBase.

I'm not sure that posting works properly from this machine - let me know
if this gets through.

I'll upload a sample C program later, if this posting makes it.

-- 
Ron DeBlock	N2JSO
...!rutgers!galaxy!argus
ron@wilbur.njit.edu

krieg@jupiter.uucp (Andrew Krieg) (10/12/89)

I tried to email this to you but that didn't work.  Oh, well.


To: ron@wilbur.njit.edu
Subject: Re: Databases
News-Path: mrsvr.UUCP!uwm.edu!rutgers!galaxy.rutgers.edu!argus!ron
References: <1179@mrsvr.UUCP> <1307@argus.UUCP>

Your message got through fine.  I'd really like to see the C code, but I
don't think it will be necessary to post it in the open forum.  You could
just email it to me.  

This programmers add-on does not require RegentBase?  Do you mean it offers
just a rudimentary set of tools.  Do these tools allow you to create a
database, or do you need RegentBase to do this?  For $25 I wouldn't expect
too much, but what do I know? 8^)

Andrew Krieg

ron@argus.UUCP (Ron DeBlock) (10/13/89)

In article <1203@mrsvr.UUCP> krieg@jupiter.uucp (Andrew Krieg) writes:
>
>Your message got through fine.  I'd really like to see the C code, but I
>don't think it will be necessary to post it in the open forum.  You could
>just email it to me.  
>

I'll post the code, it's not long.   It's got a few hacks in it they others
may find interesting.  Note that I use Mark Williams C.  The code is 
probably not directly portable as it depends on the order in which parameters
are passed.  You'll need to check on such things before using any other
compiler, but you should have no trouble.

>This programmers add-on does not require RegentBase?  Do you mean it offers
>just a rudimentary set of tools.  Do these tools allow you to create a
>database, or do you need RegentBase to do this?  For $25 I wouldn't expect
>too much, but what do I know? 8^)
>
>Andrew Krieg

RegentBase is NOT required.  Tool basically gives you one function by
which you pass SQL statements and get back results.  You can create
tables and do queries, including the various types of joins.   SELECTs
which return multiple rows do not behave in the usual manner.

Like you said, don't expect much.  But for $25, it's a good hack.
-- 
Ron DeBlock	N2JSO
...!rutgers!galaxy!argus
ron@wilbur.njit.edu

dm@pnet01.cts.com (Dan Melson) (10/13/89)

This is a repeated question.  I'm in the market for a database, and having no
experience with them, would appreciate the views of the net on them.  The more
specific and detailed, the better, of course.
 
I originally posted this about five days ago, and got exactly five responses,
three of which were 'could you let me know, too'.  At this point, replies via
either e-mail or public means are more than welcome.  Those of you who
maintained silence for fear of deluging the recipient are hereby invited to
attempt it.  I'll summarize the e-mail responses I get. 
 
                                                DM

andyc@hplsla.HP.COM (Andy Cassino) (10/14/89)

|This is a repeated question.  I'm in the market for a database, and having no
|experience with them, would appreciate the views of the net on them.  The more
|specific and detailed, the better, of course.
| 
|I originally posted this about five days ago, and got exactly five responses,
|three of which were 'could you let me know, too'.  At this point, replies via
|----------

Okay, okay! I refrained from answering because I just don't have that much
experience with data bases. But I did buy Base2 by Antic a few months ago for
my simple-minded home database needs, for which it works just fine. 

Strengths: GEM-based, uncomplicated, very easy to set-up the database 
records and reports, even if you only use it occasionally. Fast, since the
whole database is loaded into RAM.  The database record can be modified 
even after entries have been made. Overall - fun to use.

Weaknesses: The size of the database is limited to the amount of available
RAM you have, minus accessories, TSRs, caches, RAMdisks, desk managers, etc.
For my uses on my Mega2, this will never be a problem. Biggest concern 
for me is that the database is not compatible with any of the standard big 
database programs, in case I ever want to upgrade to one.

Other: A friend that tried Base2 was not happy with report formatting, tried
DBman III (I think) and found it way too complicated, decided to roll his own.

Hope this helps.

Disclaimer: The opinions expressed herein are those solely
of the author, who has no pecuniary interest in the companies mentioned.

Copyright (c) 1989 by Andrew Cassino.  All rights reserved.

    %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
    % Andy Cassino                                                  %
    % uucp: hplabs!hplsla!andyc  domain: andyc%hplsla@hplabs.hp.com %
    % Hewlett-Packard              Lake Stevens Instrument Division %
    % 8600 Soper Hill Road                   Everett, WA 98205-1298 %
    % (206) 335-2211                                                %
    %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%

krs@stag.UUCP (Kent Schumacher) (10/16/89)

[dm@pnet01.cts.com (Dan Melson) writes...]
> This is a repeated question.  I'm in the market for a database, and having no
> experience with them, would appreciate the views of the net on them.  The more
> specific and detailed, the better, of course.
>  
> I originally posted this about five days ago, and got exactly five responses,
> three of which were 'could you let me know, too'.  At this point, replies via
> either e-mail or public means are more than welcome.  Those of you who
> maintained silence for fear of deluging the recipient are hereby invited to
> attempt it.  I'll summarize the e-mail responses I get. 
>  
>                                                 DM

The most powerful data-base manager is DbMan.  Along with that go ridiculous
amounts of disk usage and access, the most pathetic user interface I've ever
seen on an ST (it's almost as bad as most PC based applications), and a
small number of bugs - some fatal - all work-aroundable.

DbMan is usable if you have a hard-drive, at least one meg of memory,
Turbo ST 1.6, and have used a PC extensively, or alternatively
you periodically hit your head against hard objects.

The only reason to buy it, is that it offers the most power to the user
of all the data-bases I have any experience with.  Try before you buy.
(Also read a magazine review and get a look at the manual). I paid
$150.00 for the thing.


  - Kent Schumacher                  /* "A member of STdNET-         */
    ardvar!krs@stag.UUCP             /*  The ST developers network  */