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

Michael Van Canneyt michael at freepascal.org
Wed Sep 27 18:01:46 CEST 2017

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

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...


More information about the fpc-pascal mailing list