PChemGuy pchemguy

I am a physical chemist by day. Here, I explore my personal project ideas and interests unrelated to my job.

pchemguy / APIs

Created September 27, 2021 05:50 — forked from JohnLaTwC/APIs

Short List of APIs seen in VBA

	Private Declare Function GetCurrentProcessId Lib "kernel32" () As Long
	Private Declare PtrSafe Function GetCurrentProcessId Lib "kernel32" () As Long
	Public Declare Function Keio2 Lib "kernel32" Alias "LoadLibraryW" (ByVal lpLibFileName As String) As Long
	Public Declare Function VEEAAM2 Lib "kernel32" Alias "LoadLibraryW" (ByVal lpLibFileName As String) As Long
	Public Declare Function wspPush2 Lib "kernel32" Alias "LoadLibraryW" (ByVal lpLibFileName As String) As Long
	Declare Function GetLogicalDrives& Lib "kernel32" ()
	Declare Function GetShortPathName Lib "Kernel32.dll" Alias _
	Declare Function GetWindowsDirectory Lib "kernel32" Alias "GetWindowsDirectoryA" ( _
	Declare Function GlobalAlloc Lib "kernel32" (ByVal wFlags As Long, ByVal dwBytes As Long) As Long
	Declare Function GlobalLock Lib "kernel32" (ByVal hMem As Long) As Long

pchemguy / initialization.sql

Created July 5, 2022 05:15 — forked from jbrown123/-Recursive Queries Using Common Table Expressions.md

Creating arbitrary-depth recursive queries in SQLITE (works for any SQL compliant system) using CTEs (common table expressions)

	DROP TABLE IF EXISTS users;
	DROP VIEW IF EXISTS bp;

	CREATE TABLE users (name, cn, title, manager);
	CREATE VIEW bp AS
	-- create a CTE (common table expression)
	-- think of this as creating a temporary table that only exists during this query
	-- works somewhat like CREATE TEMPORARY TABLE bosspath(cn, path)
	WITH RECURSIVE bosspath(cn,path) AS
	(

pchemguy / modern_sql_style_guide.md

Created July 26, 2022 21:27 — forked from mattmc3/modern_sql_style_guide.md

Modern SQL Style Guide

layout	author	title	revision	version	description
default	mattmc3	Modern SQL Style Guide	2019-01-17	1.0.1	A guide to writing clean, clear, and consistent SQL.

Modern SQL Style Guide

pchemguy / gist:f20365da94e2d9382fcb5c8d909bcc16

Created June 24, 2024 12:29 — forked from rxaviers/gist:7360908

Complete list of github markdown emoji markup

People

pchemguy / win10colors.cmd

Created October 11, 2025 05:28 — forked from mlocati/win10colors.cmd

ANSI Colors in standard Windows 10 shell

	@echo off

	setlocal
	call :setESC

	cls
	echo %ESC%[101;93m STYLES %ESC%[0m
	echo ^<ESC^>[0m %ESC%[0mReset%ESC%[0m
	echo ^<ESC^>[1m %ESC%[1mBold%ESC%[0m
	echo ^<ESC^>[4m %ESC%[4mUnderline%ESC%[0m