[fpc-devel] Questions regarding PostgreSQL support in SqlDB
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
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