SaaSHub helps you find the best software and product alternatives Learn more →
Top 12 Elixir Postgresql Projects
-
Plausible Analytics
Simple, open source, lightweight (< 1 KB) and privacy-friendly web analytics alternative to Google Analytics.
Plausible - Open Source Alternative to Google Analytics
-
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-30Yup, 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.
-
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...
-
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-...
-
-
-
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.
-
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).
-
-
-
-
Elixir Postgresql related posts
- Electric SQL – Local-first sync layer for web and mobile apps
- Unpacking Elixir: Observability
- PgBouncer 1.21.0 released with prepared statement support
- YOU MUST SEE IT! Electric SQL
- All the ways to capture changes in Postgres
- Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps
- Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps
-
A note from our sponsor - #<SponsorshipServiceOld:0x00007f0fa168ff80>
www.saashub.com | 9 Dec 2023
Index
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 |