Hacker News new | ask | show | jobs
by JodieBenitez 830 days ago
Mildly related:

I wanted to learn some Go and I thought "I will just reimplement my music library with it". So basically the task was to write a backend API that maintains a database of music files with associated ID3 tags, and so on.

The original backend is Python over SQLite, which works fine enough.

As I started to reimplement the functionalities, I though "why should I use a database anyway ?" and started just pushing the ID3 tags a list of structs. It turns out that having an in-memory list of structs for 50k music files is not a problem at all for a raspberry pie. It's not that musch memory and it's fast enough to create so that I don't have to persist it and it's fast enough to scan for a search.

In the end, I may use SQLite anyway because FTS5 is just so good, but yes... sometimes you don't need a database.