Isaac Adewumi prettyirrelevant

Rotki Commits by prettyirrelevant

1st Stint (Apr 2022 - Apr 2023)

decode curve deposits & withdrawals via curve zap deposit contracts
reset last_avatar_update column when avatars cache is cleared. The last_avatar_update column is no longer nullable.
feat: add cache invalidation for icons & avatars
add endpoint to get all evm chains
fix failed tests from bugfixes
change binance savings & kraken staking api response

Support Engineer Task: Submissions Comparison

Comparison of three submissions against the Support Engineer Task requirements. Each submission was reviewed line-by-line, tracing every execution path for correctness, logic errors, security issues, and adherence to the spec.

Candidate	Repository	Tech Stack	Issues Found
lady-thee	helios-form	Python, FastAPI, MongoDB (Beanie ODM)	58
TijanAyo	formplus-support-engineer-task	TypeScript, Express 5, MongoDB (Mongoose), mathjs	61
ruggedwizard	support-assessment	Python, FastAPI, MongoDB (Motor)	29

support engineer, take-home assessment

task: form schema engine

build a form engine in python that processes form schemas, validates submissions, and handles schema migrations. you can optionally expose the engine through an API using django.

your engine should support three operations.

1. schema parsing and submission validation

hey, thanks for submitting the csv-to-sheets project. i've reviewed the codebase and wanted to share some feedback.

the project has a number of bugs and issues that would cause problems in real usage. there are several places where errors are silently swallowed, meaning the user would see broken or incomplete results with no indication that something went wrong. there are also code paths that would crash the app outright on certain inputs, and some logic that exists in the code but doesn't actually do anything. beyond the bugs, there are no tests anywhere in the project, which makes it hard to trust that things work correctly or to make changes safely.

i've put together a detailed technical breakdown here: https://gist.github.com/prettyirrelevant/72e37c4165230523b34c86c128307fe8

i'd recommend going through that and focusing on error handling, thinking through what happens when things fail, not just when they succeed. that's a critical skill and it's something we look for.

sqlite index benchmark for event_metrics

comparing composite indexes from rotki PR #11464 against existing single-column indexes.

indexes

baseline (existing):

CREATE INDEX idx_event_metrics_event ON event_metrics(event_identifier);
CREATE INDEX idx_event_metrics_location_label ON event_metrics(location_label);

sqlite index benchmark for event_metrics

comparing composite indexes from rotki PR #11464 against existing single-column indexes.

indexes

baseline (existing):

CREATE INDEX idx_event_metrics_event ON event_metrics(event_identifier);
CREATE INDEX idx_event_metrics_location_label ON event_metrics(location_label);

SQLite Index Benchmark: Composite vs Single-Column

Benchmark comparing composite indexes (from rotki PR #11464) against single-column indexes for the event_metrics table.

Index Configurations

Single-Column Indexes (Baseline)

CREATE INDEX idx_em_event ON event_metrics(event_identifier);
CREATE INDEX idx_em_metric_key ON event_metrics(metric_key);

Keybase proof

I hereby claim:

I am prettyirrelevant on github.
I am isaacadewumi (https://keybase.io/isaacadewumi) on keybase.
I have a public key ASDGsfNVXfD7VEWRblNosg34ofocJlNHQKv8wgwe3zwNHQo

To claim this, I am signing this object:

	#!/usr/bin/env python3
	"""
	Test max token addresses for Etherscan eth_call before HTTP 414.

	Usage: python test_etherscan_url_limit.py --api-key YOUR_KEY
	Or set ETHERSCAN_API_KEY env variable.
	"""
	import argparse
	import os
	import sys

	import math
	from pathlib import Path

	import numpy as np
	from PIL import Image
	import imageio.v3 as iio
	from pillow_heif import register_heif_opener

	register_heif_opener()