I've developed the client application on MacOSX and have tested it successfully under Windows. Haven't tested yet under Linux so can't help there. The database is running on a separate machine, AFAIK running PG 7.3 - I believe this is running Linux but can confirm this if it's of interest ( db was set up by our technical support group).
I agree with you that it would be *fantastic* to be able to use Rev's built in database functions from command line applications, especially under Linux. I believe this is on the list of planned features (can someone from RR comment on this?). Monte Goulding and I looked into this a little when we were collaborating on the development of libCGI (a freebie CGI library and getting started guide for development of Rev/MC CGI solutions which we will be releasing shortly). Using psql via shell() works fine, but it's not very elegant and can't handle binary data (or if it can I don't know how to do this, perhaps you could pipe binary data in from a file?).
How is RR's Linux DB support implemented at the moment? Is it via externals as is the case for Windows & Mac? Perhaps Tuviah can comment more here.
I may open source the project I've developed, as it's a student exercise rather than a commercial project. May be useful to have a real world example stack showing how these things are done.
Regards,
Rodney
On Thursday, August 14, 2003, at 05:12 AM, Pierre Sahores wrote:
Rodney Tamblyn wrote:Hello everyone,Hi Rodney,
This is just a followup to let you know the bug which I found in Revolution at present that prevents binary data operations with PostgreSQL database has been confirmed. It will be fixed in the final release of 2.1 apparently.
In the meantime the workaround which I've discovered, and which works quite well, is to base64encode data then put it into a PostgreSQL text field (which seem, AFAIK, to be able to hold unlimited data). On retrieving the data I do a base64decode to turn it back into binary data. Using this approach I've been able to successfully store image data in PostgreSQL text fields.
So the mystery is solved...
~ Rodney
_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution
Cool tip to know !
Could you, please, let me know, the platform witch host your Revolution's PostgeSQL client app, the platform witch host the PostgreSQL server ? Are both the client and the server running on the same box, on two diffrent boxes ?
Even in using an example app, friendly provided to me by Sadhu, i have n't, at the moment, found the way to run a Rev's PostgreSQL client app hosted on the Linux platform (no tested on Win32 nor OSX, for yet) :-!
Thanks for any help,
IBTW : My Postgres 7.xx server is fine running and serving in production mode MC apps trough shell() bindings to the psql Postgres command line client. My problem is to get the right way to replace the shell() way by the RevDB lib's one?
-- Bien cordialement, Pierre Sahores
Inspection acad�mique de Seine-Saint-Denis Serveurs d'applications et SGBDR (Web/PGI) Penser et produire l'avantage comp�titif
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
-- Rodney Tamblyn 44 Melville Street Dunedin New Zealand +64 3 4778606 http://rodney.weblogs.com/
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
