Perlite VS til

there is a self hosted version here https://github.com/secure-77/Perlite

yes, there is a self-hosting option called perlite. Here is a link: Perlite on GitHub

I share a folder between my Obsidian vault and the folder PineDocs uses with Syncthing (because the machine that runs PineDocs is not my laptop), so as soon as I save my files the site is immediately updated, but PineDocs was not designed with Obsidian in mind, the links work but not the advanced features Obsidian offers.

On the other hand, Perlite [1] is (I never really tested it but it looks cool) designed with Obsidian in mind so maybe it supports more features.

[1] https://github.com/secure-77/Perlite

Some people create single note for each code example, like for example this TIL a repo https://github.com/jbranchaud/til`

That's more like it. This backs up the decision to add a B-Tree index for the created_at column in production. As I mentioned at the beginning of the post, adding an index like this in any production setting, but especially for a table of this size, it is important to do so concurrently and to monitor your app's health metrics during the process.

State machines are hierarchical. They can be made up of simple and composite states. Composite states have sub-states nested within them.

In all the time that I've been building and maintaining Rails apps, I've somehow never noticed that ActiveRecord attributes backed by columns with default values are nil on create.

Dump them in a github repo (like this)