Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am zandeez on github.
  • I am zandeez (https://keybase.io/zandeez) on keybase.
  • I have a public key ASArNpvWR0izdP_EKqBlvV9f3tv7H8h33axkBD6-h0lCBgo

To claim this, I am signing this object:

@zandeez
zandeez / gist:6760670
Created September 30, 2013 08:01
MySQL Stored Procedure for truncating all tables in the database.
DELIMITER //
CREATE PROCEDURE TruncateAll()
--
-- TruncateAll
-- Date: 2013-09-29
-- Author: Andrew Cassidy <andrew@cassidywebservices.co.uk>
--
-- This Stored Procedure Loops over the tables in the current database and
-- truncates them. Behaviour of tables containing or referenced by foreign keys
-- is undefined (by me, MySQL documentation may have other ideas, TL;DR)
@zandeez
zandeez / 10-obs.conf
Created August 29, 2023 08:37
Pipewire / Wireplumber Scripts to use with OBS using Virtual audio devices to isolate Game and Voice chat audio
context.objects = [
{ factory = adapter
args = {
factory.name = support.null-audio-sink
node.name = Game
media.class = Audio/Sink
device.icon_name = audio-card-analog-pci
object.linger = 1
stream.props = {
audio.position = [ FL FR ]