Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Store logos in SQLite database #465

Open
LukasKnuth opened this issue Jul 19, 2024 · 0 comments
Open

Store logos in SQLite database #465

LukasKnuth opened this issue Jul 19, 2024 · 0 comments

Comments

@LukasKnuth
Copy link

Currently, logos uploaded or imported from the web are stored on-disk under /var/www/html/images/uploads/logos. This means that you'll need to mount that directory (If thats the only directory thats relevant) with the host filesystem, otherwise logos will be lost if data is reset.

I have a setup already where I use Litestream to live-replicate the SQLite Database to a backup system. I propose you also store the uploaded images in the SQLite database (as Blobs), which would make my life easier and the SQLite database would actually be the single source of truth (if I'm not overlooking anything).

Since these are usually pretty small images, this doesn't seem too silly to me. What are your thoughts?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant