Discover gists

Performance Analysis Tools

Performance Analysis Tools
Benchmarks
- pytest
- Direct benchmark runner
Manual perf counters
gdb scripts
torch.autograd.profiler

This gist lists challenges you run into when building offline-first applications based on IndexedDB, including open-source libraries like Firebase, pouchdb and AWS amplify (more).

Note that some of the following issues affect only Safari. Out of the major browsers, Chrome's IndexedDB implementation is the best.

Backing file on disk (WAL file) keeps growing (Safari)

When this bug occurs, every time you use the indexeddb, the WAL file grows. Garbage collection doesn't seem to be working, so after a while, you end up with gigabytes of data.

Random exceptions when working with a large number of indexeddb databases (Safari)

Steps:

Add Activation Code
Click Manage Proxy
Click Manual proxy
Add localhost in hostname

Activation Code:

I2A0QUY8VU-eyJsaWNlbnNlSWQiOiJJMkEwUVVZOFZVIiwibGljZW5zZWVOYW1lIjoiVU5JVkVSU0lEQURFIEVTVEFEVUFMIERFIENBTVBJTkFTIiwiYXNzaWduZWVOYW1lIjoiVGFvYmFv77yaSkVU5YWo5a625qG25r+AIOa0u+W3peS9nOWupCAgcmVuIHpodW4gZGlhbiBtaW5n77yBIiwiYXNzaWduZWVFbWFpbCI6IlJvYmJ5X1dlbmlnZXJAb3V0bG9vay5jb20iLCJsaWNlbnNlUmVzdHJpY3Rpb24iOiJGb3IgZWR1Y2F0aW9uYWwgdXNlIG9ubHkiLCJjaGVja0NvbmN1cnJlbnRVc2UiOmZhbHNlLCJwcm9kdWN0cyI6W3siY29kZSI6IkRQTiIsInBhaWRVcFRvIjoiMjAyNC0xMC0xNCIsImV4dGVuZGVkIjpmYWxzZX0seyJjb2RlIjoiREIiLCJwYWlkVXBUbyI6IjIwMjQtMTAtMTQiLCJleHRlbmRlZCI6ZmFsc2V9LHsiY29kZSI6IlBTIiwicGFpZFVwVG8iOiIyMDI0LTEwLTE0IiwiZXh0ZW5kZWQiOmZhbHNlfSx7ImNvZGUiOiJJSSIsInBhaWRVcFRvIjoiMjAyNC0xMC0xNCIsImV4dGVuZGVkIjpmYWxzZX0seyJjb2RlIjoiUlNDIiwicGFpZFVwVG8iOiIyMDI0LTEwLTE0IiwiZXh0ZW5kZWQiOnRydWV9LHsiY29kZSI6IkdPIiwicGFpZFVwVG8iOiIyMDI0LTEwLTE0IiwiZXh0ZW5kZWQiOmZhbHNlfSx7ImNvZGUiOiJETSIsInBhaWRVcFRvIjoiMjAyNC0xMC0xNCIsImV4dGVuZGVkIj

References:

Steps

Install Termux on android device.
Find Termux username.

	# create a local .env file with the following 4 properties:
	#
	# MYSQL_DATABASE=<something>
	# MYSQL_USER=<something>
	# MYSQL_PASSWORD=<something>
	# MYSQL_ROOT_PASSWORD=<something>
	#
	# Note: I have had a LOT of issues working with anything newer then Docker Desktop v4.26.1
	# If you're on something newer, then double check against this release.
	#

	## Pre-requisite: You have to know your last commit message from your deleted branch.
	git reflog
	# Search for message in the list
	# a901eda HEAD@{18}: commit: <last commit message>

	# Now you have two options, either checkout revision or HEAD
	git checkout a901eda
	# Or
	git checkout HEAD@{18}

	#!/usr/bin/env ruby

	# this scripts acts as a wrapper for a little daemon that reads a fifo;
	#
	# If called without allready running it starts a background daemon and
	# downloads the argument, then proceeds to watch the fifo for more.
	#
	# We esnure that the script is only running once and only one dl at a time.

	FIFO = "/home/ha/.ytfifo"

	-- A simply-typed lambda calculus, and a definition of normalisation by
	-- evaluation for it.
	--
	-- The NBE implementation is based on a presentation by Sam Lindley from 2016:
	-- http://homepages.inf.ed.ac.uk/slindley/nbe/nbe-cambridge2016.pdf
	--
	-- Adapted to handle terms with explicitly typed contexts (Sam's slides only
	-- consider open terms with the environments left implicit/untyped). This was a
	-- pain in the ass to figure out.

	SPC
	SPC: find file
	, switch buffer
	. browse files
	: MX
	; EX
	< switch buffer
	` eval
	u universal arg
	x pop up scratch