outline.md

Outline

Files will be stored locally on the server using its own hardware.

Folders will be created to store the images more securely. Users can only perform actions on the images if they have the folder_id provided when creating a folder

Metadata (stored in psql db)

• ID
• File size
• File name
• Time stamp
• Image Dimensions

Folder Routes:

• POST /folders : Create a new folder.
• GET /folders/{folder_id} : Get folder metadata and list of images inside the folder.
• PUT /folders/{folder_id} : Update a folders metadata.
• DELETE /folders/{folder_id} : Delete a folder and it's images.

Image Routes:

• POST /images/{folder_id} : Upload an image to a specific folder.
• GET /images/{image_id} : Retrieve a specific images meta data.
• DELETE /images/{image_id} : Delete an image and its metadata.

Displaying an Image: url/uploads/folder_id/image_id

Schema:

CREATE EXTENSION IF NOT EXISTS "uuid-ossp";

CREATE TABLE IF NOT EXISTS folders (
    id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
    name VARCHAR(32) UNIQUE,
    createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE IF NOT EXISTS images (
    id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
    folderId UUID REFERENCES folders(id) ON DELETE CASCADE,
    name TEXT,
    size BIGINT,
    type TEXT,
    uploadedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);