[fpc-pascal] FCL-WEB and PostgreSQL Support: Current Status

Mark Morgan Lloyd markMLl.fpc-pascal at telemetry.co.uk
Wed Sep 27 21:16:27 CEST 2017

On 27/09/17 18:30, Marco van de Voort wrote:
> In our previous episode, Mark Morgan Lloyd said:> > Can you ellaborate a bit more on this Michael? Like how and where it isused? (Not mentioning company names, if it's a problem.) I was thinkingabout using it in various places, but as I don't know how widely they'retested and used and under what conditions, I didn't had the balls to offerthis as viable alternative against competing technology X.> > We definitely need more use case studies...> > The only problems I've experienced with FPC's support for PostgreSQL > were related to handling SQL queries (e.g. spurious parameter > substitution) rather than to dataflow. As such they were predictable and > could be worked round.
> Zeljan once explained an interesting practical problem he had.
> He said the connection per transaction model could be dangerous, speciallyin a mobile era where connections are often broken, and thus must wait ontimeout.  This means during rush times, a server can run out of a fairlylimited ephemeral port inventory before abandoned connections start to timeout.
> That is a postgres problem though, not the FPC components
Which I suppose really starts getting to be an issue when somebody tries 
to "put something in the cloud" without careful consideration of that 
type of scenario.

Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

More information about the fpc-pascal mailing list