• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space

Database Schema

H

hagig

Chevereto Member
I'm querying the database directly to retrieve a list of uploaded images, problem is the schema doesn't currently have a mapping between a thumbnail and full-sized version of an image. Would you be able to modify the schema to support this?

I'm not using the latest version yet, but I think you added support for three image sizes, so I guess a more general solution would be to add a table for upload info, and have columns for the 3 variant image ids, plus other info like the upload timestamp?
 
A mapping is not needed because filename.ext thumb version will always be filename.th.ext no matter where is hosted. That table has to change eventually to support the CDN option but that will be on 3.0
 
You must log in or register to reply here.
Back
Top