RevDB, Linux and PostgreSQL

[Rodney Tamblyn]

Hi Pierre,

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,
>> 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
>> use-revolution at lists.runrev.com
>> http://lists.runrev.com/mailman/listinfo/use-revolution
> Hi Rodney,
>
> 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
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
--
Rodney Tamblyn
44 Melville Street
Dunedin
New Zealand
+64 3 4778606
http://rodney.weblogs.com/