George J. Capnias gcapnias

Boost Prompt

A prompt to boost your lazy "do this" prompts. Install with one of the buttons below.

Use

description	Beast Mode Dev

You are an agent - please keep going until the user’s query is completely resolved, before ending your turn and yielding back to the user.

You are friendly, upbeat and helpful. You sprinkle in light humor where appropriate to keep the conversation engaging. Your personality is delightful and fun, but you are also serious about your work and getting things done.

Your thinking should be thorough and so it's fine if it's very long. However, avoid unnecessary repetition and verbosity. You should be concise, but thorough.

SPEC-Driven Development Workflow

You are an AI development partner that follows a structured SPEC workflow to transform ideas into executable implementations through three sequential phases: Requirements → Design → Tasks.

Core Principles

Systematic Progression: Each phase must be explicitly approved before proceeding to the next
Living Documents: Specs are iteratively refined based on user feedback
Context Preservation: All decisions and rationale are maintained in structured documents
Implementation Focus: Tasks are exclusively coding activities that build incrementally

Setup

Create a new directory with these three files (requirements.txt, main.py, README.md)
python -m venv venv
source venv/bin/activate
pip install -r requirements.txt
python main.py
Update main() to run the example prompt chains

Upgrading PostgreSQL in Windows

The official documentation for PostgreSQL provides a guide to upgrading using pg_upgrade. However, it can be a bit like a treasure hunt with hidden traps. This gist will walk you through a clear and robust method for upgrading PostgreSQL on Windows, using the upgrade from version 14 to 16 as an example.

1. Install the New Version of PostgreSQL

Before you embark on the upgrade journey, make sure you have the new version installed. This is because the pg_upgrade utility used during the upgrade process belongs to the newer version.

To get started, visit the official download page, download the installer, and run it. A word of caution: do not overwrite the old installation, as you'll need its binaries and data for the upgrade.

This powershell script modifies the Base Image, or the Virtual Hard Disk, which the Windows Sandbox launches upon startup. It will copy the required files to the sandbox and add a registry key which will install them upon startup. By default the script will install the latest stable release of Winget. You can specify to use the latest pre-release with the -PreRelease switch.

When a new version of Winget is released, run this script again to update the installation in the sandbox to the latest version

UI/UX Front-End Resources

My personal collection of Front-End Development, User Interface Design, User Experience Design, and other Software Development resources. I began this Gist in 2021 while attending Nashville Software School as a student in the Front-End Web Designer/Developer Program. If you find any mistakes, especially broken links, DM me on Twitter: https://twitter.com/MrWryt

✴️ = Affiliate link. I receive a commission from the vendor when a purchase is made after clicking my link. Thank you!

Prototyping and Wireframing Tools

Design Systems

Why?

I recently made a fresh install of windows and all the tools I needed to develop software including git-for-windows. Unfortunatnly git-for-windows doesn't come with a packagemanager buildt in and going full cygwin seems a little overkill. After some research I ran in to this post on stackoverflow describing a way to install pacman in to git-for-windows. Unfortuntly only "most of it" worked in my case. This document attempts to describe the entire process I went through to install pacman.

Prepare

The packages in the MSYS2 repositoy seem to be packaged using zstd now and not xz as described. Obviously it would be great to use a package manager to install zstd and un-tar the files... Given that this guide is geared towards windows installs you can install 7zip and add the Modern7z plugins to unpack zstd files.

Downloading and unpacking the neccesary packages

	1. # create new .py file with code found below
	2. # install ollama
	3. # install model you want “ollama run mistral”
	4. conda create -n autogen python=3.11
	5. conda activate autogen
	6. which python
	7. python -m pip install pyautogen
	7. ollama run mistral
	8. ollama run codellama
	9. # open new terminal

	'
	' Old Microsoft Word Greek document fixer
	'
	' Copyright 2023 Diomidis Spinellis
	'
	' Licensed under the Apache License, Version 2.0 (the "License");
	' you may not use this file except in compliance with the License.
	' You may obtain a copy of the License at
	'
	' http://www.apache.org/licenses/LICENSE-2.0