Custom software, built around your business.

1const clamp = (v, lo, hi) => Math.min(hi, Math.max(lo, v));2const lerp = (a, b, t) => a + (b - a) * t;3 4/** Smoothstep: eases in and out, and is flat at both ends. */5function smoothstep(edge0, edge1, x) {6  const t = clamp((x - edge0) / (edge1 - edge0), 0, 1);7  return t * t * (3 - 2 * t);8}9 10export function tween(from, to, ms, onFrame) {11  const start = performance.now();12 13  return function step(now) {14    const t = clamp((now - start) / ms, 0, 1);15    onFrame(lerp(from, to, smoothstep(0, 1, t)));16    if (t < 1) requestAnimationFrame(step);17  };18}

1precision highp float;2 3uniform vec2  uResolution;4uniform float uTime;5 6void main() {7  vec2 uv = gl_FragCoord.xy / uResolution;8  vec2 p  = uv * 2.0 - 1.0;9 10  float r    = length(p);11  float wave = sin(r * 12.0 - uTime * 2.0) * 0.5 + 0.5;12 13  vec3 colour = mix(vec3(0.06), vec3(0.85, 0.25, 0.18), wave);14  gl_FragColor = vec4(colour, 1.0);15}

1create table orders (2  id          bigserial   primary key,3  customer_id bigint      not null references customers (id),4  status      text        not null default 'pending',5  total_cents integer     not null check (total_cents >= 0),6  placed_at   timestamptz not null default now()7);8 9create index orders_recent_idx on orders (customer_id, placed_at desc);10 11select c.name,12       count(o.id)             as orders,13       sum(o.total_cents) / 100.0 as revenue14  from customers c15  join orders o on o.customer_id = c.id16 where o.placed_at >= now() - interval '30 days'17 group by c.name18 order by revenue desc19 limit 10;