[fpc-devel] Questions regarding PostgreSQL support in SqlDB

Graeme Geldenhuys graemeg at opensoft.homeip.net
Mon Aug 17 15:30:32 CEST 2009

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.


> 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.

   - Graeme -

fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal

More information about the fpc-devel mailing list