Discover gists

It's not so hard to find sample data and data sources to use for interesting side-projects, or just for practicing writing SQL.

In-product sample data

Most DBMSes come with sample databases. You can write lots of interesting queries against them, and usually a tutorial accompanies the database in the documentation.

Documentation for Microsoft SQL Server's samples ** Microsoft's sample database GitHub, which includes the Contoso database
For MySQL:
- there's the Employees sample database
and the Sakila sample database

Forward GnuPG agent from macOS to Linux

On the remote machine

Run gpg once as your to create the directory structure

gpg --list-keys

For headless systemd based hosts

[I.11 Collected Common Language Specification rules][§I.11]

The complete set of CLS rules are collected here for reference. Recall that these rules apply only to "externally visible" items—types that are visible outside of their own assembly and members of those types that have public, family, or family-or-assembly accessibility. Furthermore, items can be explicitly marked as CLS-compliant or not using the System.CLSCompliantAttribute. The CLS rules apply only to items that are marked as CLS-compliant.

CLS rules apply only to those parts of a type that are accessible or visible outside of the defining assembly. ([§I.7.3])
Members of non-CLS compliant types shall not be marked CLS-compliant. ([§I.7.3.1])
Boxed value types are not CLS-compliant. ([§I.8.2.4].)

Document stores in PostgreSQL

Notes for software engineering meeting presentation

What

mid to late 2000s: appearance of Document stores / NoSQL databases such as Mongo, Couch
Relational DBs now have support for document data: JSON in MySQL, JSON and JSONB in PostgreSQL
Focus on JSONB in Postgres (most full featured)

Compiling a standalone executable using modern JavaScript/TypeScript runtimes

We have the same code working using node, deno, and bun.

E.g.,

bun run index.js

NOTE

These are NOT product / license keys that are valid for Windows activation.
These keys only select the edition of Windows to install during setup, but they do not activate or license the installation.

Index

Windows 11
RTM Generic Keys

	000000 Officially Xerox
	000001 SuperLAN-2U
	000002 BBN (was internal usage only, no longer used)
	000003 XEROX CORPORATION
	000004 XEROX CORPORATION
	000005 XEROX CORPORATION
	000006 XEROX CORPORATION
	000007 XEROX CORPORATION
	000008 XEROX CORPORATION
	000009 powerpipes?

	// PATHS
	public const string DEST_MASTER = "";
	public const string PATH_MASTER = "";
	public static string DEST_LOG = "";
	public const string LANGUAGE = "English";

	// MAXIMUMS
	public const int MAX_SPECIES_ID = 1025;
	public const int MAX_MOVE_ID = 919;
	public const int MAX_ABILITY_ID = 310;

	local M = {
	"neoclide/coc.nvim",
	branch = "master",
	build = "yarn install --frozen-lockfile",
	}

	M.config = function()
	-- Some servers have issues with backup files, see #649
	vim.opt.backup = false
	vim.opt.writebackup = false

	<?php

	/**
	* Below is an the extended Filament resource your tenant panel resources
	* will have to extend so that the queries are scoped properly.
	*/

	namespace App\Filament;

	use Filament\Resources\Resource;