3 ms·
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 th
by JodieBenitez 3y 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.