M. Clay Johns johnsmclay

I hereby claim:

To claim this, I am signing this object:

When backing up databases/table to files I needed to have them encrypted for security and compliance. But there were a few concerns:

I didn't want the file to be in plaintext, ever.
I didn't want that same user to be able to decrypt the file later in case the account was compromised.

So, Pub/Priv is great for #2. Unfortunately, Pub/Priv is not made for large files, therefor I decided follow this process:

	{"type": "Feature", "properties": {"hash": "77cb1e83241b3605", "number": "357", "street": "DUNK ROAD", "unit": "", "city": "Junction", "district": "", "region": "TX", "postcode": "76849", "id": 1}, "geometry": {"type": "Point", "coordinates": [-99.6629619, 30.4222687]}}
	{"type": "Feature", "properties": {"hash": "23b3bc33ec0cd357", "number": "811", "street": "ELM STREET", "unit": "", "city": "Junction", "district": "", "region": "TX", "postcode": "76849", "id": 2}, "geometry": {"type": "Point", "coordinates": [-99.76931, 30.48628]}}
	{"type": "Feature", "properties": {"hash": "123373ff2950f1eb", "number": "193", "street": "BURR OAK TRAIL", "unit": "", "city": "Harper", "district": "", "region": "TX", "postcode": "78631", "id": 3}, "geometry": {"type": "Point", "coordinates": [-99.3498552, 30.3263169]}}
	{"type": "Feature", "properties": {"hash": "3dd222f08b5ac18f", "number": "102", "street": "BLUEBONNET DRIVE", "unit": "", "city": "Junction", "district": "", "region": "TX", "postcode": "76849", "id": 4}, "geome

	# REFERENCES:
	# how-to: https://blog.swwomm.com/2021/06/send-journald-to-cloudwatch-logs-with.html
	# Docs: https://vector.dev/docs

	# Change this to use a non-default directory for Vector data storage:
	# data_dir: "/var/lib/vector"

	sources:
	journald_all:
	type: "journald"

	# Need to run this as Administrator
	# To turn on Hyper-V if necessary, see:
	# https://docs.microsoft.com/en-us/virtualization/hyper-v-on-windows/quick-start/enable-hyper-v

	Import-Module Hyper-V

	# A hashtable of NIC/vLAN names and vLAN IDs you want to create NICs for
	$vlans=@{ "Main" = 1;
	"Public" = 2;
	"Public 2" = 3;

	DROP TABLE IF EXISTS `clay_sandbox`.`column_stats`;
	CREATE TABLE `clay_sandbox`.`column_stats` (
	`database` varchar(64) NOT NULL,
	`table` varchar(64) NOT NULL,
	`column` varchar(64) NOT NULL,
	`position_in_table` bigint(20) SIGNED NOT NULL,
	`nonnull_vals` bigint(20) DEFAULT NULL,
	`nonmnull_pctg` decimal(7,5) DEFAULT NULL,
	`sum_val` decimal(32,16) DEFAULT NULL,
	`min_val` decimal(32,16) DEFAULT NULL,