[Aubit4gl-discuss] Re: We're live!!

[Walter H. <ne...@ba...>]

Hello Mike,

> Most of these are solved by the informix compatibility patches in postgres & 
> ecpg - there are a few runtime setting for Aubit which help too...

Do you mean the 'official' PostgreSQL, or are there out more
patches to make PostgreSQL more Informix-like?

At the moment we are migrating from a Informix Online 5/I4GL 4
System to PostgreSQL 7.4 / 4JS BDL 3.53. Well most thinks run
fine now, but at the beginning we had some problems, because
our applications make heavy use of BLOBS and INTERVAL and both
are not supported by the Postgres-backend of 4JS.  So I had to
write some (ugly) hacks in the pcode-runner and created SQL
statements with casting-orgies :) e.g:
Informix: "SELECT sum(my_time)/2 FROM ..."
Postgres: "SELECT (sum((my_time::TEXT)::INTERVAL)/2)::TEXT FROM ..."

> I can get a full list if this is something you're interested in doing...

Yes, please. When we finished this project, I'll take a closer
look at Aubit and try to use it for new development.

> Also - they don't use 'MONEY' - which Aubit4GL still lacks proper support for 
> (they are just treated as DECIMALs internally)

Hm, is anybody out there really using MONEY? I do Informix/I4GL for 10
years, but I've never seen a table with a MONEY datatype 'in the wild'.

> stable release shortly as part of Phase 2 of this project, which should 
> hopefully be fully releasable as Aubit v0.5 (possibly Aubit v1.0?)...

Is there a list of planed features for the future?

I think it will be a real killer feature, if aubit got some kind
of client/server architecture, with different GUI clients (like:
native Win32, Java, Html/Javascript, native Linux...) like 4JS, but
with more powerfull widgets (Textarea, Treeview, Calendar, Fileselection...)
and a more flexible event-driven architecture.

Walter