Board index » delphi » About CA-Ingress Open Sourced.

About CA-Ingress Open Sourced.


2004-09-30 10:34:49 PM
delphi47
Hi,
By searching articles about PostGreSqland Firebird.
I discovered(With some delay) that Ca had open sourced Ingres.
Is it really free like PostGreSql and Firebird or a Gotcha like MySql.?
It must be a mature product.
Does anybody have links and opinions to share about this subject.
How to acess it using Delphi(I guess Ado).
Regards,
Marcello
 
 

Re:About CA-Ingress Open Sourced.

"Marcello Dias" <XXXX@XXXXX.COM>writes:
Hi,
I forgot to ask.
Is Ingres as easy to administrate.
I mean Although I think Oracle to be a much better broduct than Sql Server,Sql Server is easier to administrate and takes less time to learn.
Marcello
 

Re:About CA-Ingress Open Sourced.

Quote
Is it really free like PostGreSql and Firebird or a Gotcha like MySql.?
No idea...
Quote
It must be a mature product.
Last time I used Ingres was 7 years ago under HP-UX, at that time
it was already "mature", as in "granny" ;)
AFAIR it was pitted as a 'big' entreprise DB at the time, but fared
poorly against Oracle or even DB2, I reckon the open-sourcing is more
an abandonware move.
The PostgreSQL people have an interest in Ingres because both have
the same father and roots, but this was long ago and the branches
probably have no more code in common. However, scouting the PostgreSQL
forums and newsgroups might be the best place to obtain information
& opinions.
Quote
How to acess it using Delphi(I guess Ado).
It supports at least ODBC and JDBC.
If CA manage to stir interest, it may get more, but IMHO the existing
open-source databases have somewhat cornered the market: MySQL at the
low-end with fast access but {*word*99}py transactions, Firebird for desktop/small
server with robust transactions, and PostgreSQL moving to higher-end
DB-with-tuning segment (eyes on Oracle's territory).
Ingres has a head-start in parallel and cluster systems though,
with multicore becoming mainstream in the next year, it probably
has a few aces up its sleeves.
Eric
 

Re:About CA-Ingress Open Sourced.

Eric Grange <XXXX@XXXXX.COM>writes:
Quote
>I reckon the open-sourcing is more
an abandonware move.
I think it is in the hand of CA to prove it is not abandonware.
If they release a version full of new features even without the help of volunteers it will atract the open souce community.
You now many `open source` products are basically runned by huge companies like IBM,SUN and Novell they're free for me and poor people like me but these companies will make a lot of money with corporate customers.
I'll keep an eye on Ingres.
Regards,
Marcello Dias
 

Re:About CA-Ingress Open Sourced.

You should check out Postgresql, it has great delphi support and is far
superior to Firebird.
I have never used Ingres, but it shares roots with Postgres.
Check out www.zeoslib.net, I have been using the components with
great success in production programs.
"Eric Grange" <XXXX@XXXXX.COM>writes
Quote
>Is it really free like PostGreSql and Firebird or a Gotcha like MySql.?

No idea...

>It must be a mature product.

Last time I used Ingres was 7 years ago under HP-UX, at that time
it was already "mature", as in "granny" ;)
AFAIR it was pitted as a 'big' entreprise DB at the time, but fared
poorly against Oracle or even DB2, I reckon the open-sourcing is more
an abandonware move.
The PostgreSQL people have an interest in Ingres because both have
the same father and roots, but this was long ago and the branches
probably have no more code in common. However, scouting the PostgreSQL
forums and newsgroups might be the best place to obtain information
& opinions.

>How to acess it using Delphi(I guess Ado).

It supports at least ODBC and JDBC.

If CA manage to stir interest, it may get more, but IMHO the existing
open-source databases have somewhat cornered the market: MySQL at the
low-end with fast access but {*word*99}py transactions, Firebird for
desktop/small
server with robust transactions, and PostgreSQL moving to higher-end
DB-with-tuning segment (eyes on Oracle's territory).
Ingres has a head-start in parallel and cluster systems though,
with multicore becoming mainstream in the next year, it probably
has a few aces up its sleeves.

Eric
 

Re:About CA-Ingress Open Sourced.

Marcello Dias <XXXX@XXXXX.COM>wrote in article
<415c1989$XXXX@XXXXX.COM>...
Quote

Hi,

By searching articles about PostGreSqland Firebird.
I discovered(With some delay) that Ca had open sourced Ingres.

Does anybody have links and opinions to share about this subject.

I'm using Ingres at the mo. in work on a HP Unix box from Delphi 7. The
core systems administrator is a huge Ingres fanboy and always going on how
wonderful it is. Me - I am not so convinced.
Just to give you one of many examples, I ran a query against the live
system which contained a group by clause (via ODBC/BDE). In a moment of
distraction (I was specifying group by by index, i.e. group by 1,2) and I
included a count(*) field by accident. The Ingres server core dumped and
went down - live core database down = panic.
We thought this was a fluke so I was asked to repeat it on the contigency
box - the same thing happened.
D.
--
The supplied email address is a spam trap. I am a bit backwards but you can
contact me at eiDOTtenitATzad.
 

Re:About CA-Ingress Open Sourced.

Quote
You should check out Postgresql, it has great delphi support and is far
superior to Firebird.
Superior? in which ways? I have been using IB and FB for a long time
and never found anything so stable and easy to maintain, specially FB.
 

Re:About CA-Ingress Open Sourced.

Quote
You should check out Postgresql, it has great delphi support and is far
superior to Firebird.
How easy is it to distribute, install and maintain on Windows?
 

Re:About CA-Ingress Open Sourced.

Quote
You should check out Postgresql, it has great delphi support and is far
superior to Firebird.
Currently evalutating, current results for Postgresql vs FireBird:
- has more DB tuning options, which also to eventually get higher
performance, but on default parameters, it isn't so good
- better SQL support, but seems to {*word*88} on some 'joins' queries
if you don't tweak them (not sure exactly why or how, sometimes
inverting a join test clause is enough to get the speed back up,
I assume it is a minor bug in the beta)
- filestructure is made of multiple files (good for administration,
not good for ease of use/deployment and stability on "desktop servers")
- no native access Delphi components (that won't require a DLL)
Right now I trust FireBird to run unattended for years on a server
(we have several installs like that), but not just yet for PostgreSQL... ;)
On the other hand if you have some DB administration time to spare,
PostgreSQL looks to hove more potential (but in that case, it will often
not be pitted against FireBird, but against Oracle).
Eric
 

Re:About CA-Ingress Open Sourced.

Quote
[...] The Ingres server core dumped and went down
- live core database down = panic.
o_O ouch.
At least no data got corrupted? (but were there inserts/updates
happening at the same time?)
Eric
 

Re:About CA-Ingress Open Sourced.

Eric Grange <XXXX@XXXXX.COM>wrote in article
<4160e922$XXXX@XXXXX.COM>...
Quote
>[...] The Ingres server core dumped and went down
>- live core database down = panic.

o_O ouch.
At least no data got corrupted? (but were there inserts/updates
happening at the same time?)
Luckily no, nothing got corrupted - guess I <cough>crashed it at the right
time :o
Subsequently the contingency box didn't actually go down the same way
(loads of rogue processes), and took a bit of work to fix - but I was asked
to do that one...
D.
--
The supplied email address is a spam trap. I am a bit backwards but you can
contact me at eiDOTtenitATzad.
 

Re:About CA-Ingress Open Sourced.

"Darren Davis" <XXXX@XXXXX.COM>writes:
Quote
Marcello Dias <XXXX@XXXXX.COM>wrote in article
<415c1989$XXXX@XXXXX.COM>...
>>Just to give you one of many examples, I ran a query against the live
system which contained a group by clause (via ODBC/BDE). In a moment of
Is it a Ingres R3 Server or what?
I think BDE not to be the right choice,BDE is not the choice for many new Databases.
Regards,
Marcello
 

Re:About CA-Ingress Open Sourced.

Marcello Dias <XXXX@XXXXX.COM>wrote in article
<4161a3d7$XXXX@XXXXX.COM>...
Quote

>Is it a Ingres R3 Server or what?
I think BDE not to be the right choice,BDE is not the choice for many new
Databases.

Not sure what version Marcello. I can easily find out if you're interested.
Regarding the BDE. The only method that I found reliable was the BDE - I
had a LOT of trouble with Ingres NET drivers anyway - If you have another
solution PLEASE let me know :)
Thanks
D.
 

Re:About CA-Ingress Open Sourced.

"Darren Davis" <XXXX@XXXXX.COM>writes:
Quote
Marcello Dias <XXXX@XXXXX.COM>wrote in article
<4161a3d7$XXXX@XXXXX.COM>...
>
>>Is it a Ingres R3 Server or what?
>I think BDE not to be the right choice,BDE is not the choice for many new
Databases.
>
Not sure what version Marcello. I can easily find out if you're interested.
R3 is the first 'open source ' version of Ingres,It has some bugs because it still in beta,CA took one year cleaning the code and developing new features.
Quote

Regarding the BDE. The only method that I found reliable was the BDE - I
had a LOT of trouble with Ingres NET drivers anyway - If you have another
solution PLEASE let me know :)
Im begining with Ingres right now.
Why dont you register in the CA FORUM
opensource.ca.com/projects/ingres/forum
Ive just asked a similar question .
It seems that there are peole using ODBC with success.
I know ODBC seems a little bit OutDated,but CA seems to had optimized its driver very much.
Theyre fixing the bugs very fast and there is not a 'BUG PARADE' a bug is a bug and must be fixed.
Regards,
Marcello Dias
Quote

Thanks

D.