Isaac Adewumi prettyirrelevant

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()

	import pandas as pd
	from decimal import Decimal


	def clean_currency(value):
	"""Removes currency symbol and commas, then converts to `Decimal`."""
	if isinstance(value, Decimal):
	return value

	value = value.replace("₦", "").replace(",", "")

	import asyncio
	import json
	from typing import Any, Dict, List, Tuple

	import aiohttp
	from bs4 import BeautifulSoup


	async def main() -> None:
	async with aiohttp.ClientSession(connector=aiohttp.TCPConnector(ssl=False)) as session: