Robert Smith robsmith1776

Mac install Nerd Font (Fire code)

brew cask
brew tap homebrew/cask-fonts 
brew install font-fira-code
brew install font-Fira-Code-nerd-font
brew install font-hack-nerd-font

Create UNLOGGED table. This reduces the amount of data written to persistent storage by up to 2x.
Set WITH (autovacuum_enabled=false) on the table. This saves CPU time and IO bandwidth on useless vacuuming of the table (since we never DELETE or UPDATE the table).
Insert rows with COPY FROM STDIN. This is the fastest possible approach to insert rows into table.
Minimize the number of indexes in the table, since they slow down inserts. Usually an index on time timestamp with time zone is enough.
Add synchronous_commit = off to postgresql.conf.
Use table inheritance for fast removal of old data:

brew cask
brew tap homebrew/cask-fonts 
brew install font-fira-code
brew install font-Fira-Code-nerd-font
brew install font-hack-nerd-font

title	author	date	source	notoc
LDAP Search Filter Cheatsheet	Jon LaBelle	January 4, 2021	https://jonlabelle.com/snippets/view/markdown/ldap-search-filter-cheatsheet	true

	FROM python:3-alpine

	# install requirements for psycopg2
	RUN apk update && apk add -u \
	postgresql-dev \
	gcc \
	python3-dev \
	musl-dev

	RUN pip3 install psycopg2

	with table_stats as (
	select psut.relname,
	psut.n_live_tup,
	1.0 * psut.idx_scan / greatest(1, psut.seq_scan + psut.idx_scan) as index_use_ratio
	from pg_stat_user_tables psut
	order by psut.n_live_tup desc
	),
	table_io as (
	select psiut.relname,
	sum(psiut.heap_blks_read) as table_page_read,

	import rds_config
	import mysql.connector
	import csv


	connection = None

	# create connection to MySQL database
	try:
	connection = mysql.connector.connect(user=rds_config.db_username,

	###########################################################
	# How to NEVER use lambdas. An inneficient and yet educa- #
	# tonal [sic] guide to the proper misuse of the lambda #
	# construct in Python 3.x. [DO NOT USE ANY OF THIS EVER] #
	# original by (and apologies to): e000 (13/6/11) #
	# now in Python 3 courtesy of: khuxkm (17/9/20) #
	###########################################################

	## Part 1. Basic LAMBDA Introduction ##
	# If you're reading this, you've probably already read e000's

	#Systemd - How to read live-tail logs of multiple services with journalctl

	sudo journalctl --follow _SYSTEMD_UNIT=docker.service + _SYSTEMD_UNIT=apache2.service