Open Source Elixir Database Software for Mac

Supabase is an open-source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage. Every project is a full Postgres database, the world's most trusted relational database. Add user sign ups and logins, securing your data with Row Level Security. Store, organize, and serve large files. Any media, including videos and images. Write custom code without deploying or scaling servers. Supported by a network of early advocates, contributors, and champions. We introspect your database to provide APIs instantly. Stop building repetitive CRUD endpoints and focus on your product. Type definitions built directly from your database schema. Use Supabase in the browser without a build process. Develop locally and push to production when you're ready.

Ecto is the official Elixir library that serves as a database wrapper and integrated query system, enabling developers to define schemas, construct and execute type-safe queries, manage database migrations, and validate data via changesets; it is the foundational tool for working with relational databases in Elixir. Note that mix test does not run the tests in the integration_test folder. To run integration tests, you can clone ecto_sql in a sibling directory and then run its integration tests with the ECTO_PATH environment variable pointing to your Ecto checkout. Support for database migrations (version-controlled schema changes).

Sequin is a change data capture (CDC) system that replicates API data to Postgres in real time. It syncs services like Stripe, Salesforce, and GitHub into PostgreSQL tables, enabling developers to query third-party data with standard SQL. Sequin is ideal for building data-driven applications that need immediate visibility into external SaaS platforms.

Commanded EventStore is an Elixir-based event store built for event-sourced systems using the Commanded framework. It stores domain events as immutable facts and provides mechanisms for publishing, persisting, and querying events. Built with PostgreSQL as its backend, it ensures strong consistency and is optimized for CQRS architectures.

Supavisor is a high-performance Postgres connection pooler designed for multi-tenant environments, built in Rust by the Supabase team. It acts as a gateway that routes and manages database connections for each tenant, supporting row-level isolation and optimized connection sharing. Supavisor is ideal for SaaS platforms needing efficient, scalable multi-tenancy over PostgreSQL.