{"repo":"kamranata/queue-sql","free":true,"listed":false,"github":"https://github.com/kamranata/queue-sql","clone":"git clone https://github.com/kamranata/queue-sql.git","description":"Queue any Laravel write query (delete/update/insert) across parallel batched jobs.","language":"PHP","stars":28,"topics":["batch","bulk-operations","database","eloquent","jobs","laravel","laravel-package","php","queue"],"license":"MIT","category":"databases-storage","readme_excerpt":"Queue any Laravel write query — delete , update , insert — and run it across parallel batched jobs. Built for large-scale mutations without long locks. Why A single User::where('is blocked', true)- delete() over millions of rows runs one giant statement: it holds a long lock, blocks the web request, strains replication, and often hits the request or worker timeout. queue-sql turns that one statement into many small, parallel jobs. It reads the min/max primary key under your constraints, splits the key space into chunk -sized ranges, and dispatches one batched job per range. Each job re-applies your original WHERE and mutates only its own slice — so every statement is small and bounded, locks stay short, and the work runs on your queue workers instead of the request. You keep the fluent Eloquent API you already know, and get batch progress, retries, throttling, then / catch / finally callbacks, Artisan monitoring, and Horizon tags for free. Features - Any write, any builder — delete / update / insert / upsert on the Query Builder or Eloquent. - Parallel PK-range fan-out — one batched job per key range; short locks instead of one long one. - Every where survives the queue boundary — nested closures, whereHas , whereExists , sub-selects — captured as a parameterized SQL fragment (injection-safe, no serialized closures). - Size by rows or by jobs — fixed chunk , or maxJobs to cap the total job count. - Config-driven defaults — set chunk / tries / backoff / throttle / delay / queu","default_branch":null,"files":null,"tree":[],"storefront":"/r/kamranata","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/kamranata/queue-sql/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."}