Mark Street

Maybe we could do something like `user:mkst foo` or `platform:n64 bar` or `preset:mario baz` ?

Is there a flag to explicitly set C (rather than C++)? such that we can leverage `LanguageFlagSet` behaviour like other compilers? **edit** looks like `-nodotciscxx` might do the trick? **edit2**...

Yeh, doing something clever with diffs/deltas is beyond my IQ but definitely makes sense longer term. Postgres does compression of TEXT fields behind the scenes (around 70% from the handful...

Currently we have `Scratch.context`, so the `Preset.context` would get copied into `Scratch.context` upon creation (or loaded into the UI and then submitted as part of the new Scratch) - we...

PlayStation 10 😎

A question off the back of this is whether we create a separate "deployment" repo which contains these scripts, the production docker compose files etc... I am not sold on...

## /api/scratch/{pk}/family `/family` endpoint has been improved via https://github.com/decompme/decomp.me/pull/1559: 

## /search Added an index to help with the `/search` endpoint (was taking ~1s to perform the case-insensitive search on scratch name). BEFORE: ```py >>> qs = Scratch.objects.filter(name__icontains="foo").order_by("-creation_time")[:5] >>> print(qs.explain(analyze=True))...

## /api/platform/{id} Huge improvement on the platform query. Pulling out the num_scratches was triggering a sequential scan over the Scratch table. Adding an index on the platform means no need...

Migrating to the new, bigger + faster box you can see the average query time has reduced nicely (the migration happened around 75% of the way along the x-axis):