
As modern applications increasingly adopt event-driven architectures, the line between application logic and database behavior has blurred. Supabase, built on PostgreSQL, provides developers with powerful tools to implement reactive workflows directly at the database layer through triggers. In this post, we’ll explore how to design, implement, and maintain database triggers in Supabase, providing real-world use cases, technical insights, and best practices.


![image.png](https://prod-files-secure.s3.us-west-2.amazonaws.com/655b33b3-36d2-8121-828f-0003e6db7868/b3f66456-e82f-4af7-8a4a-515de04c872f/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIAZI2LB4667RRRK4QT%2F20251118%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20251118T024129Z&X-Amz-Expires=3600&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEPL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLXdlc3QtMiJIMEYCIQDI0963PsZS6pJfzeAjO1XSoiw3M74%2BHN5EyBZAfC%2B8YgIhAKaR9gNFPBEEIfVs1SgaJe%2BpVVwT5xgbOmo9ch5IBTrmKogECLv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQABoMNjM3NDIzMTgzODA1Igz1JK8G3VBSqFkYJGoq3APajogrzhN%2Byx5MQEMwmkn4zWaZfHs1TT02ylTq2SVIHwuRzIMi%2Bcx9LgkIwawLwXYqmb%2BvNoN53ZMjxEIkW%2BJAcYHTIlPJWAawm6%2BMcQ%2F9gozkRjcwIDNACzwIWciRYRSBP%2Bculdc%2Bj%2Fy4MjsxuH2ZFIU%2FaZKbcoH5J0R0nL9XARi%2BtWj5FIRI%2B66QPlR0iJ%2BMLrE9dEvAd3ErcfpwpPDRsLrbi%2BbNLDbfjbZN7u2kbpNmoZqChTHqHg6QW7R5Rwp9%2BV1RHH9AmXAfEoioTUz0EKj9CAPV52w04Qg3yJuszayxB9AivryWOTehK%2BtbC%2FJgAxUDzaIwQn4s8IZGm%2FoEJeg4KyIN0SMhGd83Nz53XZYOJIUmnNkqP3gmBucw6VgDOx1EJWjIj3%2FCLtCyQ30AGGIC%2FwmtkJP8XKGaVvHm9LO0CL3x1sGuTjZdVYciEPJ6D2ggQd6LaV3lfAi3fC4fcYGrFQ1J6punWYI55Gh9x%2FLKVc%2BaJlxlD2bhWoShEJQ1JEwdanCBTj8IeIvBr4LceVR41oO3IPRSZSNfXood7JOa0ci8QYDNEMwWkWp%2B1FPUpQIP9kBHBJ2YQymhAiyxjNEAsGOvnP57C0zMcqkwWUM8%2FmajdI64cvPeUzDmme%2FIBjqkAcab8k1utF2dwJdvttZkntC3JK1mM4lRneGIbJj6lR2diOj7yHBT7a%2BuprlaKl1zYm8GAoxHgut9ZqA6iZ30%2Bb6CxvLEGvvvqmErSUJlw9esPFWpaSvpGP1Iv%2Bct6pmgVh%2F%2FmXSMTTXl8iNwSLGqDcyZLKriEQp8XJ4PyLiMBUQwDAWphcHgx%2B%2BNZ64XRk2zr%2FtEZagQCgW40uzVK9oFNbKiU%2F%2Ft&X-Amz-Signature=3eadac800a306dcf5ce79a8027f9d04dee1b64e504d34ad8f18e6b9920203219&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)


## Understanding Database Triggers in Supabase


At its core, a trigger is a procedural code snippet that automatically executes in response to specific changes in a table `INSERT`, `UPDATE`, `DELETE`, or even `TRUNCATE`. In Supabase, triggers are implemented using PostgreSQL's native capabilities, giving developers access to a robust, reliable mechanism for reactive behavior.


Triggers are particularly useful in scenarios such as:

- Enforcing complex business rules that span multiple tables
- Maintaining audit logs without polluting application logic
- Synchronizing data between tables or external services
- Supporting real-time notifications via Supabase's Real-time engine

By moving certain logic to the database, we reduce round trips between the application and the database, improving performance and consistency.


## Anatomy of a PostgreSQL Trigger


A trigger in PostgreSQL requires two components:

1. **Trigger Function (Procedure):** The actual code executed when the trigger fires.
2. **Trigger Definition:** Specifies the timing (`BEFORE` or `AFTER`) and the event (`INSERT`, `UPDATE`, `DELETE`) that fires the function.

For example, consider a scenario where we want to automatically update a `last_modified` timestamp whenever a row in the `projects` table is updated:


```sql
-- Trigger function
CREATE OR REPLACE FUNCTION update_last_modified()
RETURNS TRIGGER AS $$
BEGIN
  NEW.last_modified = NOW();
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

-- Trigger definition
CREATE TRIGGER set_last_modified
BEFORE UPDATE ON projects
FOR EACH ROW
EXECUTE FUNCTION update_last_modified();
```


Here, the `update_last_modified` function ensures consistency across updates without requiring application-side enforcement.


## Use Case: Audit Logging


Maintaining an audit trail is a common requirement. Let’s track every change to the `users` table:


```sql
-- Audit log table
CREATE TABLE user_audit_log (
    id BIGSERIAL PRIMARY KEY,
    user_id UUID,
    operation TEXT,
    changed_data JSONB,
    changed_at TIMESTAMPTZ DEFAULT NOW()
);

-- Trigger function
CREATE OR REPLACE FUNCTION log_user_changes()
RETURNS TRIGGER AS $$
BEGIN
  INSERT INTO user_audit_log(user_id, operation, changed_data)
  VALUES (
    NEW.id,
    TG_OP,
    to_jsonb(NEW)
  );
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

-- Trigger
CREATE TRIGGER user_audit_trigger
AFTER INSERT OR UPDATE OR DELETE ON users
FOR EACH ROW
EXECUTE FUNCTION log_user_changes();
```


With this approach:

- `TG_OP` automatically provides the operation type (`INSERT`, `UPDATE`, `DELETE`).
- `to_jsonb(NEW)` captures the full state of the row after modification.

This ensures every change is traceable while remaining fully automated in the database layer.


## Integrating Triggers with Supabase Real-time


Supabase provides a Real-time engine that allows applications to subscribe to database changes. When combined with triggers, this enables robust, event-driven workflows.


For example, suppose we want to notify an admin whenever a new project is created:


```sql
CREATE OR REPLACE FUNCTION notify_new_project()
RETURNS TRIGGER AS $$
BEGIN
  PERFORM pg_notify('projects_channel', row_to_json(NEW)::text);
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER project_created
AFTER INSERT ON projects
FOR EACH ROW
EXECUTE FUNCTION notify_new_project();
```


On the frontend, you can listen for these notifications:


```javascript
import { createClient } from '@supabase/supabase-js';

const supabase = createClient(SUPABASE_URL, SUPABASE_KEY);

supabase
  .channel('projects_channel')
  .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'projects' }, (payload) => {
    console.log('New project created:', payload);
  })
  .subscribe();
```


This pattern enables real-time dashboards, automatic email notifications, or triggers that update caches without adding extra complexity to your application code.


## Best Practices for Triggers in Supabase

1. **Prefer** **`AFTER`** **triggers for notifications and external side effects**

    `BEFORE` triggers are better suited for validation or data normalization.

2. **Minimize complex logic in triggers**

    Triggers should be fast; avoid heavy computations or network calls inside the function.

3. **Use** **`FOR EACH ROW`** **vs** **`FOR EACH STATEMENT`** **wisely**

    `FOR EACH ROW` triggers fire for every affected row. `FOR EACH STATEMENT` is suitable for bulk operations like logging counts or batch metrics.

4. **Monitor and debug**

    Use `RAISE NOTICE` or temporary logging tables to inspect trigger behavior during development.

5. **Maintain idempotency**

    Ensure that re-running triggers due to retries or replication does not create inconsistent states.

6. **Version your triggers**

    Use `CREATE OR REPLACE FUNCTION` carefully, and consider migrations to manage trigger changes in a team environment.


## Debugging Triggers


Triggers can silently fail if not implemented correctly. Techniques for debugging include:

- **RAISE statements:** Print debug info directly in PostgreSQL logs:

```sql
RAISE NOTICE 'Trigger fired on ID: %', NEW.id;
```

- **Temporary logging tables:** Capture payloads for analysis:

```sql
INSERT INTO trigger_debug_log(payload) VALUES (row_to_json(NEW));
```

- **Test in isolation:** Execute the trigger function directly with sample data using `SELECT function_name(ROW(...))` before attaching it to production tables.

## Conclusion


Database triggers in Supabase are a powerful tool for building reactive, event-driven applications without over-complicating your backend code. By leveraging PostgreSQL’s rich trigger system, developers can enforce business logic, maintain audit trails, and enable real-time notifications efficiently and reliably.


When used judiciously, triggers reduce repetitive logic in your application, improve consistency, and empower developers to design more scalable, maintainable systems. As Supabase continues to evolve, combining triggers with its Real-time engine and edge functions opens exciting possibilities for truly serverless, event-driven architectures.



Creating and Using Database Triggers in Supabase


In the world of Node.js development, it’s common to juggle multiple versions of Node across different projects. Using a single global Node installation can lead to version conflicts, dependency issues, or surprises in production. That’s where **NVM (Node Version Manager)** shines: it enables you to install, switch, and manage multiple Node.js versions side by side on the same machine.



![https___dev-to-uploads.s3.amazonaws.com_uploads_articles_tns0q1sn1n531uk9e8mt.webp](https://prod-files-secure.s3.us-west-2.amazonaws.com/655b33b3-36d2-8121-828f-0003e6db7868/5b95a022-33d5-40c3-869f-ff4584d211f9/https___dev-to-uploads.s3.amazonaws.com_uploads_articles_tns0q1sn1n531uk9e8mt.webp?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIAZI2LB466VYJG7RPP%2F20251118%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20251118T024128Z&X-Amz-Expires=3600&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEPL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLXdlc3QtMiJHMEUCIQDFNaxys5b4XID6Th2ehXmI5F6IhmZNt8mYGHgRJX5bRQIgc60MNyKoOQ5EXviWlQ437stX1bJXPRH79SOTvxMSWxYqiAQIu%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAAGgw2Mzc0MjMxODM4MDUiDHi%2BM5qUUZDcm0mnuSrcA1j3mmn9duT1o3yD%2BulEOF6SThsLDa35mBTZQFoIUJWDwEt2Hn7ec3s1grs7AD0BDVPJ08bZVjpYIP0am%2B%2BeFL2AXcojqKLVYA9yR1h1ihRCTIe4uNCk6C2N%2FkGCOrxfQKotRBNso6YooaTJnb7wJ4yQd6XsPra8LUL%2F3L2ucMyc2xAFeftEe5uFUU5QUj7NQe%2Ff7gNKf0g%2FAws6nWFulNkcKZTcKcfBxv0omh3Z80UhqWZkRdVsnsOCSslZjYonMQLnbR8z5HDAe6jSz7hqnYHHCM1K3OcjJkwh8X229mpqt5uMXO%2B40Tk8UTJr08V2pe%2BbrT9Xcd3MIgcF%2Fex2QxYujvQ7mYYDfleyQxOjV9icOR%2B088bfPpP55t7m729VfXu1xNUvtI%2BNdCw6pDVqqEEvE9aWjlbIWOT7J7EF%2FXr5PQrrV4XpA6sSq%2Fe3UsUJJiuihiZQOU5qtOZKFGULKV13FEqTWWQhPAKutoCaRzEGrhtuMX7ubMY7MJz74RSUR%2F65smV5JJjkF7seRJbXtNPwT7cJxIPIDE6oD%2FzLNkksG%2FGf%2FUv3o4SS5tRQvQjaRBV1mF%2BJb6XApmTxmGrSX1C5ACRBcob6ub2bdPiDjtpNcRHWtRLtWA8JKwxgMOaZ78gGOqUB6xBxCL5fIQ96k0Kt0ai3nvHUwbwVLJdgHxRFxPBDBuBFf1iaR7zclthOrs7BpwM6Jhmu5SwSZ2nzdg6jHK27BC0FXkmNJmIRzftWls5ikEXGD%2FoUOI1iOh7s%2Bn2Rk6Vq7J49XGQ05JKz4Gc67xBxno85CL1HeEuKqf%2FkbT4vJe5zZtwu0%2FaYPUL2BJPbvnfs%2FdH4%2F2eIUQqozlQo0H%2F4VoxSJLFY&X-Amz-Signature=cebc2ee6c705618f6c8a07b6d9c8c8229d869b9363f950cbd67138a7e52ddb5c&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)


In this guide, I’ll walk you through installing NVM on **Ubuntu 24.04**, show you how to use it effectively, and offer best practices to keep your setup stable. Let’s get started.


## **Why Use NVM?**

1. **Switch Node.js versions seamlessly**: Perfect for projects that require specific Node versions.
2. **Isolated environments**: Run multiple Node.js versions without interference between them.
3. **User-friendly workflow**: Install, remove, and manage Node.js versions with simple command-line operations.

## **Step 1: Update Your System**


It’s crucial to update your system first, to ensure dependencies and package sources are current:


```bash
sudo apt update
sudo apt upgrade -y
```


Also, consider rebooting if you haven’t done that in a while, especially if kernel or low-level packages were upgraded.


## **Step 2: Install Necessary Tools**


You’ll need tools to download files and compile modules when required:


```bash
sudo apt install -y curl build-essential libssl-dev
```

- `curl` → For fetching remote scripts.
- `build-essential` → For compiling C/C++ add-ons (npm modules that need binaries).
- `libssl-dev` → Some Node versions/modules need SSL libraries.

## **Step 3: Download & Install NVM**


Here we fetch the official installer and run it:


```bash
curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/vX.Y.Z/install.sh | bash
```

- Replace `vX.Y.Z` with the **latest stable NVM version**.
- This script creates a `.nvm` directory in your home (~/.nvm), and updates your shell config (like `~/.bashrc` or `~/.zshrc`) to load NVM automatically.

## **Step 4: Activating NVM in Your Shell**


After installation, you need to enable it:


```bash
# Either in current session:
export NVM_DIR="$HOME/.nvm"
[ -s "$NVM_DIR/nvm.sh" ] && . "$NVM_DIR/nvm.sh"

# Then, add these lines into ~/.bashrc or ~/.zshrc so they are loaded on login.
```


To apply changes right away:


```bash
source ~/.bashrc    # or source ~/.zshrc
```


## **Step 5: Confirming Installation**


Check NVM is available:


```bash
nvm --version
```


If this returns something like `0.40.x` (or whatever current), you’re good.


## **Step 6: Using NVM to Handle Node.js Versions**


With NVM ready, you’ll want to do things like:


### **Install the latest stable version**


```bash
nvm install node
```


### **Install the current LTS version**


```bash
nvm install --lts
```


### **Install a specific version**


```bash
nvm install 18.17.0
```


### **Switch to a version for current session**


```bash
nvm use 18.17.0
```


### **Set a default version, so new shells use it automatically**


```bash
nvm alias default 18.17.0
```


### **List versions you have installed**


```bash
nvm ls
```


### **See all Node.js versions available to install remotely**


```bash
nvm ls-remote
```


## **Step 7: Workflow Tips & Tricks**


These are the little practices that make your life easier:

- **Use a** **`.nvmrc`** **file:** In a project folder, put a file named `.nvmrc` with a version (e.g. `18.17.0`). Then you and your team can use `nvm use` inside that project to automatically pick the right version.
- **Global packages per version:** If you install global npm packages under one Node version, they won’t automatically be available under another. Use `-reinstall-packages-from=<old_version>` when installing a new version to copy over global packages.
- **Avoid mixing apt-installed Node with NVM:** If you had Node.js from Ubuntu’s package manager before, consider removing it (`sudo apt remove nodejs`) to avoid conflicts.

## **Step 8: Common Issues & Fixes**


Here are issues you might encounter, plus how to fix them:


| Problem                                        | Symptoms                                                      | Fix                                                                                                               |
| ---------------------------------------------- | ------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------- |
| `nvm: command not found` after install         | The shell doesn’t load NVM automatically                      | Ensure lines added to `.bash` / `.zshrc` by installer are present; then `source` the file or open a new terminal. |
| Old Node still used by system                  | `node -v` returns old version even after `nvm use`            | Remove or disable the system Node; ensure your `PATH` is set so NVM’s bin comes first.                            |
| Permission errors when installing npm packages | Errors related to permissions when installing global packages | Don’t use `sudo` with npm when using NVM; global installs happen in user’s home directory.                        |


## **Conclusion**


Setting up NVM on Ubuntu 24.04 gives you control, flexibility, and peace of mind when working with Node.js. Once it’s in place, switching versions becomes second nature, which is especially helpful when maintaining multiple projects, testing compatibility, or just staying up to date with Node.js.



Managing Multiple Node.js Versions with NVM on Ubuntu 24.04: A Developer’s Guide


As modern applications increasingly adopt event-driven architectures, the line between application logic and database behavior has blurred. Supabase, built on PostgreSQL, provides developers with powerful tools to implement reactive workflows directly at the database layer through triggers. In this post, we’ll explore how to design, implement, and maintain database triggers in Supabase, providing real-world use cases, technical insights, and best practices.


![image.png](https://prod-files-secure.s3.us-west-2.amazonaws.com/655b33b3-36d2-8121-828f-0003e6db7868/b3f66456-e82f-4af7-8a4a-515de04c872f/image.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIAZI2LB466Z3WRKERP%2F20251118%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20251118T024128Z&X-Amz-Expires=3600&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEPL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLXdlc3QtMiJHMEUCIQD1JHYC6rM6sH2HmCt4gyJs3OjCWdKUffSH%2BabWai0DgQIgKbO8%2FWXjjuXUDxNMSIDyTC9iEQlgGAnAwmbCd1xq84kqiAQIu%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FARAAGgw2Mzc0MjMxODM4MDUiDPA5uk8M1toBQZmeWircA194ZgzQUp6WBcv77BnNLLJ2rabNfM0HdRJLkFMw7FnLMmTYHXacQdj4irAkhePx0RtNNxXmjVBaXgqqncpcTZiLzoAl%2FKcoNeQZy0jGpTKGEc66QY%2F0R0jl7L%2BcNW%2BnLwvu5lA9elxrtz203IGWqkbqElH2%2B%2F1q2EdAj0VYhiTE4Vj5CqIGmblX0ADbvJUG2oVP2CEX5i4zvorSFaSFePOHOnJhRtA174L2HaOz7ZLGRYErDBwoHaBFJgxVyYifuIr8oyc1y74%2FgG37sKg3Xq%2Fd%2FyDCP008iB1tcXskDsXi8xKfzmtmJZncpts%2BId9QbGXXw9VIJx0mJvSQeNk7eBn8DdNy91uw11skpzunZJfJ1fgBNqbdmtp39x8QZXg0%2BZOxIVLxgHkKxInSZ6T6Sl1fiTURRoFElTmUOEmUqkfI6%2FKT%2BGTsnsWMYbE4QZUTtiMkwRIf5z9C6mbnpA86SMO90aKuUFX73ecUSzj2UI95FVMOYXLQ9vJ8yRsoMuGeAUMukSzPyYN%2F7ABazzhY5FM4c19qr7TR8W902QFTVTNyjsQVDTxguDiB3xhEE%2BYqhra9rx6EmLGsXY8OuQzIoYiiW1tpZhABQCNrTc5lvX4AtNRg7kk4TLg1obJ1MOiZ78gGOqUB%2B7bLZ7tVp5ywnkHYg84utyTTrQFopZ3A%2B2p4E7b77r2q5BZucZCqMMABuf9CUOI9PxoBu%2Fo1IvVtL4XzSahfRkAoOBmfAKNR8zI4lWeRk9dSkuDymJR5m0bZhgtB4FgQnxFxbS3%2BsX7y9fRPasbCe2ar1yQG%2BejzkAtNtGyvcUSWgCKxdc2KK1Qpb4EUunqZo%2Bjq6p6EXx776HeGeuC2iOGzQzU4&X-Amz-Signature=45facef1082d78b8659e2cd63942291df3de064ea206c4251ef6990d67bc678f&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)


## Understanding Database Triggers in Supabase


At its core, a trigger is a procedural code snippet that automatically executes in response to specific changes in a table `INSERT`, `UPDATE`, `DELETE`, or even `TRUNCATE`. In Supabase, triggers are implemented using PostgreSQL's native capabilities, giving developers access to a robust, reliable mechanism for reactive behavior.


Triggers are particularly useful in scenarios such as:

- Enforcing complex business rules that span multiple tables
- Maintaining audit logs without polluting application logic
- Synchronizing data between tables or external services
- Supporting real-time notifications via Supabase's Real-time engine

By moving certain logic to the database, we reduce round trips between the application and the database, improving performance and consistency.


## Anatomy of a PostgreSQL Trigger


A trigger in PostgreSQL requires two components:

1. **Trigger Function (Procedure):** The actual code executed when the trigger fires.
2. **Trigger Definition:** Specifies the timing (`BEFORE` or `AFTER`) and the event (`INSERT`, `UPDATE`, `DELETE`) that fires the function.

For example, consider a scenario where we want to automatically update a `last_modified` timestamp whenever a row in the `projects` table is updated:


```sql
-- Trigger function
CREATE OR REPLACE FUNCTION update_last_modified()
RETURNS TRIGGER AS $$
BEGIN
  NEW.last_modified = NOW();
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

-- Trigger definition
CREATE TRIGGER set_last_modified
BEFORE UPDATE ON projects
FOR EACH ROW
EXECUTE FUNCTION update_last_modified();
```


Here, the `update_last_modified` function ensures consistency across updates without requiring application-side enforcement.


## Use Case: Audit Logging


Maintaining an audit trail is a common requirement. Let’s track every change to the `users` table:


```sql
-- Audit log table
CREATE TABLE user_audit_log (
    id BIGSERIAL PRIMARY KEY,
    user_id UUID,
    operation TEXT,
    changed_data JSONB,
    changed_at TIMESTAMPTZ DEFAULT NOW()
);

-- Trigger function
CREATE OR REPLACE FUNCTION log_user_changes()
RETURNS TRIGGER AS $$
BEGIN
  INSERT INTO user_audit_log(user_id, operation, changed_data)
  VALUES (
    NEW.id,
    TG_OP,
    to_jsonb(NEW)
  );
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

-- Trigger
CREATE TRIGGER user_audit_trigger
AFTER INSERT OR UPDATE OR DELETE ON users
FOR EACH ROW
EXECUTE FUNCTION log_user_changes();
```


With this approach:

- `TG_OP` automatically provides the operation type (`INSERT`, `UPDATE`, `DELETE`).
- `to_jsonb(NEW)` captures the full state of the row after modification.

This ensures every change is traceable while remaining fully automated in the database layer.


## Integrating Triggers with Supabase Real-time


Supabase provides a Real-time engine that allows applications to subscribe to database changes. When combined with triggers, this enables robust, event-driven workflows.


For example, suppose we want to notify an admin whenever a new project is created:


```sql
CREATE OR REPLACE FUNCTION notify_new_project()
RETURNS TRIGGER AS $$
BEGIN
  PERFORM pg_notify('projects_channel', row_to_json(NEW)::text);
  RETURN NEW;
END;
$$ LANGUAGE plpgsql;

CREATE TRIGGER project_created
AFTER INSERT ON projects
FOR EACH ROW
EXECUTE FUNCTION notify_new_project();
```


On the frontend, you can listen for these notifications:


```javascript
import { createClient } from '@supabase/supabase-js';

const supabase = createClient(SUPABASE_URL, SUPABASE_KEY);

supabase
  .channel('projects_channel')
  .on('postgres_changes', { event: 'INSERT', schema: 'public', table: 'projects' }, (payload) => {
    console.log('New project created:', payload);
  })
  .subscribe();
```


This pattern enables real-time dashboards, automatic email notifications, or triggers that update caches without adding extra complexity to your application code.


## Best Practices for Triggers in Supabase

1. **Prefer** **`AFTER`** **triggers for notifications and external side effects**

    `BEFORE` triggers are better suited for validation or data normalization.

2. **Minimize complex logic in triggers**

    Triggers should be fast; avoid heavy computations or network calls inside the function.

3. **Use** **`FOR EACH ROW`** **vs** **`FOR EACH STATEMENT`** **wisely**

    `FOR EACH ROW` triggers fire for every affected row. `FOR EACH STATEMENT` is suitable for bulk operations like logging counts or batch metrics.

4. **Monitor and debug**

    Use `RAISE NOTICE` or temporary logging tables to inspect trigger behavior during development.

5. **Maintain idempotency**

    Ensure that re-running triggers due to retries or replication does not create inconsistent states.

6. **Version your triggers**

    Use `CREATE OR REPLACE FUNCTION` carefully, and consider migrations to manage trigger changes in a team environment.


## Debugging Triggers


Triggers can silently fail if not implemented correctly. Techniques for debugging include:

- **RAISE statements:** Print debug info directly in PostgreSQL logs:

```sql
RAISE NOTICE 'Trigger fired on ID: %', NEW.id;
```

- **Temporary logging tables:** Capture payloads for analysis:

```sql
INSERT INTO trigger_debug_log(payload) VALUES (row_to_json(NEW));
```

- **Test in isolation:** Execute the trigger function directly with sample data using `SELECT function_name(ROW(...))` before attaching it to production tables.

## Conclusion


Database triggers in Supabase are a powerful tool for building reactive, event-driven applications without over-complicating your backend code. By leveraging PostgreSQL’s rich trigger system, developers can enforce business logic, maintain audit trails, and enable real-time notifications efficiently and reliably.


When used judiciously, triggers reduce repetitive logic in your application, improve consistency, and empower developers to design more scalable, maintainable systems. As Supabase continues to evolve, combining triggers with its Real-time engine and edge functions opens exciting possibilities for truly serverless, event-driven architectures.




If you’ve ever found yourself copy-pasting data between tools, writing yet another one-off script to connect APIs, or juggling a dozen SaaS dashboards every day, you know the pain of repetitive work. That’s exactly where **n8n** comes in a tool I’ve been exploring recently, and honestly, it has quickly become one of my favorites for automation.


## So, What Exactly is n8n?


n8n (short for “node”) is an **open-source workflow automation platform**. Think of it as a more developer-friendly version of Zapier or Integromat. It lets you connect different services, APIs, and databases, and build workflows that run automatically, without needing to reinvent the wheel each time.


The best part? You can host it yourself, customize it however you want, and you’re not locked into someone else’s SaaS pricing model. For developers and teams who care about data ownership and flexibility, this is a huge plus.


## Why I Like Working with n8n


When I started tinkering with n8n, a few things immediately stood out:

- **It’s open-source and self-hostable.** You can run it locally, on a server, or even in Docker/Kubernetes. This gives you full control.
- **It comes with 350+ integrations.** Google Sheets, Slack, GitHub, AWS, databases - you name it.
- **The editor is visual, but not limiting.** You can drag-and-drop nodes, but you can also write custom JavaScript if you need more control.
- **Event-driven automation.** Workflows don’t just run on a schedule - they can trigger when something happens (like a new file uploaded, or a webhook received).

For me, it strikes the right balance between **low-code convenience** and **developer power**.


## Real-Life Use Cases


Here are a few scenarios where n8n shines:

- **Marketing automation**: A new lead fills out a form → n8n saves it to a CRM → sends a Slack notification → triggers a welcome email.
- **DevOps monitoring**: When a server goes down → log the issue → create a GitHub ticket → ping the on-call engineer.
- **Data pipelines**: Fetch data from an API → transform it → insert it into PostgreSQL or BigQuery.
- **E-commerce workflows**: Automate order tracking, payments, and shipping updates.

Basically, if you can describe a process, you can probably build it in n8n.


## Getting Started (It’s Easier Than You Think)


Setting up n8n is surprisingly straightforward. You can install it globally with npm:


```bash
npm install n8n -g
n8n start
```


Or, if you’re like me and prefer containers:


```bash
docker run -it --rm \
  -p 5678:5678 \
  -v ~/.n8n:/home/node/.n8n \
  n8nio/n8n
```


Then just head over to `http://localhost:5678` in your browser, and you’ll find a clean visual editor waiting for you. From there, it’s drag-and-drop nodes, configure credentials, and connect the dots.


## Why n8n is Worth a Try


There are plenty of automation tools out there, but what sets n8n apart is the **balance of simplicity and flexibility**. It’s approachable for non-developers, but at the same time, it doesn’t box developers in. You can go as deep as you want with scripting, custom nodes, and API integrations.


For me, it’s a tool that reduces repetitive work and lets me focus on more interesting problems. If you’re curious about automation, I’d definitely recommend giving it a try.



Automating Workflows with n8n: Why I Use It and Why You Might Too


On Monday, October 20, 2025, Amazon Web Services (AWS) experienced a significant outage that disrupted numerous major websites and applications worldwide. The incident primarily affected the US-EAST-1 region in Northern Virginia, leading to widespread service degradation across various platforms.


![70fdd33d-8eab-436a-935d-ec6baf932af5.png](https://prod-files-secure.s3.us-west-2.amazonaws.com/655b33b3-36d2-8121-828f-0003e6db7868/ce8963a1-9007-4fb5-a21d-cb5a388677fd/70fdd33d-8eab-436a-935d-ec6baf932af5.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIAZI2LB466ZVDCHU3G%2F20251118%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20251118T024128Z&X-Amz-Expires=3600&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEPL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLXdlc3QtMiJIMEYCIQDF0vbZbeFgVoGstGZVb2unXGxNm080mrIqMPyNoY7u%2BwIhAOBkKhaJtm2myIyIB45R9vkMwGLpUbinzfgrZW%2FKynyuKogECLv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQABoMNjM3NDIzMTgzODA1IgxTHdyfbMhB8m9pMbQq3AOGnaw1NAptoX1VVx1J1hE5D8wAvRgzrXm1owcO8vsR0W5cQhE7eQ2Pecpy2MYxJS52vQXbKFvnuhrUu8pSthM2wbMxFCxJtErSeq%2Ft4PP2hmhBaHcKlEvLYheTqFxfBDwxW%2FtOPxLzjNhYqB8IdOuZ6HZOmnahulb6WZ47BPLGZHapB7tNl4rRSdmZeaxJIf3leOkHZ9T3A%2BGAj%2FsR0Cxp66QJ6zglvwov%2BIOPu%2FOwXO8EE30Fk%2BzHfHEdW%2F4wmh2IzCtDn1L%2B%2BlpYXM7%2BftVGP5cdlG8Y2q0f8ETQo5CASwjMvc8v56NlzirpQAtF0rbbO6Nt85Qwgc%2B6gVhdAe0OGGS179nDcREKegE4nqR9rVvK1MOVxM88%2FdCa0loFzCGWk%2F2CxUYkmLdZ%2FFQUa2yXf2zv5S7krEnx%2F%2BXeo2H5cRSIlcgP%2FvDW5wPmk4NPTRkkR%2B2nOWdXNi6uuaGDr8ylNGn9MQ6Jua3RYAsa6TqfybDwqQhNzzBoPxTnd%2BYXpy13ct4PWCyGox589Yke6LjEUBDVVH%2BCXoDWu38j%2BvFcOIUeZSwfSAawcS8le0haBx0ajkXL2%2FcHqOOggyO67fJDm9OPgYix6x7m1BAtnHxZAuoAIOQthWJnqYMb7DDmme%2FIBjqkAcQ7Zt2P1ZzsyDQuPXLvOzxMFxIE3q%2BwYgRwmm4IO8qDjxpO483YRoN%2FQ46LaCL0dTfFBfQT1XRu3BW3rZNJhB5WGRnxSye60D4gpaGTsx938ybZtXVVpkC492mAP26MrgFBMz0WnjZgyo%2FI2y1pf9ZIiBpZSjedFI0CnvBl5CeNHHB9F%2FZyNiWXz%2B6g%2BXWIfmLgZk7Qp6SmrEPViLqnYNs8Bflw&X-Amz-Signature=4e6f08a894d6a568c2698d11afd05b4929bf8b6cf49c1591715be0973901dcd3&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)


## Affected Services and Platforms


The AWS outage impacted a diverse range of services, including:

- **Social Media & Communication**: Snapchat, Signal, Perplexity, and X (formerly Twitter)
- **Gaming**: Fortnite, Roblox, Clash Royale, and Clash of Clans
- **Financial Services**: Coinbase, Robinhood, Venmo, Chime, and Capital One
- **Streaming & Entertainment**: Amazon Prime Video, Hulu, Disney+, and the McDonald's app
- **Productivity & Cloud Tools**: Canva, Duolingo, Airtable, and the Epic Games Store
- **Smart Home Devices**: Amazon Alexa and Ring

According to DownDetector, over 13,000 user reports were logged, indicating widespread issues across these platforms.


## What the AWS Outage Revealed About Cloud Vulnerabilities


The AWS outage of 2025 exposed deep-rooted cloud computing vulnerabilities that many organizations overlook in pursuit of scalability and convenience. While cloud infrastructure enables global reach and agility, its centralized architecture often introduces a critical single point of failure. When one major region or service falters, the ripple effects can disrupt thousands of dependent systems worldwide.

- **Regional dependence**: Most disruptions occurred in the US-EAST-1 AWS region, highlighting the dangers of geographic concentration.
- **Cross-industry impact**: Finance, gaming, social media, streaming, and IoT platforms all experienced simultaneous outages.
- **Hidden infrastructure risks**: Even resilient systems can be affected by DNS resolution failures, API latencies, and network bottlenecks.

## Why Organizations Rely on a Single Cloud Provider


Despite risks, many companies stick to one cloud provider for several reasons:

1. **Operational simplicity:** Easier management and fewer integration challenges.
2. **Cost efficiency:** Economies of scale and provider-specific discounts.
3. **Integrated ecosystem:** Access to services like AWS Lambda, Azure Functions, or Google BigQuery.
4. **Faster deployment:** Reduced complexity leads to quicker time-to-market.

However, the convenience comes at a cost: vulnerability to catastrophic outages.


## The True Cost of Cloud Outages


Cloud outages aren’t just technical inconveniences they have real financial and operational consequences:

- **Revenue loss:** Downtime for e-commerce or fintech platforms results in lost transactions.
- **Reputation damage:** User trust erodes, leading to customer churn.
- **Operational disruption:** Emergency IT interventions and overtime costs rise sharply.
- **Regulatory risks:** Financial and healthcare sectors may face compliance penalties.

For large enterprises, the financial impact of a hyper-scale outage can reach tens of millions per hour, making reliance on a single cloud provider a serious business risk.


## **Forging Resilience: Advanced Solutions to Prevent Single-Cloud Failure**


Enterprises can adopt resilient cloud strategies to mitigate risk:

1. **Multi-Cloud Strategy:** Distributes workloads across two or more public cloud providers (e.g., AWS, Azure, GCP) to prevent dependence on a single vendor and minimize the impact of a single-provider outage.
2. **Hybrid Cloud Approach:** Blends public cloud services with private, on-premises infrastructure. Critical workloads stay private, while scalable workloads use the public cloud, balancing cost and control.
3. **Active Failover and Replication:** Ensures real-time data replication across different regions or clouds. Automatic failover redirects traffic seamlessly to healthy replicas upon an outage.
4. **Chaos Engineering:** Proactively simulates failures in a controlled environment to identify weak points, test incident response, and continuously improve system resilience _before_ real-world disruptions.
5. **Edge Computing:** Deploys critical services closer to end-users (at the network "edge"), reducing reliance on centralized cloud regions. This improves latency and provides localized resilience.

## Building Resilient Cloud Infrastructure


The 2025 AWS outage underscores the dangers of relying on a single cloud provider. While hyperscale platforms offer convenience and innovation, true resilience requires diversification. Adopting multi-cloud and hybrid strategies supported by advanced failover, chaos engineering, and edge computing is now a strategic necessity. Organizations that build resilient cloud architectures will better protect operations, revenue, and customer trust in an increasingly interconnected digital world.


![b2a51211-7bb1-4a45-81bb-f69e5a765731.png](https://prod-files-secure.s3.us-west-2.amazonaws.com/655b33b3-36d2-8121-828f-0003e6db7868/0088afb8-3904-4fe6-a6bd-42ca5e75eecd/b2a51211-7bb1-4a45-81bb-f69e5a765731.png?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Content-Sha256=UNSIGNED-PAYLOAD&X-Amz-Credential=ASIAZI2LB466ZVDCHU3G%2F20251118%2Fus-west-2%2Fs3%2Faws4_request&X-Amz-Date=20251118T024128Z&X-Amz-Expires=3600&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEPL%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCXVzLXdlc3QtMiJIMEYCIQDF0vbZbeFgVoGstGZVb2unXGxNm080mrIqMPyNoY7u%2BwIhAOBkKhaJtm2myIyIB45R9vkMwGLpUbinzfgrZW%2FKynyuKogECLv%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEQABoMNjM3NDIzMTgzODA1IgxTHdyfbMhB8m9pMbQq3AOGnaw1NAptoX1VVx1J1hE5D8wAvRgzrXm1owcO8vsR0W5cQhE7eQ2Pecpy2MYxJS52vQXbKFvnuhrUu8pSthM2wbMxFCxJtErSeq%2Ft4PP2hmhBaHcKlEvLYheTqFxfBDwxW%2FtOPxLzjNhYqB8IdOuZ6HZOmnahulb6WZ47BPLGZHapB7tNl4rRSdmZeaxJIf3leOkHZ9T3A%2BGAj%2FsR0Cxp66QJ6zglvwov%2BIOPu%2FOwXO8EE30Fk%2BzHfHEdW%2F4wmh2IzCtDn1L%2B%2BlpYXM7%2BftVGP5cdlG8Y2q0f8ETQo5CASwjMvc8v56NlzirpQAtF0rbbO6Nt85Qwgc%2B6gVhdAe0OGGS179nDcREKegE4nqR9rVvK1MOVxM88%2FdCa0loFzCGWk%2F2CxUYkmLdZ%2FFQUa2yXf2zv5S7krEnx%2F%2BXeo2H5cRSIlcgP%2FvDW5wPmk4NPTRkkR%2B2nOWdXNi6uuaGDr8ylNGn9MQ6Jua3RYAsa6TqfybDwqQhNzzBoPxTnd%2BYXpy13ct4PWCyGox589Yke6LjEUBDVVH%2BCXoDWu38j%2BvFcOIUeZSwfSAawcS8le0haBx0ajkXL2%2FcHqOOggyO67fJDm9OPgYix6x7m1BAtnHxZAuoAIOQthWJnqYMb7DDmme%2FIBjqkAcQ7Zt2P1ZzsyDQuPXLvOzxMFxIE3q%2BwYgRwmm4IO8qDjxpO483YRoN%2FQ46LaCL0dTfFBfQT1XRu3BW3rZNJhB5WGRnxSye60D4gpaGTsx938ybZtXVVpkC492mAP26MrgFBMz0WnjZgyo%2FI2y1pf9ZIiBpZSjedFI0CnvBl5CeNHHB9F%2FZyNiWXz%2B6g%2BXWIfmLgZk7Qp6SmrEPViLqnYNs8Bflw&X-Amz-Signature=f4dbe7b81ae97e7512d17f3de946df91d41f1bc44925de198243bd6f48fe9346&X-Amz-SignedHeaders=host&x-amz-checksum-mode=ENABLED&x-id=GetObject)


The accompanying diagram illustrates a Multi-Cloud / Hybrid-Cloud Architecture enabling seamless integration and data flow across private, public, and edge environments, unified through a global network and management plane built on common services.


## 1. Private Cloud / On-Premises Data Center


This represents the enterprise's locally hosted infrastructure.

- **Components:** Includes Virtual Machines, Virtual Managers, Private Storage, multiple Databases, Servers, and Enterprise Applications.
- **Role:** It hosts sensitive or legacy applications and data that may have specific security, compliance, or performance requirements best met by an on-site environment.

## 2. Public Clouds (A and B)


These are external cloud provider services, showcasing a multi-cloud strategy.

- **Public Cloud A (e.g., AWS):** Features core services like Compute (EC2), Storage (S3), Database (RDS), and Analytics.
- **Public Cloud B (Azure / GPC):** Includes services like Virtual Machines, Blob Storage, SQL Database, Machine Learning Services, and other Machine Services.
- **Role:** These clouds offer scalability, elasticity, and specialized services, allowing the organization to run different workloads in the provider best suited for the task or to ensure redundancy.

## 3. Global Network / Interconnect


This is the conduit enabling communication and data transfer between the disparate clouds.

- **Components:** Utilizes technologies like VPN / Direct Connect Interconnect for secure, high-speed links, and an API Gateway to manage and secure access to services exposed by the clouds.
- **Role:** Ensures reliable, secure, and low-latency data and application traffic flow between the Private Cloud and the Public Clouds, effectively creating a single, extended infrastructure.

## 4. Unified Management Plane and Common Services


These layers ensure consistent operation, governance, and security across all environments.


### Unified Management Plane


This is a single control point for operating the entire architecture.

- **Functions:** Includes tools for Monitoring (tracking performance and health), Orchestration (automating deployment and management of resources), and Security (enforcing policies across clouds).

### Common Services


These foundational services are essential for a cohesive environment.

- **Components:** Includes Identity & Access Management (IAM) for consistent authentication and authorization across all clouds, and Data Encryption to secure data both in transit (via the Global Network) and at rest (in storage/databases).
- **Role:** Provides a single, unified experience for users and administrators, ensuring security and compliance policies are applied consistently.

The hybrid architecture ensures seamless integration by allowing the Unified Management Plane and Common Services to manage the movement of data and workloads between the Private Cloud and Public Clouds. This design enables the enterprise to leverage multiple cloud platforms while retaining control over critical on-premises resources.


The 2025 AWS outage was a strategic warning. Investing in multi-cloud resilience, automation, and distributed architectures is key for enterprises to not just survive, but thrive through future disruptions.



Technical Blog

Creating and Using Database Triggers in Supabase