New to web programming, some questions about DB connections

[gerardus]

Hi,

I started playing with Lazarus & the Brook framework to make a standalone web ser app.
I need this server application to access a Firebird database.
http://silvioprog.github.io/brookframework/
Is the auto-generated server application multithreaded?  If so, do I need some kind of locking to use SQLDB components?

best regards,

Gerard.

[tudi_x]

Connection to database is in most case single threaded therefore you might need a connection for each thread or a critical section (slower).
As far as I can recall the embedded Brook web server can work multi threaded.

[Leledumbo]

Is the auto-generated server application multithreaded?

No, but can be activated in a single line:

Code: Pascal  [Select][+][-]

1. (BrookApp.Instance as TBrookHTTPApplication).Threaded := true;
2.  

If so, do I need some kind of locking to use SQLDB components?

I don't need it when using MariaDB, but perhaps other dbms requires it.

[gerardus]

Thanks for your replies.

[hrayon]

Are you using the embedded version(Firebird 2.5.0 or greater)?
The embedded libraries - libfbembed.so on POSIX and fbembed.dll on Windows - are now multi-thread-capable and thread-safe, so they can be used in multi-threaded applications.

[gerardus]

I am using the linux client library against a windows server.
If the project finally is done, I won't be able to use the embedded libs.
It will be against a server that is already in production in a classic client/server setup.
Thanks for pointing this, it seems that all the client libs are thread-safe from 2.5 on?
http://firebirdsql.org/file/documentation/release_notes/html/en/2_5/rnfb25-engine-thrdsafe.html