Monitoring and logging in Supabase - Mini Project: Build & Apply

Monitoring and Logging with Supabase

📖 Scenario: You are managing a small web app that uses Supabase as its backend. You want to keep track of user activity and errors by setting up simple monitoring and logging. This will help you understand how users interact with your app and quickly find problems.

🎯 Goal: Build a basic monitoring and logging setup using Supabase. You will create a table to store logs, add a configuration for log levels, write a function to insert logs based on the level, and finally display the logs.

📋 What You'll Learn

Create a Supabase table called logs with columns id (auto-increment), level (text), message (text), and timestamp (timestamp with default current time).

Add a variable log_level to control which logs to record (e.g., 'INFO', 'ERROR').

Write a function add_log(level, message) that inserts a log into the logs table only if the log's level is equal or higher priority than log_level.

Query and print all logs from the logs table ordered by timestamp.

💡 Why This Matters

🌍 Real World

Monitoring and logging help developers track app behavior and quickly find issues. Supabase makes it easy to store and query logs in a database.

💼 Career

Understanding how to set up logging and monitoring is essential for DevOps roles and backend development to maintain reliable applications.

1

Create the logs table in Supabase

Write the SQL command to create a table called logs with columns: id as an auto-incrementing primary key, level as text, message as text, and timestamp as a timestamp with default value as the current time.

Supabase

-- Write the SQL CREATE TABLE command for 'logs' here
-- Your code here

Hint

Use SERIAL PRIMARY KEY for auto-increment id. Use CURRENT_TIMESTAMP as default for timestamp.

2

Add a log_level configuration variable

In your Supabase client code, create a variable called log_level and set it to the string 'INFO' to control the minimum level of logs to record.

Supabase

CREATE TABLE logs (
  id SERIAL PRIMARY KEY,
  level TEXT NOT NULL,
  message TEXT NOT NULL,
  timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)

# Define the minimum log level to record
# Your code here

Hint

Just assign the string 'INFO' to a variable named log_level.

3

Write the add_log(level, message) function

Write a function called add_log that takes level and message as parameters. It should insert a new row into the logs table only if the level is equal or higher priority than log_level. Use the priority order: ERROR > WARN > INFO. Use Supabase client methods to insert the log.

Supabase

CREATE TABLE logs (
  id SERIAL PRIMARY KEY,
  level TEXT NOT NULL,
  message TEXT NOT NULL,
  timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)

log_level = 'INFO'

# Define add_log(level, message) function below
# Your code here

Hint

Use a dictionary to map log levels to numbers for comparison. Insert only if the level is high enough.

4

Query and print all logs ordered by timestamp

Write code to query all rows from the logs table ordered by timestamp ascending. Then print the list of logs.

Supabase

CREATE TABLE logs (
  id SERIAL PRIMARY KEY,
  level TEXT NOT NULL,
  message TEXT NOT NULL,
  timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)

log_level = 'INFO'

priority = {'ERROR': 3, 'WARN': 2, 'INFO': 1}

def add_log(level, message):
    if priority[level] >= priority[log_level]:
        supabase.table('logs').insert({'level': level, 'message': message}).execute()

# Query all logs ordered by timestamp and print them
# Your code here

Hint

Use supabase.table('logs').select('*').order('timestamp', desc=False).execute() to get logs. Print the data attribute.