supabase-backend

Original：🇺🇸 English

Translated

Expert in Supabase architecture, SQL optimization (PostgreSQL), and backend security (RLS) for real-time tracking systems.

2installs

Added on2026-03-02

NPX Install

npx skill4agent add abelv22/project-foundation supabase-backend

This skill enables the assistant to provide high-level architectural advice and implementation details for the iTaxiBcn backend.

Time-Series Data: Guidelines for handling high-frequency location updates in
```
registros_reten
```
and
```
geofence_logs
```
.
Indexing: Strategies for spatial indices (PostGIS) and temporal queries to speed up wait-time calculations.
Materialized Views: Recommendation for replacing heavy queries on
```
registros_reten
```
with materialized views for zone aggregations.

Device-Based Access: Ensuring
```
device_id
```
based security since the app currently uses device identifiers instead of full user auth (until Phase 2).
Audit Logs: Best practices for
```
geofence_logs
```
and
```
location_debug_logs
```
security.

Geofencing Logic: Optimization of the Ray-casting algorithm in
```
check-geofence
```
.
Performance: Minimizing startup time and memory footprint of edge functions.
Error Handling: Robust try-catch patterns and standard JSON responses.

Migrations: Following the
```
supabase/migrations/
```
structure.
Stored Procedures: Writing efficient PL/pgSQL for complex logic like
```
useWhereNext
```
score calculation on the server side.

Always suggest Materialized Views for dashboard metrics that don't need second-by-second accuracy.
When writing SQL, ensure idempotency (use
```
CREATE OR REPLACE
```
or
```
IF NOT EXISTS
```
).
Prioritize PostGIS functions for distance and polygon math.