8000 Add a lock store using SQL databases functions (get_lock, pg_advisory_lock) · Issue #25400 · symfony/symfony · GitHub
[go: up one dir, main page]
Skip to content

Add a lock store using SQL databases functions (get_lock, pg_advisory_lock) #25400

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Closed
GromNaN opened this issue Dec 8, 2017 · 3 comments
Closed

Add a lock store using SQL databases functions (get_lock, pg_advisory_lock) #25400

GromNaN opened this issue Dec 8, 2017 · 3 comments
Labels
Feature Lock

Comments

@GromNaN
Copy link
Member
GromNaN commented Dec 8, 2017 •
edited
Loading
Q A
Bug report? no
Feature request? yes
BC Break report? no
RFC? no
Symfony version 4.1

The lock component supports local stores : Semaphore and Flock.
For locking over distributed servers, remote stores require Memcached or Redis.

MySQL/MariaDB and PostgreSQL are database server typically used by Symfony applications. These DB engines support locking:

This locking mencanism is used for session in PdoSessionHandler
@Simperfit
Copy link
Contributor

Do you want (and have time) to implement this feature @GromNaN ?

@GromNaN
Copy link
Member Author
GromNaN commented Dec 19, 2017

I don't have time at the moment.

@GromNaN
Copy link
Member Author
GromNaN commented Dec 22, 2017

Some more inspiration:

@GromNaN GromNaN mentioned this issue Dec 22, 2017
Closed
@jderusse jderusse mentioned this issue May 31, 2018
Merged
@fabpot fabpot closed this as completed Sep 4, 2018
fabpot added a commit that referenced this issue Sep 4, 2018
@fabpot
feature #27456 [LOCK] Add a PdoStore (jderusse)
78ecaf3 
This PR was merged into the 4.2-dev branch.

Discussion
----------

[LOCK] Add a PdoStore

| Q             | A
| ------------- | ---
| Branch?       | master
| Bug fix?      | no
| New feature?  | yes
| BC breaks?    | no
| Deprecations? | no
| Tests pass?   | yes
| Fixed tickets | #25400
| License       | MIT
| Doc PR        | symfony/symfony-docs#9875

This is an alternative to #25578

Commits
-------

46fe1b0 Add a PdoStore in lock
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Feature Lock
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@fabpot @javiereguiluz @GromNaN @Simperfit
0