Elixir Postgresql

Open-source Elixir projects categorized as Postgresql

Top 12 Elixir Postgresql Projects

  • Plausible Analytics

    Simple, open source, lightweight (< 1 KB) and privacy-friendly web analytics alternative to Google Analytics.

    Project mention: Open Source alternatives to tools you Pay for | dev.to | 2023-12-08

    Plausible - Open Source Alternative to Google Analytics

  • realtime

    Broadcast, Presence, and Postgres Changes via WebSockets

    Project mention: Unpacking Elixir: Observability | news.ycombinator.com | 2023-10-25

    We use :telemetry to collect usage data per tenant for Supabase Realtime.

    We do this for rate limiting but it also makes it very easy for us to attach a listener (https://github.com/supabase/realtime/blob/main/lib/realtime/...) which ships these (per second) aggregates to BigQuery (via Logflare), which then the billing team can aggregate further to display and actually bill people with.

  • Onboard AI

    Learn any GitHub repo in 59 seconds. Onboard AI learns any GitHub repo in minutes and lets you chat with it to locate functionality, understand different parts, and generate new code. Use it for free at www.getonboard.dev.

  • electric

    Local-first sync layer for web and mobile apps. Build reactive, realtime, local-first apps directly on Postgres.

    Project mention: Show HN: PowerSync – Bi-directional Postgres<>SQLite sync for offline-first apps | news.ycombinator.com | 2023-11-30

    Yup, this is correct.

    We have had some requests / discussions around adding hooks to the sync service that will support custom logic on the write path (as per https://github.com/electric-sql/electric/discussions/565). This seems like a good idea but they don't exist yet.

  • changelog.com

    Changelog is news and podcast for developers. This is our open source platform.

    Project mention: Ask HN: How does your CI/CD stack look like today? | news.ycombinator.com | 2023-07-30

    Another https://dagger.io fan here. Have been using it since late 2021 to continuously deploy a Phoenix app to Fly.io: https://github.com/thechangelog/changelog.com/pull/395. Every commit goes into production.

    This is what the GHA workflow currently looks like: https://github.com/thechangelog/changelog.com/blob/c7b8a57b2...

    FWIW, you can see how everything fits together in this architecture diagram: https://github.com/thechangelog/changelog.com/blob/master/IN...

  • supavisor

    A cloud-native, multi-tenant Postgres connection pooler.

    Project mention: PgBouncer 1.21.0 released with prepared statement support | news.ycombinator.com | 2023-10-16

    PgBouncer maintainer here, so obviously biased. But I think currently PgBouncer should still be the default connection pooler that you choose. There's a few newer options: Odyssey, pgcat, and supavisor. But all focus on a solving 1 or 2 specific problems that PgBouncer did not solve well, while not solving many of the other problems that PgBouncer does solve. So if you have the exact same requirements as the authors of those tools, then switching might be good. But otherwise you should probably continue using PgBouncer.

    Supavisor specifically is really immature. It's missing some really core functionality like query cancellations: https://github.com/supabase/supavisor/issues/174

    I did a talk on this exact topic at PGConf NYC recently. My slides are here: https://github.com/JelteF/slides/raw/main/2023-10-05-future-...

  • eventstore

    Event store using PostgreSQL for persistence (by commanded)

  • trans

    Embedded translations for Elixir

  • InfluxDB

    Collect and Analyze Billions of Data Points in Real Time. Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.

  • walex

    Listen to Postgres change events and do stuff with the data directly in Elixir

    Project mention: All the ways to capture changes in Postgres | news.ycombinator.com | 2023-09-22

    If you're using Elixir, check out https://github.com/cpursley/walex

    I've actually been thinking about turning this idea into a product where you can just point it at your postgres database and select the tables you want to listen to (with filters, like you describe). And have that forwarded to a webhook (with possibility of other protocols).

    I'd love to hear folks thoughts on that (and if it would be something people would pay for).

  • ayesql

    Library for using raw SQL in Elixir

  • yggdrasil

    Subscription and publishing server for Elixir applications. (by gmtprime)

  • yesql

    An Elixir library for using SQL. (by lpil)

  • backend-frameworks

    Backend frameworks

NOTE: The open source projects on this list are ordered by number of github stars. The number of mentions indicates repo mentiontions in the last 12 Months or since we started tracking (Dec 2020). The latest post mention was on 2023-12-08.

Elixir Postgresql related posts


What are some of the best open-source Postgresql projects in Elixir? This list will help you:

Project Stars
1 Plausible Analytics 16,944
2 realtime 6,225
3 electric 3,396
4 changelog.com 2,616
5 supavisor 1,299
6 eventstore 985
7 trans 219
8 walex 163
9 ayesql 126
10 yggdrasil 103
11 yesql 81
12 backend-frameworks 6
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives