Use Supabase with Python

<$Partial path="quickstart_db_setup.mdx" />

<StepHikeCompact.Details title="Create a Python app with Flask">

Create a new directory for your Python app and set up a virtual environment.

</StepHikeCompact.Details>

<StepHikeCompact.Code>

  ```bash name=Terminal
  mkdir my-app && cd my-app
  python3 -m venv venv
  source venv/bin/activate
  ```

</StepHikeCompact.Code>

The fastest way to get started is to use Flask for the web framework and the `supabase-py` client library which provides a convenient interface for working with Supabase from a Python app.

Install both packages using pip.

</StepHikeCompact.Details>

<StepHikeCompact.Code>

  ```bash name=Terminal
  pip install flask supabase
  ```

</StepHikeCompact.Code>

Create a `.env` file in your project root and populate it with your Supabase connection variables:

<ProjectConfigVariables variable="url" />
<ProjectConfigVariables variable="publishable" />


</StepHikeCompact.Details>

<StepHikeCompact.Code>

  <$CodeTabs>

    ```text name=.env
    SUPABASE_URL=<SUBSTITUTE_SUPABASE_URL>
    SUPABASE_PUBLISHABLE_KEY=<SUBSTITUTE_SUPABASE_PUBLISHABLE_KEY>
    ```

  </$CodeTabs>

  <$Partial path="api_settings_steps.mdx" variables={{ "framework": "", "tab": "" }} />

</StepHikeCompact.Code>

Install the `python-dotenv` package to load environment variables:

```bash
pip install python-dotenv
```

Create an `app.py` file and add a route that fetches data from your `instruments` table using the Supabase client.

</StepHikeCompact.Details>
<StepHikeCompact.Code>

  ```python name=app.py
  import os
  from flask import Flask
  from supabase import create_client, Client
  from dotenv import load_dotenv

  load_dotenv()

  app = Flask(__name__)

  supabase: Client = create_client(
      os.environ.get("SUPABASE_URL"),
      os.environ.get("SUPABASE_PUBLISHABLE_KEY")
  )

  @app.route('/')
  def index():
      response = supabase.table('instruments').select("*").execute()
      instruments = response.data

      html = '<h1>Instruments</h1><ul>'
      for instrument in instruments:
          html += f'<li>{instrument["name"]}</li>'
      html += '</ul>'

      return html

  if __name__ == '__main__':
      app.run(debug=True)
  ```

</StepHikeCompact.Code>

Run the Flask development server, go to http://localhost:5000 in a browser and you should see the list of instruments.

</StepHikeCompact.Details>

<StepHikeCompact.Code>

  ```bash name=Terminal
  python app.py
  ```

</StepHikeCompact.Code>