MC front end to PostgreSQL

[Pierre Sahores]

Allo Sadhu,

> |
> | The best, in my mind, would be to build a general purpose example app,
> | directly descibed and shared on the Metacard list, to let evryone become
> | able to understand how the purposed technology works and how to reuse it
> | to build, from scratch,
> | other kinds of dedicated apps.
> 
>         Agree!  that would be great.
> |
> | If you are ok about this, i could contribute to this commun effort in
> | converting an existing AddressBook stack in a client-server
> | AdressBook stuff, in using, on the client-side, a standard desktop
> | dedicated AdressBook stack converted in a Metacard-based AdressBook
> | front-end and, on the server-side, a PostgeSQL-based AdressBook
> | back-end.
> 
>         An impressive spirit of volunteerism, for which we'd be very
>         grateful, merci!

Yes but not only ;-) We need just to let others know how usefull
Metacard can be, even in the web apps market share. Else, it will always
stay difficult to, again and again, have to repeat to the new clients
and prospects why the "unknowed Metacard" is a more usable web
development tool than the "so well knowed" java, php or zope
platforms... Because all what will let Metacard (and Revolution, witch
as, time to time, a paper in MacWorld France) become best knowed is good
for us and Scott, i think that the best to do is to share the infos,
each time there is an opportunity to explain why and how mc can, at
least, be equivalent or better than other development tools.

> | I can't, for my how, open and share an access to the production servers
> | (including an access to PostgreSQL), because the servers i'm working on
> | are howned by private companies or administrations.
> |
> | What we need, at this point, is (1) to find a fine free and reusable
> | AddressBook stack on top of witch we could add the client-server layer
> | code
> 
>         Seems like someone out there would have something they could
>         contribute?  If not, we could do something very simple.  I am
>         thinking, for a beginning application, simpler the better.
>         Such as a single record data base with just a few typical
>         fields, name, address, phone, email etc.
> 
> | and (2) a free hosted access to a PostgreSQL enabled server (including
> | the right to install mc as a cgi engine or, best, as a web application
> | server deamon (startable and rebootable trough SSH only, for security
> | reasons). Could you
> | find an host interested in supporting this part of the project ?
> |
> 
>         Well, that might be me.  It would be ideal if I could get this
>         going at work, but my home server may suffice for the time
>         being (if we can live with MC 2.4 as the cgi engine).
> 
>         We could at least start there.  MC is installed in
>         /usr/local/bin, so what do you need, Pierre, just an ssh
>         account?

That's cool Sadhu. All our needs are ok, yet. I think that i will have
time, in the next week-end, to build our simple example app. Once
tested, i will mail it to you and let you know where to install the
differents components (web applications server sockets listener and
init.d starter script - no special destination paths needs for both the
was and the client front-end), what Postgres table to create and so on
(off list, about ssh).
 
>         Sadhu
> 
> _______________________________________________
> metacard mailing list
> metacard at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/metacard

-- 
Best Regards, 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

P.S.: I just rembembered this evening, in reading the mc list archive,
that David Bowill has shared, some months ago, a way to connect MySQL
from mc in using the same "command line way" we use to link mc to
Postgres. It will probably be very simple to adapt our "week-end" work
to a MySQL back-end too.