Fine-grained locking

[livius...@poczta.onet.pl]

Hi,

does Firebird have fine-grained locking?

https://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

[Dimitry Sibiryakov]

liviuslivius via firebird-support wrote 10.08.2025 11:45:
> does Firebird have /fine-grained locking/?

In the terms used in the article - yes, it has explicit row-level locking.
In wider terms Firebird uses MVCC instead of locking.

--
WBR, SD.

[Pavel Cisar]

Dne 10. 08. 25 v 11:45 liviuslivius via firebird-support napsal(a):

>
> does Firebird have /fine-grained locking/?
>

> https://en.wikipedia.org/wiki/
> Comparison_of_relational_database_management_systems <https://
> en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems>

Firebird uses MVCC architecture (like Postgresql, but Firebird had it
first) so it does not need locks to manage access to data, but allows
explicit locks on row level via SELECT ... FOR UPDATE WITH LOCK
construct since v1.5, see
https://www.firebirdsql.org/refdocs/langrefupd15-notes-withlock.html

In the context of mentioned wikipedia table, you may say that it's the
same as what listed for postgresql there.

best regards
Pavel Cisar
IBPhoenix

[livius...@poczta.onet.pl]

Thx,

a more provocative way I asked this question, hoping that someone would fill in this website a bit more thoroughly :)

liviuslivius via firebird-support wrote 10.08.2025 11:45:
> does Firebird have /fine-grained locking/?

   In the terms used in the article - yes, it has explicit row-level locking.
   In wider terms Firebird uses MVCC instead of locking.

-- 
   WBR, SD.

-- 
Support the ongoing development of Firebird! Consider donating to the Firebird Foundation and help ensure its future. Every contribution makes a difference. Learn more and donate here:
https://www.firebirdsql.org/donate
--- 
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/firebird-support/5b97e10a-1b36-4765-bcbd-c886f60ca82c%40ibphoenix.com.