---
title: Developed web analytics platform
description: ""
lang: en
date: 2013-05-01T12:00:00.000Z
tags:
  - "Language: PHP"
  - Databases
---

**stealth startup** · Lead Developer

for 6 months in early 2010s

## What I did

- Designed and developed a system for tracking visits, clicks and leads for affiliate programs
- Zero-effort integration: any e-commerce site could gain affiliate functionality with a couple of hooks

## What I achieved

- Besides project completion, I made an algorithm that coarsens data depending on the server load
- The bigger your site is, the coarser the data (up to a limit), so response time and resource consumption stayed near-constant
- We successfully processed statistics with mixed precision after collection
- Data scientists probably do it every day now, but in the early 2010s they hadn’t been invented yet
- The idea was inspired by time dilation in EVE Online

## What I learned

- How to respond fast
- Data structures are not holy artifacts
- Dirty data is better than no data at all

## Skills

[PHP](/skill/php/), Engineering Management, [System
Design](/skill/system-design/), [PgSQL, MariaDB, SQLite](/skill/sql-databases/),
Redis, Valkey, Memcached, TypeScript & JavaScript

## Tags

[Language: PHP](/tag/php/), [Databases](/tag/databases/)