Where does local hosting start?

Question

local server

After it seemed to me a hundred times that there was no more strength to manually sort files into folders, I wanted to find a more efficient way to organize my storage (mainly consisting of media files: constantly growing personal and work photos + videos, now about 2tb ).

I'm confused: dozens of hours of searching and feeling like I'm going in circles.
I do not think that in the description of the question there is much sense to list everything that I managed to see. Rather, it's better to start by describing how I imagine the workflow:

1. I want my files to be stored locally, but with the ability to generate a URL for sharing with other users through direct links.
2. Assigning tags and searching NOT through folders/subfolders, but using queries. Those. creating a database and working with an array through the database.
3. For reliability, optional, but desirable f. ZFS structure (specially bought ECC memory))

I just want to know where to start so that I can calmly understand further. Thanks in advance for any advice.

Answer 1

Try myOwnCloud
https://ru.wikipedia.org/wiki/OwnCloud

Answer 2

Any hosting starts with organizing storage, backups, backups and communication. If the disks or the power supply are good, no zfs and ecc will save you from data loss.
Farther. It is theoretically possible to organize all this on one machine if you put it on the Internet with its bare booty and not bother with the reliability of storage, but you definitely shouldn’t do that. If we are talking about two terabytes, then it is better to rent or place your own hardware server with the appropriate disk space in the data center, ensuring that it synchronizes files with a computer via the Internet. You will get two instances of files in physically different places (plus storage reliability) and the ability to generate Internet links for one of them without the need to refer to the other. If a server or computer breaks down - transfer data from a working place, rebuild the database and continue working (although, of course, this will not be very fast).
Farther. Do not completely abandon the folders-subfolders. If you store files in one folder - at one fine moment you simply won’t be able to backup or replicate: folders will be scanned for a very long time. But it is worth transferring storage, for example, to chronological order and replicating not everything, but, for example, what has arrived on the current day (i.e., reference to time is required). So it will be convenient to back up. And paths with tags can be stored in the database.