Board index » delphi » 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
 

"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
 

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.
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
 

Eric Grange <XXXX@XXXXX.COM>writes:
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
 

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

Marcello Dias <XXXX@XXXXX.COM>wrote in article
<415c1989$XXXX@XXXXX.COM>...
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.
 

and never found anything so stable and easy to maintain, specially FB.
 

 

- 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
 

At least no data got corrupted? (but were there inserts/updates
happening at the same time?)
Eric
 

Eric Grange <XXXX@XXXXX.COM>wrote in article
<4160e922$XXXX@XXXXX.COM>...
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.
 

"Darren Davis" <XXXX@XXXXX.COM>writes:
Regards,
Marcello
 

Marcello Dias <XXXX@XXXXX.COM>wrote in article
<4161a3d7$XXXX@XXXXX.COM>...
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.
 

"Darren Davis" <XXXX@XXXXX.COM>writes:
Why don´t you register in the CA FORUM
opensource.ca.com/projects/ingres/forum
I´ve 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.
They´re fixing the bugs very fast and there is not a 'BUG PARADE' a bug is a bug and must be fixed.
Regards,
Marcello Dias