[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:
> On Wed, 27 Sep 2017, Michael Van Canneyt wrote:
>> > 2 - Are they recommended for use in production environments?
>> 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).
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