Why do we need a database-based filesystem.

Note 1: there is a small TLMC-based demo at the end of this post, I recommend to check it out.
Note 2: these ideas are neither original nor new. I'm fairly sure there exist similar thoughts in written form from 20 years ago and at least three abandoned prototypes of this kind.

There are no good browsers left.

I actually intended to make this post a year or two ago, but then kept putting it off. Now I stopped doing that, so here you are.
What is this about? I don't mean to criticize how bloated the browsers have became, even if it's true. I don't mean to write about how Firefox always shuffles UI elements around or how Chrome spies on its users. Just the very simple, most basic thing. Fonts and font rendering.
Make sure to set your browser page zoom to 100% to avoid browser scaling image distortions.

Here's a tiny piece of html for this test.

TLMC v.20 PRE-RELEASE post

The bad news: v.20 is still several months away.
The good news: v.20 is only several months away.
This is NOT YET a release, but we are fairly close. Here's how you can help:

Booth.pm corrupts your downloads.

If you ever bought direct downloads from them make sure to check that your files are error-free, especially if your downloads were slow.

Today I noticed that half of the files in four free albums by "クロネコラウンジ" did not decode properly. I redownloaded them all and one of the new files was still broken, but another attempt got me a good version. It was the only file that took about two minutes to get (today's first attempt), compared to several seconds for the rest, which suggests that under heavy load the file-serving part of their webmonkey code hiccups and starts sending you wrong file parts. Looking at the broken files in hexeditor you would notice content starts repeating in some random place (the starting position of the first part that gets repeated is aligned at 1 MiB boundary).

Princess Connect

Important notice 1: TLMC pre-release post soon(tm), the torrent several weeks after that post. Don't ask when, it's being worked on.
Important notice 2: Princess Connect Re:Dive [global] is available both in "32-bit" (ARMv7) and "64-bit" (ARM64) versions, don't listen to anyone claiming otherwise. Just visit some direct-from-google downloader like this, and pick SG Grand Prime (for 32) or SG Note 9 (for 64).
Important notice 3: Leapdroid won't run PCRD (some OpenGL surface issues). Bluestacks emulator, which I saw being recommended by many, contains a metric shitton of malware out of the box, be advised.

Just a short observation - if you feel like peeking at exact values the game uses internally, you should view its db (which is located in "files/manifest" app settings subdirectory; the one with the sqlite header). If, for any reason, you just want to refer to some data there without exporting it yourself, you may use this dump. I'm not sure I'll be sticking with the game for a long time, so I can't promise regular updates yet.

Based on the current db the game will be officially released on 19 Jan 2021 and clan battles will start on 10 Feb 2021.
First "focused gacha"' will be rateup for Djeeta.

20 Feb 2021 edit: Stopped updating the db dump on github.
The game turned out to be pay-to-win trash, wouldn't recommend it to anyone.