Is there Connection Pool in fcl-db
lazarus / 16-Databases

----------------------------------------------------------------------
daniel_sap · 2025-04-11 11:15

Hi,
I'm using fcl-db classes for database access.
Currently, I'm writing rest api back-end and have concurrent endpoint
calls and would like
to use connection pool.
Is there class implemented for it in fcl-db.
How do you think, is it good idea to keep up with fcl-db or to go for
ZeosLib, mORMot or other.

For now I'm thinking to do custom implementation, which will be a
class with few methods,
but if you see some issues or can advice ...

----------------------------------------------------------------------
zeljko · 2025-04-11 12:37

AFAIR there's sqldbpool or similar in fpc trunk.

----------------------------------------------------------------------
daniel_sap · 2025-04-11 19:38

Quote from: zeljko on April 11, 2025, 02:37:27 pmAFAIR there's
sqldbpool or similar in fpc trunk.

I took if from the trunk and build it in my project without any
issues.

However, didn't find any usage example - in source\packages\fcl-
db\examples or in the wiki.
If someone has some simple example to provide ...

----------------------------------------------------------------------
zeljko · 2025-04-11 20:52

I think it is used in sqldbrest, so check there.

----------------------------------------------------------------------
daniel_sap · 2025-04-11 21:56

Quote from: zeljko on April 11, 2025, 10:52:41 pmI think it is used in
sqldbrest, so check there.

Thank you, zeljko,

I found also this example application
fpc\source\packages\fcl-web\examples\restbridge\demorestbridge.lpi