Supabase – real-time databases, authentication services, and file storage

Supabase is an open-source alternative to Firebase, offering real-time databases, authentication services, and file storage.

It is built atop PostgreSQL, providing robust SQL querying capabilities and seamless integration with existing tools and frameworks. Supabase also features an intuitive web interface for effortless management of users and data.

Features include:

• Hosted Postgres Database:
  • Table view – makes Postgres as easy to use as a spreadsheet.
  • Relationships.
  • Clone tables.
  • SQL editor.
• Authentication and Authorization – implement authentication and authorization in your app. There are client SDKs and API endpoints to help you create and manage users.
• Auto-generated APIs.
  • REST – provides a RESTful API using PostgREST:
    • Instant and auto-generated.
    • Self-documenting.
    • Secure.
    • Fast.
    • Scalable
  • GraphQL:
    • Basic CRUD operations (Create/Read/Update/Delete).
    • Support for Tables, Views, Materialized Views, and Foreign Tables.
    • Arbitrarily deep relationships among tables/views.
    • User defined computed fields.
    • Postgres’ security model – including Row Level Security, Roles, and Grants.
  • Realtime subscriptions – provides a globally distributed cluster of Realtime servers that enable the following functionality:
    • Broadcast: Send ephemeral messages from client to clients with low latency.
    • Presence: Track and synchronize shared state between clients.
    • Postgres Changes: Listen to Postgres database changes and send them to authorized clients.
• Functions.
  • Database Functions – built-in support for SQL functions.
  • Edge Functions – server-side TypeScript functions, distributed globally at the edge—close to your users.
• File Storage – use Supabase Storage to store images, videos, documents, and any other file type. Serve your assets with a global CDN to reduce latency from over 285 cities globally. Supabase Storage includes a built-in image optimizer, so you can resize and compress your media files on the fly.
• AI + Vector/Embeddings Toolkit – open source toolkit for developing AI applications using Postgres and pgvector. The toolkit includes:
  • A vector store and embeddings support using Postgres and pgvector.
  • A Python client for managing unstructured embeddings.
  • An embedding generation process using open source models directly in Edge Functions.
  • Database migrations for managing structured embeddings.
  • Integrations with all popular AI providers, such as OpenAI, Hugging Face, LangChain, and more.
• Dashboard.

Website: supabase.com
Support: GitHub Code Repository
Developer: Supabase, Inc.
License: Apache License 2.0

Supabase is written in TypeScript. Learn TypeScript with our recommended free books and free tutorials.

Explore Linux
	Best Free and Open Source Software - A huge collection of recommended free and open source software covering every major category.
	In-depth Linux Software Reviews - Detailed assessments of Linux software covering features, usability and overall quality.
	The Big List of Active Linux Distros - An extensive collection of actively developed Linux distributions.
	Open Source Alternatives - Alternatives to software and services from Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle and others.
	Essential Linux System Tools - Indispensable utilities for monitoring, maintaining and managing Linux systems.
	Linux Productivity Tools - Useful utilities for improving productivity and streamlining everyday tasks.
	Alternatives to Popular CLI Tools - Modern alternatives to familiar command-line utilities supplied with Linux systems.
	Awesome Free Linux Game Tools - Tools, utilities and companion software that improve gaming on Linux.
	Machine Learning on Linux - Machine learning and deep learning software, self-hosted applications and practical tools.
	Saving Money with Linux - Practical ways to reduce electricity consumption and lower computing costs with Linux.
	Linux Candy - Fun, entertaining and sometimes delightfully quirky software from the lighter side of Linux.