[fpc-devel] Questions regarding PostgreSQL support in SqlDB

[Graeme Geldenhuys]

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/