How to catalogue my library

Hello! I would like to catalogue my library (I estimate in the low thousands but I am unsure of the precise number). I would like to keep tracks of several things, from the "obvious" like author, title, publisher, edition, to more personal like "when"/"where" did I get it. Was it a gift? Is a lucky find from that one trip to Paris, etc.

What's the best way to go about it? A physical collections of cards ? An app? I would like it to be selfhosted (maybe using sqlite as a backend?)

Any idea, suggestion or anything (including your experience doing something similar!) is welcome!