[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 (yeeeeeecch) 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.