MC front end to PostgreSQL

Pierre Sahores psahores at easynet.fr
Mon Dec 16 12:08:01 EST 2002


Sadhunathan Nadesan a écrit :
> 
> Fantastic, Pierre!
> 
> Simple is beautiful.
> 
> Do you happen to have any working examples, meaning, a front end to
> an existing site?
> 
> Merci!
> 
> Sadhu
> 
> |
> | Allo Friends,
> |
> | For the ones using Oracle or PostgreSQL backend databases (unix hosted)
> | and wants to drive them from within mc apps, without to be sure about
> | the way to do it, just adapt the next script example to your needs
> | (replace "psql" with "sqlplus" to link an Oracle server).
> |
> | >   put "" into DbAuteurs
> | >   get shell("echo" && quote & "select distinct auteur__ from citations order by auteur__" && quote && "| psql -h localhost citalis")
> | >   repeat for each line l in line 3 to -3 of it
> | >     put word 1 to -1 of l & return after DbAuteurs
> | >   end repeat
> |
> | It's probably the fastest and most secure way we can use to get the best
> | from both mc and postgres, without any supplementary middleware need,
> | alike dedicated c, php, perl and soo on libraries, nor odbc drivers or
> | expensive and slow "marketing toys"...
> |
> | Have fun ;-)
> | --
> 
> _______________________________________________
> metacard mailing list
> metacard at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/metacard

Hello Sadhu,

Just have an eye at <http://acacia93.dyndns.org/citalis.xml> in using
"visiteur" as the login and "visiteur" (again) as the password. It's a
small tests purpose dedicated mc/pg web app.

Have fun ;)
--
Cordialement, Pierre Sahores

Inspection académique de Seine-Saint-Denis.
Applications et bases de données WEB et VPN
Qualifier et produire l'avantage compétitif



More information about the metacard mailing list