Overview of RDS Supabase Applications

Supabase is an open-source alternative to Firebase. It is a full-stack Backend as a Service (BaaS) platform built on PostgreSQL. It provides features such as databases, identity authentication, real-time subscriptions, storage, Edge Functions, and vector search. It enables developers to quickly build application backend logic without spending weeks setting up complex backends, databases, and servers. Unlike Firebase, which uses a NoSQL database, Supabase is built on the enterprise-grade relational database PostgreSQL.

Supabase integrates mature open-source tools into a unified development platform and provides the following core capabilities:

• PostgreSQL database
  • Hosts an independent PostgreSQL database that provides complete SQL capabilities, not a simplified version.
  • Supports JSONB, full-text search, views, stored procedures, triggers, and SQL visualization.

• Auto-generate APIs
  • Automatically generates secure, instant RESTful and GraphQL APIs when database tables are created.
• Real-time subscriptions
  • Listens for database changes through WebSockets, allowing you to easily build collaborative applications, chat applications, dashboards, and other real-time features.
  • Supports INSERT, UPDATE, and DELETE events, as well as Presence (online status) and Broadcast (message broadcasting).
• Storage
  • Interconnects with Huawei Cloud Object Storage Service (OBS) to store and serve large files such as videos and images.
  • Provides file-level access control based on Row Level Security (RLS) and supports resumable transfer of large files.
  • Provides image conversion and resizing with built-in CDN support.
• Vector and AI (Vecs/pgvector)
  • Includes the built-in pgvector extension to store and query vector embeddings directly within PostgreSQL.
  • Eliminates the need for an additional vector database, simplifying AI application architecture.