Did you test this class with a real sqlite connection? If so could you please also test the blocking withhttps://github.com/Tobion/symfony-standard/tree/session-locking-test ?

I didn't test it with a real sqlite connection as I don't use custom session handlers in my project. I've installed yoursession-locking-test branch and was able to read and write session data using/write/foo and/read requests. Is it enough or should I do something else to test blocking?

Did you updatehttps://github.com/Tobion/symfony-standard/blob/session-locking-test/app/config/config.yml#L46 to use postgres? You can test blocking by loading two pages/write/foo and/read at the same time. Just refresh write and then read. The read page should block until the write finished (which has a delay of 8 sec). Then do the same test with advisory locks by changinghttps://github.com/Tobion/symfony-standard/blob/session-locking-test/app/config/config.yml#L29 to1. The behavior should be the same as before.

@Tobion I've testedpgsql driver as you described and it works as expected.

Cool thanks. And did pdo_pgsql indeed return a stream for the binary field?

Yes, and it's mentioned in themanual:

Note:
The bytea fields are returned as streams.

👍 Thanks for fixing this and doing functional tests.
In case you also have access to oracle db or mssql, it would be much appreciated to do the same tests for them.

Thank you@rybakit.