Skip to content

zernonia/vista

Repository files navigation


Vista's Logo

Automatic, Animated subtitle generation for
short-form video!

View Demo · Report Bug · Request Feature


vista - automatic, animated subtitle generation for short-form video

Story

Vista is my Hackathon submission for Supabase Launch week 6. It was inspired by those animated subtitle while scrolling through Youtube Shorts, and I always wanted to play with ffmpeg, and this serves as a good opportunity!

This ends up a super challenging task:

  1. I need to run ffmpeg for video encoding, but hosting a server will required a lot of coding & maintenance, thus resorting to use ffmpeg-wasm, which could be use on modern browser that supports wasm.

  2. Perform speech-to-text is not an easy task, to speed up MVP, I've utilized AssemblyAI API for the video transcription.

  3. Because speech-to-text is an async task, I've combined Supabase Edge Function as webhook when the process is done, then use Supabase Realtime to populate the subtitle.

Supabase Usage

  1. Supabase Auth - to handle user and their storage bucket
  2. Supabase DB - to store projects data
  3. Supabase Storage - to store user's video (with policies)
  4. Supabase Realtime - to populate the UI anytime when subtitle is ready
  5. Supabase Edge Function - trigger AssemblyAI transcription, and act as webhook

🚀 Features

  • 🤩 Free
  • 📖 Open-Source

🔨 Built With

🌎 Setup

Prerequisites

Yarn

  • npm install --global yarn

Development

  1. Clone the repo
    git clone https://github.com/zernonia/vista.git
  2. Install NPM packages
    cd vista
    yarn install
  3. Set up .env (check .env.example)
  4. Run local development instance
    yarn dev

Supabase Database

create table users (
  id uuid default uuid_generate_v4() primary key,
  updated_at timestamp default now(),
  username text,
  full_name text,
  avatar_url text
);

create table projects (
  id uuid default uuid_generate_v4() primary key,
  user_id uuid references users (id),
  created_at timestamp default now(),
  video_key text,
  transcription_id text,
  words ARRAY,
  title text,
  config json
);


create or replace function public.handle_new_user()
  returns trigger as $$
  begin
    insert into public.users (id, avatar_url, username)
    values (new.id, new.raw_user_meta_data->>'avatar_url', new.raw_user_meta_data->>'user_name';
    return new;
  end;
  $$ language plpgsql security definer;


create trigger on_auth_user_created
  after insert on auth.users
  for each row execute procedure public.handle_new_user();

➕ Contributing

Contributions are what make the open source community such an amazing place to be learn, inspire, and create. Any contributions you make are greatly appreciated.

  1. Fork the Project
  2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
  3. Commit your Changes (git commit -m 'Add some AmazingFeature')
  4. Push to the Branch (git push origin feature/AmazingFeature)
  5. Open a Pull Request

Acknowledgement

  1. Nuxt 3 - Awesome framework
  2. Supabase - Super easy setup (as always)

Author

Also, if you like my work, please buy me a coffee ☕😳

Logo

🔥 Contributors

📜 License

Distributed under the MIT License. See LICENSE for more information.