ASMRtist Catalog

Last update: Friday, 16 Aug 2024
Dev: anon
Tools: Python 3.12, SQLite 3.47, Vanilla JS
Link: https://asmrtistcatalog.ca/
Repo:

>>/wdg/101915586 >>101929673 2024-08-16 20:31:00

Live/done; taking suggestions

First coding project in a while, was fun. Basically just a search index for ASMR youtube channels. Spent a while writing and rewriting the specifics of how the search actually worked on the backend. Eventually decided on a single contentless FTS index with columns for video title, description, channel, and tags, backed up by a few tables. An extra script checks channels for new uploads every 2 minutes, with which channels checked being decided by a weighting based on how long since the channel was checked, how long since they uploaded, and the average time between uploads in the last year. The frontend is pretty simple; just some HTML files I format values into, with some vanilla JS to do infinite scrolling.

Currently has 738.5k videos indexed from 3896 channels, with 750k unique tags used 9.67M times. The descriptions are stored compressed, which keeps the DB size to 1.14 GB.

I actually don't really care for ASMR all that much, but it made for an easy target for a project. The code's easily reusable if I ever (for some stupid reason) decide to make another site for some other topic. I've got the domain for a year and it only cost me $0.86, so fuck it, it's public.