Laravel Integration with Supabase

1. Create a Supabase Project:
- Go to the Supabase website and create a new project. This will give you a Postgres database and other features like authentication and APIs[1][4].

2. Set Up Laravel Project:
- Create a new Laravel project using Composer:

bash
     composer create-project laravel/laravel example-app
     

bash
     composer require laravel/breeze --dev
     php artisan breeze:install
     

php
     'pgsql' => [
         'driver' => 'pgsql',
         'url' => env('DATABASE_URL'),
         'host' => env('DB_HOST', '127.0.0.1'),
         'port' => env('DB_PORT', '5432'),
         'database' => env('DB_DATABASE', 'forge'),
         'username' => env('DB_USERNAME', 'forge'),
         'password' => env('DB_PASSWORD', ''),
         'charset' => 'utf8',
         'prefix' => '',
         'prefix_indexes' => true,
         'search_path' => 'laravel',
         'sslmode' => 'prefer',
     ],
     

ini
     DB_CONNECTION=pgsql
     DATABASE_URL=postgres://postgres:your_password@your_host:5432/your_database
     

bash
     php artisan migrate
     

bash
     php artisan serve
     

3. Connect to Supabase Database:
- Go to the Supabase dashboard and navigate to the database settings. Copy the URI connection string.
- Update the `DATABASE_URL` environment variable in your `.env` file with the Supabase URI:

ini
     DATABASE_URL=postgres://your_username:your_password@your_host:5432/your_database
     

php
     'search_path' => 'your_schema',
     

4. Verify Setup:
- Run the migrations again to ensure the tables are set up correctly:

bash
     php artisan migrate
     

bash
     php artisan serve
     

5. Optional: Use Supabase Auth:
- If you want to use Supabase's authentication features, you need to configure Laravel to use Supabase Auth. This involves setting up the Supabase API keys and configuring Laravel to use them for authentication[1][4].

By following these steps, you can integrate your Laravel application with Supabase and use its features like authentication and Postgres database management.