[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