Simple library to connect ESP32/8266 to Supabase via REST API, including user authentication - forked from jhavgas's original repo and trimmed down for simplicity.
CLone this repo and copy the src directory - consisting of a single Supabase.h and Supabase.cpp - to your local arduino library directory.
In the same directory, create a Secrets.h file that contain your
- wifi ssid
- wifi password
- Supabase authenticated user name (optional - when using an RLS table)
- Supabase authenticated user password (optional - when using an RLS table)
Secrets.h should take the following form
#ifndef Secrets
#define Secrets
#define WIFI_SSID <your_wifi_ssid>
#define WIFI_PASSWORD <your_wifi_password>
#define SUPABASE_URL <your_supabase_url>
#define SUPABASE_ANON_KEY <your_supabase_anon_key>
#define SUPABASE_USER_EMAIL <your_supabase_authenticated_user_name>
#define SUPABASE_USER_PASSWORD <your_supabased_authenticated_user_password>
#endif
Remember to include Secrets.h in your .gitignore file - so that you do not accidently push secrets to a git repository!
An example main.cpp file using the library and Secrets.h is given below
#include <Arduino.h>
#include <ESP8266WiFi.h>
#include <ESP8266WiFi.h>
#include <Wifi.h>
#include <ArduinoJson.h>
#include <Supabase.h>
#include <Secrets.h>
Supabase db;
// define supabase credentials from constants stored in Secrets.h
const char *supabase_url = SUPABASE_URL;
const char *anon_key = SUPABASE_ANON_KEY;
const char *email = SUPABASE_USER_EMAIL; // optional - only if using RLS table
const char *password = SUPABASE_USER_PASSWORD; // optional - only if using RLS table
// define Wifi credentials from constants stored in Secrets.h
const char *ssid = WIFI_SSID;
const char *psswd = WIFI_PASSWORD;
void setup()
{
Serial.begin(9600);
// Connecting to Wi-Fi
Serial.print("Connecting to WiFi");
WiFi.begin(ssid, psswd);
while (WiFi.status() != WL_CONNECTED)
{
delay(100);
Serial.print(".");
}
Serial.println("Connected!");
// Logging in an authenticated user - for auth protected RLS tables
db.login_email(email, password);
// Create Supabase Connection
db.begin(supabase_url, anon_key);
// select from an non-RLS table "test"
String read = db.from("test").select("*").doSelect();
Serial.println(read);
// insert into an RLS table "test_auth"
DynamicJsonDocument doc(1024);
doc["value"] = 6;
String jsonStr;
serializeJson(doc, jsonStr);
bool upsert = false;
String table = "test_auth";
int status_code = db.insert(table, jsonStr, upsert);
Serial.println(status_code);
// Reset Your Query before doing everything else
db.urlQuery_reset();
}
void loop()
{
delay(10);
}