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

[Marcos Douglas B. Santos]

On Wed, Sep 27, 2017 at 12:16 PM, African Wild Dog
 wrote:
> Hello,
>
> I am about to start a new project for a very small web application.
>
> I have some questions:
>
> 1 - Are the fcl-web and postgres packages stable?
> 2 - Are they recommended for use in production environments?
> 3 - Do they have any serious bug (for example, memory leaks)?

I have been using fcl-web in production about 2 years.
However, my environment is Windows and Microsoft IIS, running FastCGI.
Most of these apps are used to provide REST API's.
I don't have any problems. These apps are fast and I can use shared
code between Desktop and Web. Very good.

Best regards,
Marcos Douglas
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

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

[Mark Morgan Lloyd]

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]
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

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

[Michael Van Canneyt]

On Wed, 27 Sep 2017, 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, specially
in a mobile era where connections are often broken, and thus must wait on
timeout.  This means during rush times, a server can run out of a fairly
limited ephemeral port inventory before abandoned connections start to time
out.

That is a postgres problem though, not the FPC components.


1. In a REST setting, if you use FastCGI and connnection pooling,
   this should not be a problem.
   The webserver normally has a reliable connection with the DB server:)

2. On Postgres specifically, you can use PGBouncer.
   It mitigates the number of connections to the server.

Michael.
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

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

[Marco van de Voort]

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, specially
in a mobile era where connections are often broken, and thus must wait on
timeout.  This means during rush times, a server can run out of a fairly
limited ephemeral port inventory before abandoned connections start to time
out.

That is a postgres problem though, not the FPC components.
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

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

[Mark Morgan Lloyd]

On 27/09/17 15:45, Karoly Balogh (Charlie/SGR) wrote:

Hi,
On Wed, 27 Sep 2017, Michael Van Canneyt wrote:

2 - Are they recommended for use in production environments?>> Absolutely.> I use 
them in very high-load (and we're talking VERY high load)> environments, with 24/7 
availability.

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.


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

[Opinions above are the author's, not those of his employers or colleagues]
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

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

[Michael Van Canneyt]

On Wed, 27 Sep 2017, Karoly Balogh (Charlie/SGR) wrote:


Hi,

On Wed, 27 Sep 2017, Michael Van Canneyt wrote:


> 2 - Are they recommended for use in production environments?

Absolutely.
I use them in very high-load (and we're talking VERY high load)
environments, with 24/7 availability.


Can you ellaborate a bit more on this Michael? Like how and where it is
used? (Not mentioning company names, if it's a problem.) I was thinking
about using it in various places, but as I don't know how widely they're
tested and used and under what conditions, I didn't had the balls to offer
this as viable alternative against competing technology X.


It is extremely viable.

I have used it in 2 companies, first production dating back to 2010.

Mainly it's used to offer read/write REST apis, with access to Firebird or 
Postgres databases. You can add some Cassandra, MemCached and Redis into 
the mix, and even (yeecch) mysql.


It's also used as a middle layer on top Microsoft/Google APIS to offer a
single, unified API to access google docs or onedrive to the REST client.
Thus, the oauth2, json apis of FPC are well tested, as well as the webclient
units.

It also offers a variety of export data (CSV/XML/HTML/Excel).

All 24/7.

The new fpreport is used to provide reporting services - outputting PDF and
sending that directly to the browser.

All this has been tested heavily on Linux and Windows.

So yes, I can say it is safe to use in production.

And it will only get better once pas2js is released (expected somewhere in
December). FPC will offer a full web stack that sends NodeJS reeling...

Michael.
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

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

[Michael Van Canneyt]

On Wed, 27 Sep 2017, African Wild Dog wrote:


2017-09-27 12:29 GMT-03:00 Michael Van Canneyt :



2 - Are they recommended for use in production environments?




Absolutely. I use them in very high-load (and we're talking VERY high load)
environments, with 24/7 availability.



Could you tell which web server you are using in this environment? Are you
using FastCGI?


Apache, indeed using FastCGI. 
Used both mod_fastcgi as mod_fcgid. mod_proxy should work as well.


Michael.
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

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

[African Wild Dog]

2017-09-27 12:29 GMT-03:00 Michael Van Canneyt :

>
> 2 - Are they recommended for use in production environments?
>>
>
> Absolutely. I use them in very high-load (and we're talking VERY high load)
> environments, with 24/7 availability.
>
>
Could you tell which web server you are using in this environment? Are you
using FastCGI?

Regards
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

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

[Karoly Balogh (Charlie/SGR)]

Hi,

On Wed, 27 Sep 2017, Michael Van Canneyt wrote:

> > 2 - Are they recommended for use in production environments?
>
> Absolutely.
> I use them in very high-load (and we're talking VERY high load)
> environments, with 24/7 availability.

Can you ellaborate a bit more on this Michael? Like how and where it is
used? (Not mentioning company names, if it's a problem.) I was thinking
about using it in various places, but as I don't know how widely they're
tested and used and under what conditions, I didn't had the balls to offer
this as viable alternative against competing technology X.

We definitely need more use case studies...

Charlie
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

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

[Michael Van Canneyt]

On Wed, 27 Sep 2017, African Wild Dog wrote:


Hello,

I am about to start a new project for a very small web application.

I have some questions:

1 - Are the fcl-web and postgres packages stable?


Since 8 years.


2 - Are they recommended for use in production environments?


Absolutely. 
I use them in very high-load (and we're talking VERY high load)

environments, with 24/7 availability.


3 - Do they have any serious bug (for example, memory leaks)?


None that I know of.

Michael.
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

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

[African Wild Dog]

Hello,

I am about to start a new project for a very small web application.

I have some questions:

1 - Are the fcl-web and postgres packages stable?
2 - Are they recommended for use in production environments?
3 - Do they have any serious bug (for example, memory leaks)?

Regards
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal