[ale] On Databases...

[Terry Lee Tucker]

I for one am very interested in this subject. My company currently uses 
a transportation application written in a proprietary 4GL for the 
X-Windows platform. The database product and 4GL is made by a company 
called Progress. They have a good database product but dropped support 
for X-Windows a long time ago. In addition, the license fees are killing 
us. We have been busy writing on own native X-Windows interface and we 
will be looking at switching databases very soon. We hope to find 
something in the GPL realm that will meet our needs. Here's what we must 
have:

1.    Rollback recovery.
2.    Database side triggers. Quite a bit of the business logic is 
presently enforced in database triggers written in Progress. We would 
still want to be able to have that logic where it is albeit in a 
different language.
3.    It must me relatively fast but there would only be about a hundred 
connections to the database at any given time.
4.    We must have an API to our interface code (written in C).

Anybody have any input on what GPL type products would fit the bill for 
us? Of course, this would need to run on Linux.

Thanks...

Charles Marcus wrote:

>>From: Jeff Hubbs [mailto:hbbs at attbi.com]
>>Sent: Wednesday, July 10, 2002 1:12 AM
>>
>
><snip>
>
>>I don't just want a code jockey; I want someone that
>>groks DBMSses in the general case - and I don't mean
>>someone who JUST knows Oracle or JUST knows DB2, but
>>rather someone who can basically study and work with
>>ANY of those and pick among them for the best effect
>>(i.e., PostGreSQL if it'll do the job, and something
>>else if it won't
>>:-) )
>>
>
>Hmmm...
>
>Is there *anything* that you can't do in PostgreSQL that you can in another
>RDBMS?
>
>;)
>
>Charles
>
>
>---
>This message has been sent through the ALE general discussion list.
>See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
>sent to listmaster at ale dot org.
>

-- 
Sparta, NC 28675 USA
336.372.6812
http://www.esc1.com

The way I see it, David is Linux and Goliath is Micro$oft...




---
This message has been sent through the ALE general discussion list.
See http://www.ale.org/mailing-lists.shtml for more info. Problems should be 
sent to listmaster at ale dot org.