Thanks! It still needs polishing, but overall I like how it works.

MMOVN 👀

I really like it for everything (except the metallic noise), but somehow it got replaced with HHKB.

The switches are mounted on a thick metal plate. The plate is simply sandwiched between two plastic parts of the case. So when I quickly press hotkeys, the plate makes a loud metallic noise, which can be quite annoying.

If anyone is wondering why I choose SQLite, there are two reasons:
1. I’m too lazy to set up MariaDB or Postgres.
2. Prisma is focused on Postgres, so I was curious how difficult it’d be to work with a different DB.

I have no plans for the site, so I’ll delete it and create a new one from scratch. And then another one and another until I figure out how to best use Fastify with Prisma.

So, In total I created:
- server.ts with a little over 100 lines of code
- prisma.ts - less than 50 lines
- seed.ts - less than 50 lines
- schema.prisma - near 50 lines
- a bunch of views.pug - less than 20 lines each

I haven’t tried it yet, but it seems to me that I can convert Prisma schema to Ajv schemas using ts-json-schema-generator.

Creating a seed is also very simple. Just one function that is attached to the client and run with a single command.

That’s it. Now I have an empty BD with TS types that I can use on the site. I mean, use Prisma.PostCreateInput as a form body request, for example.

With Prisma I just need to write the BD schema, migrate it to TS types with one command, and init the Prisma client with another command. For the client I only need two packages: @prisma/adapter-better-sqlite3 and @prisma/client, in my case.

There’s also a built-in request validator based on Ajv that uses JSON schemas, and with @fastify/formbody I don’t need to write headers for form requests.

Fastify has @fastify/view which allows to integrate HTML template engines with just one line. And it’s super easy to use, just return reply.view with arguments and that’s it.

Fastify and Prisma are new things to me, so I can’t really say how good they are. I also can’t say how difficult it’d be to build something much bigger, or how expensive it’d be to maintain with these tools, but so far, so good.

It’s planned to be a Metroid-like platformer where collecting blue cubes gives the character new abilities. The video only shows two of the four planed abilities: dash and gravity shift.