Skip to content

Instantly share code, notes, and snippets.

View thebirk's full-sized avatar

Aleksander Birkeland thebirk

10 followers · 14 following
View GitHub Profile
@thebirk
thebirk / TabWriteSliceOfStructs.go
Created February 21, 2025 10:20
func TabWriteSliceOfStructs[E any](w io.Writer, d []E) error {
t := reflect.TypeOf(d).Elem()
for i := 0; i < t.NumField(); i++ {
if i > 0 {
if _, err := w.Write([]byte{'\t'}); err != nil {
return err
}
}
if _, err := w.Write([]byte(t.Field(i).Name)); err != nil {
return err
@thebirk
thebirk / check_column_in_table_for_all_databases.sql
Created September 27, 2024 08:47
Check if column exists in a table across all databases - SQL Server
DECLARE @cmd nvarchar(2000)
SET @cmd = N'USE [?] IF EXISTS(SELECT * FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = ''TABLE_NAME_HERE''
AND COLUMN_NAME = ''COLUMN_NAME_HERE'')
BEGIN
SELECT DB_NAME() AS ''Database'', ''TRUE'' AS ''Exists''
END
ELSE SELECT DB_NAME() AS ''Database'', ''FALSE'' AS ''Exists'''
EXEC sp_MSforeachdb @command1 = @cmd;
@thebirk
thebirk / query.sql
Created August 27, 2024 09:07
Check index usage SQL Server
/* https://stackoverflow.com/a/5146398/1088079 */
SELECT
row_number() over(order by user_seeks,user_lookups,user_scans),
[Database] = d.name,
[Schema]= s.name,
[Table]= o.name,
[Index]= x.name,
[Scans] = user_scans,
[Seeks] = user_seeks,
@thebirk
thebirk / content.js
Created February 5, 2024 23:56
OBS Websocket browser proof of concept
document.addEventListener("contextmenu", async function(e) {
const message = e.target.closest('.chat-line__message');
if (!message) {
return;
}
e.preventDefault();
const obs = new OBSWebSocket();
await obs.connect("ws://127.0.0.1:4455", "4tP1Yw7d5FxnnCjI");
@thebirk
thebirk / obs.html
Created February 5, 2024 23:12
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>OBS Websocket</title>
<script src="https://unpkg.com/obs-websocket-js"></script>
<script type="module" async>
document.addEventListener("DOMContentLoaded", async function() {
const obs = new OBSWebSocket();
await obs.connect("ws://192.168.0.158:4455", "4tP1Yw7d5FxnnCjI");
@thebirk
thebirk / DisposableStopwatch.cs
Created October 6, 2021 11:17
public class DisposableStopwatch : Stopwatch, IDisposable
{
public delegate string OnStopDelegate(TimeSpan time);
private readonly OnStopDelegate _onStop;
public DisposableStopwatch(OnStopDelegate onStop)
{
_onStop = onStop;
Start();
}
@thebirk
thebirk / odin-interfaces.odin
Created November 27, 2020 22:54
😈
package test
Id :: struct(T: typeid) {
value: int,
}
Asset :: struct {
id: Id(Asset),
name: string,
}
@thebirk
thebirk / main.odin
Created April 26, 2020 02:12
minny thing
package emulator
import "core:os"
import "core:fmt"
import "core:time"
import "core:math/rand"
when ODIN_OS == "windows" do foreign import libc "system:libcmt.lib";
when ODIN_OS == "linux" do foreign import libc "system:c";
foreign libc {
@thebirk
thebirk / touch.c
Last active April 5, 2020 12:09
Basic touch clone for windows
// Copyright (c) 2020 Aleksander B. Birkeland (thebirk)
//
// Permission is hereby granted, free of charge, to any person obtaining a copy
// of this softwareand associated documentation files(the "Software"), to deal
// in the Software without restriction, including without limitation the rights
// to use, copy, modify, merge, publish, distribute, sublicense, and /or sell
// copies of the Software, and to permit persons to whom the Software is
// furnished to do so, subject to the following conditions :
//
// The above copyright noticeand this permission notice shall be included in all
@thebirk
thebirk / install.bat
Last active February 7, 2020 21:29
Copies any file into the folder in which 'install.bat' is located. Useful for copying files into a directory exposed through PATH
@echo off
REM Copyright 2020 Aleksander B. Birkeland <[email protected]>
REM
REM Permission is hereby granted, free of charge, to any person obtaining a
REM copy of this software and associated documentation files (the "Software"),
REM to deal in the Software without restriction, including without limitation
REM the rights to use, copy, modify, merge, publish, distribute, sublicense,
REM and/or sell copies of the Software, and to permit persons to whom the
REM Software is furnished to do so, subject to the following conditions:
REM