Skip to content

Instantly share code, notes, and snippets.

@wcollins
wcollins / awx_install.sh
Last active August 12, 2026 10:22
Install Ansible AWX on Debian Linux
#! /usr/bin/env bash
set -o pipefail
function update_debian() {
# +----------------+
# | Update Debian |
# +----------------+
cmd_list="update upgrade dist-upgrade autoremove clean"

LLM Wiki

A pattern for building personal knowledge bases using LLMs.

This is an idea file, it is designed to be copy pasted to your own LLM Agent (e.g. OpenAI Codex, Claude Code, OpenCode / Pi, or etc.). Its goal is to communicate the high level idea, but your agent will build out the specifics in collaboration with you.

The core idea

Most people's experience with LLMs and documents looks like RAG: you upload a collection of files, the LLM retrieves relevant chunks at query time, and generates an answer. This works, but the LLM is rediscovering knowledge from scratch on every question. There's no accumulation. Ask a subtle question that requires synthesizing five documents, and the LLM has to find and piece together the relevant fragments every time. Nothing is built up. NotebookLM, ChatGPT file uploads, and most RAG systems work this way.

Setup Multiple Local Supabase Projects

Project 1 (Current - my-project) default settings:

  • API: 54321, DB: 54322, DB.POOLER: 54329, Studio: 54323, Inbucket: 54324, Analytics: 54327, Edge Inspector: 8382

Project 2 (New - my-project-2):

  • API: 54331, DB: 54332, DB.POOLER: 54339, Studio: 54333, Inbucket: 54334, Analytics: 54337, Edge Inspector: 8383

Steps:

@BoQsc
BoQsc / blocking internet access via Firewall.cmd
Created October 21, 2019 08:44
This Batch script Adds a Windows Defender Firewall rule to block any HTTPS (443 port) connections
@ECHO OFF
REM Make the all HTTPS internet sites temporary inaccesible on the whole computer by adding Windows Defender Firewall rule.
REM An "Outbound" Firewall Rule will be added to the Windows Defender Firewall, named "Block internet access to 443 HTTPS protocol temporary for the whole computer session"
REM If Firewall rule named "Block internet access to 443 HTTPS protocol temporary for the whole computer session" already exists - it will be removed
REM Notice: requires administrator's privilegies to remove or add Windows Defender Firewall rule.
netsh advfirewall firewall show rule name="Block internet access to 443 HTTPS protocol temporary for the whole computer session"
if %ERRORLEVEL% equ 0 netsh advfirewall firewall delete rule name="Block internet access to 443 HTTPS protocol temporary for the whole computer session"
if %ERRORLEVEL% equ 1 netsh advfirewall firewall add rule name="Block internet access to 443 HTTPS protocol temporary for the whole computer session" dir=out action=block protocol=TCP

ERP Local — API Documentation

Collection: ERP API's Collection App Wise → ERP Local Base URL: <ERP-APP-URL> (Customer / Warehouse / Stock APIs) | <ERP-APP-URL> (Supplier APIs) Authentication: Token-based (Authorization: Token <key>)


Table of Contents

@santakd
santakd / gist:a2ccfeb612d3bc168c7ba8af946da65c
Last active August 12, 2026 09:50
Run a 4B LLM model locally on your mac
Run a 4B LLM model locally on your mac, this has been tested on MacOS Tahoe
Step 1:
Lookup "llamafile github" or go to https://github.com/mozilla-ai/llamafile
Download the latest release, as of this it is llamafile v0.10.5
Step 2:
Go to https://huggingface.co/models
Search for qween3
Click on pramodlohra/Qween3_4B_thinking_finetune
@judero01col
judero01col / Service KMS.md
Last active August 12, 2026 09:13
Volume License Activation Key Service - KMS

Find Available Target Editions

DISM.exe /Online /Get-TargetEditions

Convert Server Standard 2019 Evaluation to Server Standard 2019

DISM /online /Set-Edition:ServerStandard /ProductKey:N69G4-B89J2-4G8F4-WWYCC-J464C /AcceptEula

How To Activate

slmgr /ipk XXXXX-XXXXX-XXXXX-XXXXX-XXXXX
slmgr /skms [server]:[port]
slmgr /ato

@dnllu
dnllu / mssql-schema-dump.md
Created November 25, 2024 02:09 — forked from odan/mssql-schema-dump.md
Automate Your Database Schema Scripting with C# and SMO

Exporting SQL Server database structure into SQL script files

Scripting your SQL Server database schema is one such task that can benefit significantly from automation. Using C# and SQL Server Management Objects (SMO), you can easily generate scripts for your database schema and data.

Automating database scripting ensures that your schema and data scripts are always up-to-date and reduces the risk of human error. It is particularly useful for version control, backups, and migration tasks.

By integrating it into your workflow, you can significantly enhance your database management processes.

@abstractart
abstractart / books.md
Last active August 12, 2026 09:06
Free Programming Ebooks - O'Reilly Media. Codeship free ebooks here - https://bit.ly/2oQ0knQ