Whereisanaiforthat

• Inspired from all the confused and why memes we are building a listing directory which only lists AI tools which work a 100% of the time.
  • There are a lot of AI tools which do not work at all
  • We will use and vet all the AI tools ourselves and then list them here

Technology stack to be used

• Self Hosted supabase for storing the data and get all listing
• Flask for the backend
• Jinja2 for the templating
• Bootstrap CSS

Folder Strucutre

whereisanaiforthat/
    - app/
        - static/
          - styles.css # any custom styles needed can be added here
        - templates/
          - components/
            - footer.html
            - nav.html
            - side_nav.html
            - tool_card.html
          - home/
            - about.html
            - home.html
            - submit.html
          - base.html # Currently the only template added 
        - __init__.py
        - routes/
          - __init__.py
          - routes.py # contains all the routes of the application
        - services/
          - __init__.py
          - data_services.py # data services for the application from supabase to get the tools, tool categorries and submit tool services
    - readme.md # this file
    - requirements.txt
    - run.py # local run file
    - Dockerfile # docker file for the application
    - config.py # contains the config for the application
    - supabase_client.py # contains the supabase client for the application
    - .env # contains the environment variables for the application
    - .gitignore

Supabase table structure

create table
  public.ai_tools (
    id bigint generated by default as identity,
    created_at timestamp with time zone not null default now(),
    tool_name text null,
    tool_details text null,
    tool_core_features character varying null default ''::character varying,
    tool_tags character varying null default ''::character varying,
    tool_category character varying null default ''::character varying,
    tool_by text null,
    tool_content text null,
    updated_at timestamp without time zone null,
    constraint ai_tools_pkey primary key (id),
    constraint ai_tools_tool_name_key unique (tool_name)
  ) tablespace pg_default;