Thread: Aubit 4GL for postgresql

Aubit 4GL for postgresql

From
Dave Cramer
Date:
Hi,

Mike Aubury is considering porting Aubit 4GL 
http://www.aubit.com/index.php?page=Products/Aubit4gl   to native 
postgresql.

If this is of interest to you please respond. He is trying to measure 
the level of interest.

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336    
ICQ#14675561



Re: Aubit 4GL for postgresql

From
Bruce Momjian
Date:
Dave Cramer wrote:
> Hi,
> 
> Mike Aubury is considering porting Aubit 4GL 
> http://www.aubit.com/index.php?page=Products/Aubit4gl   to native 
> postgresql.
> 
> If this is of interest to you please respond. He is trying to measure 
> the level of interest.

Uh, I thought it already worked with PostgreSQL.  Certainly there is a
lot of demand from companies porting from Informix and for users who
need a good database-aware application language.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


Re: Aubit 4GL for postgresql

From
"Claudio Duffini"
Date:
This would be a panacea, for us. We are moving a big installation
from Informix to Postgres, and 90% of our apps are Informix-4gl...

"Bruce Momjian" <pgman@candle.pha.pa.us> ha scritto nel messaggio
news:200411300239.iAU2d7008068@candle.pha.pa.us...
> Dave Cramer wrote:
> > Hi,
> >
> > Mike Aubury is considering porting Aubit 4GL
> > http://www.aubit.com/index.php?page=Products/Aubit4gl   to native
> > postgresql.
> >
> > If this is of interest to you please respond. He is trying to measure
> > the level of interest.
>
> Uh, I thought it already worked with PostgreSQL.  Certainly there is a
> lot of demand from companies porting from Informix and for users who
> need a good database-aware application language.
>
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania
19073
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>




Re: Aubit 4GL for postgresql

From
Mike Aubury
Date:
Just to clarify -  Aubit4GL currently works with InformixSQL style SQL 
statements being converted to PostgresSQL on the fly for migrating current 
Informix4GL programs to run against a PostgresSQL database.

What I'm talking about here is running native PostgresSQL statements within 
the 4GL for people who've maybe never heard of Informix 4GL/SQL.

(For example - Aubit4GL has no CREATE TYPE statement, outer joins are 
different etc - a PostgresSQL programmer may not like the fact they need to 
PREPARE or SQL/ENDSQL around these statements that the current 4GL grammar 
rules don't recognise...).



On Tuesday 30 November 2004 02:39, Bruce Momjian wrote:
> Dave Cramer wrote:
> > Hi,
> >
> > Mike Aubury is considering porting Aubit 4GL
> > http://www.aubit.com/index.php?page=Products/Aubit4gl   to native
> > postgresql.
> >
> > If this is of interest to you please respond. He is trying to measure
> > the level of interest.
>
> Uh, I thought it already worked with PostgreSQL.  Certainly there is a
> lot of demand from companies porting from Informix and for users who
> need a good database-aware application language.


Re: Aubit 4GL for postgresql

From
Jaime Casanova
Date:
Dave Cramer wrote:
> Hi,
> 
> Mike Aubury is considering porting Aubit 4GL 
>
>
http://www.aubit.com/index.php?page=Products/Aubit4gl
>  to native postgresql.
> 
> If this is of interest to you please respond. He
> is trying to measure the level of interest.
> 

I have an Informix-4GL application i was thinking in
migrate this to postgreSQL. Yea!! I really like an
Aubit4gl Postgresql native port!!

I read in one of the postings that actually i can use
postgresql with aubit encosing nonInformix sintaxis in
SQL - END SQL block. it that true? where can i foun
more info about this issue?

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com


Re: Aubit 4GL for postgresql

From
Mike Aubury
Date:
Aubit4GL will already take an Informix4GL program, and run it on postgres
(mostly!). We have a translation module which takes care of a large portion
of the differences, and theres also an Informix compatibility patch for
postgres which takes care of some of the backend stuff too...


And yes - you can either PREPARE or SQL-END SQL around any non-informix SQL
statements..

HTH

On Tuesday 30 November 2004 20:59, Jaime Casanova wrote:
> I have an Informix-4GL application i was thinking in
> migrate this to postgreSQL. Yea!! I really like an
> Aubit4gl Postgresql native port!!
>
> I read in one of the postings that actually i can use
> postgresql with aubit encosing nonInformix sintaxis in
> SQL - END SQL block. it that true? where can i foun
> more info about this issue?
>
> regards,
> Jaime Casanova
>
> _________________________________________________________
> Do You Yahoo!?
> Información de Estados Unidos y América Latina, en Yahoo! Noticias.
> Visítanos en http://noticias.espanol.yahoo.com