Discover gists

Download a McGraw Hill Education eTextbook

If you purchase a textbook from McGraw Hill, the website to view it is clunky and only works on some devices. You can't go to specific page numbers, the search is super slow, etc. That's why I wrote this script to download the textbook as an ePub file for your own viewing.

Using this script is 100% legal. McGraw Hill publicly hosts their ebooks online in order for their web client to download it. Moreover, to use it, you must already have purchased the book you would like to download, so it is legally yours to use as you please. However, it IS illegal to use this for piracy purposes. DO NOT DISTRIBUTE ANY TEXTBOOKS YOU DOWNLOAD USING THIS SCRIPT.

PostgreSQL is Enough

Background and Cron Jobs

Intro

The below is a breakdown / bird's eye view of how a sparse-array backed ECS like EnTT or Shipyard works.

Please see the thanks and references at the bottom - without their help I would not have been able to share this breakdown with you... everything here is really just notes and rephrasing of what they've written already :)

Also, these notes do not cover archetype systems (like unity) nor adaptations of archetypes (like in Flecs). Though there's a couple comparative footnotes at the end.

Here we go!

Git Commit Freeze Due to GPG Lock Issues

If you encounter a problem where you cannot commit changes in Git – neither through the terminal nor via the GitHub Desktop application – the issue might be a freeze during the Git commit process. This is often caused by GPG lock issues. Below is a concise and step-by-step guide to resolve this problem.

Solution Steps

1. Check for GPG Lock Messages

Open your terminal and try to perform a GPG operation (like signing a test message). If you see repeated messages like gpg: waiting for lock (held by [process_id]) ..., it indicates a lock issue.

Anti-hype LLM reading list

Goals: Add links that are reasonable and good explanations of how stuff works. No hype and no vendor content if possible. Practical first-hand accounts of models in prod eagerly sought.

Foundational Concepts

	This is gist.
	There are many like it, but this one is mine.
	It is my life.
	I must master it as I must master my life.
	Without me gist is useless.
	Without gist, I am useless.

	/**
	* Copyright (c) 2023 Jacob Martin
	*
	* Permission is hereby granted, free of charge, to any person obtaining a copy
	* of this software and 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:

	/*
	* various methods to strip whitespace from text
	* (aka. despace, leftpack, copy_if)
	*
	* 'whitespace' is considered the following bytes:
	* 0x09 - tab
	* 0x20 - space
	* 0x0A - line feed
	* 0x0D - carriage return
	*/

	/**
	* Place this to ./src/scripts/bump-payload.ts
	* Then in your package.json add script:
	* "bump-payload": "tsx ./src/scripts/bump-payload.ts ./package.json && pnpm i"
	* Run `pnpm bump-payload`
	*/

	import { execSync } from 'child_process';
	import fs from 'fs';
	import path from 'path';

	USE [SQLdmRepository];
	GO

	-- Declare variables to store the names of the table and column currently being processed.
	DECLARE @TableName NVARCHAR(MAX);
	DECLARE @ColumnName NVARCHAR(MAX);

	-- Declare a cursor to iterate over all textual columns in the database.
	-- This cursor selects the name of the table and column from the system catalog views.
	-- Only user tables (xtype = 'U') and specific textual column types are considered.