{"repo":"tanbro/sqlalchemy-dlock","free":true,"listed":false,"github":"https://github.com/tanbro/sqlalchemy-dlock","clone":"git clone https://github.com/tanbro/sqlalchemy-dlock.git","description":"Distributed lock based on Database and SQLAlchemy.","language":"Python","stars":17,"topics":["postgresql","orm","mysql","sql","postgres","sqlalchemy","dlock","async","concurrency","database-lock"],"license":"BSD-3-Clause","category":"databases-storage","readme_excerpt":"sqlalchemy-dlock A distributed lock library based on databases and [SQLAlchemy][]. sqlalchemy-dlock provides distributed locking capabilities using your existing database infrastructure—no additional services like Redis or ZooKeeper required. It currently supports: Database Lock Mechanism ---------- ---------------------------------------------------------------------------------------------------------------------------------------------- MySQL Named Lock ( GET LOCK / RELEASE LOCK ) MariaDB Named Lock (compatible with MySQL) MSSQL Application Lock ( sp getapplock ) Oracle User Lock ( DBMS LOCK ) PostgreSQL Advisory Lock ⚠️ Oracle Not Tested: Oracle Database Free (23c/23ai) does NOT support DBMS LOCK.REQUEST . We do NOT test Oracle in CI or integration tests. Use with Oracle Enterprise/Standard Edition at your own risk. --- Why sqlalchemy-dlock? Distributed locks coordinate access to shared resources across multiple processes or servers. Here's how database-based locking compares to other approaches: Solution Pros Cons Best For ----------------- --------------------------------------------- --------------------------------------------------- ------------------------------------ Redis High performance Additional infrastructure, consistency complexities High-throughput scenarios ZooKeeper Strong consistency Complex deployment, high operational cost Financial/mission-critical systems Database Lock Zero additional dependencies, ACID guarantees Lower performance than in-memory sol","default_branch":null,"files":null,"tree":[],"storefront":"/r/tanbro","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/tanbro/sqlalchemy-dlock/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}