[fpc-devel] Questions regarding PostgreSQL support in SqlDB

[Desmond Coertzen]

Jong, I did not make much changes to the fpc files itself. The only change I
made to the api wrapper is the location of the libpq.so / dll file. It use
to load from current working dir, or going on a rampant search according to
the LD_LIBRARY_PATH environment variable on linux. I made a mod where the
location of the lib file may be set.

You might not be able to use this code at all due to the TDataSet ancestry
being non existent.. BUT, if you can find any use at all for this code,
check it out at svn://196.36.108.47/fpc_pgsqlclientlib

The classes are in libpq_components.pas. References to other units to
compile is in an svn external under lib directory.

The code is extremely ugly. Good luck.

On Mon, Aug 17, 2009 at 1:30 PM, Graeme Geldenhuys <
graemeg at opensoft.homeip.net> wrote:

> Desmond Coertzen wrote:
>
>> I tried TPQConnection in a production environment on a server-side deamon,
>> and bytea was the first missing data type that haunted me. The "encode"
>> postgres function will save you here: Encode your bytea field
>>
>
> I can't remember, but I think bytea (I call it blob) work fine for me, but
> I'll have to double check to be 100% sure.
>
>
>  to hex, then run a hextobin afterwards. (Sorry if you use dbAware
>> components in this case). Some other field types were missing as well, I
>>
>
> I do not use DB-aware components in our applications. I use "mediator
> views" also know as Model-GUI-Mediator. The the following URL for an article
> on it.
>
>  http://opensoft.homeip.net/articles/
>
>
>  of TDataSet, but, it worked for everything I needed in those daemons, it
>> is lightweight and stable. !!/No support for parameters and prepared
>> statements/!!
>>
>
> I have had some "prepare statement" issues with SqlDB+PostgreSQL as well. I
> still need to investigate this further. In the mean time, I disable all
> "prepare" calls in my application for now.
>
>
>  I'm still a novice pascal programmer. If you are interested in my code, I
>> can publish somewhere and send you a url.
>>
>
> Are we allowed to merge some of your changes back into the SqlDB code? If
> so, yes please do post a url.
>
>
> Regards,
>  - Graeme -
>
> --
> fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
>
> http://opensoft.homeip.net/fpgui/
>
> _______________________________________________
> fpc-devel maillist  -  fpc-devel at lists.freepascal.org
> http://lists.freepascal.org/mailman/listinfo/fpc-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-devel/attachments/20090817/3d51d609/attachment.html>