Kin Shah TheRockStarDBA

Falsehoods programmers believe about time

This is a compiled list of falsehoods programmers tend to believe about working with time.

Don't re-invent a date time library yourself. If you think you understand everything about time, you're probably doing it wrong.

Falsehoods

There are always 24 hours in a day.
February is always 28 days long.
Any 24-hour period will always begin and end in the same day (or week, or month).

Python

This is my recommended Python setup, as of Fall 2022. The Python landscape can be a confusing mess of overlapping tools that sometimes don't work well together. This is an effort to standardize our approach and environments.

Tools and helpful links:

Python docs: https://docs.python.org/3/
Python Standard Library: https://docs.python.org/3/library/index.html - Start here when you're trying to solve a specific problem
pip: https://pip.pypa.io/en/stable/ - Python's standard package installer, included with the language itself
pipx: https://pipxproject.github.io/pipx/ - Global script installer, built on top of pip

log4j RCE Exploitation Detection

You can use these commands and rules to search for exploitation attempts against log4j RCE vulnerability CVE-2021-44228

Grep / Zgrep

This command searches for exploitation attempts in uncompressed files in folder /var/log and all sub folders

sudo egrep -I -i -r '\$(\{|%7B)jndi:(ldap[s]?|rmi|dns|nis|iiop|corba|nds|http):/[^\n]+' /var/log

(After cloning the wiki locally)

Adding Images to a GitHub Wiki Page

Add images to an images directory (or subdirectory below it) in your wiki repo.
In wiki page markup embed an image with this link format:

[[/images/path/to/image.ext|ALT TEXT]]

	WITH ntiles AS (
	SELECT
	id,
	height,
	weight,
	gender,
	country,
	favorite_color,
	disease,
	NTILE(5) OVER (PARTITION BY gender, country, favorite_color ORDER BY height) as height_ntile

	#!/usr/bin/env python3


	import argparse
	import sys
	import mmap
	import logging

	from collections import defaultdict

	function Test-FileHash {
	<#
	.Synopsis
	This is a simple file hash comparison tool that writes to Windows Events when changes are detected

	.Description
	This is a simple file hash comparison tool that writes to Windows Events when changes are detected

	.PARAMETER FilePath
	The path to the file to hash and compare

	"""An example of a cache decorator."""

	import json
	from functools import wraps
	from redis import StrictRedis


	redis = StrictRedis()

	def cached(func):

	REGION=eu-west-1
	VER=1.7.3
	RUNTIME=python3.7

	docker run -v $(pwd):/out -it lambci/lambda:build-$RUNTIME \
	pip install scrapy==$VER -t /out/build/scrapy/python

	cd build/scrapy
	zip -r ../../scrapy.zip python/
	cd ../..