Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality. Learn more →
Top 11 Elixir Postgresql Projects
-
Plausible Analytics
Simple, open source, lightweight (< 1 KB) and privacy-friendly web analytics alternative to Google Analytics.
-
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
# Function to get Plausible Analytics timeseries data def get_plausible_timeseries_data(): # Calculate the date range for the last 90 days date_to = datetime.today().strftime('%Y-%m-%d') date_from = (datetime.today() - timedelta(days=90)).strftime('%Y-%m-%d') # Setting the metrics we want to look at metrics='visitors,pageviews' # Actually pulling the data we want url = f"https://plausible.io/api/v1/stats/timeseries?site_id={site_id}&period=custom&date={date_from},{date_to}&metrics={metrics}" headers = { "Authorization": f"Bearer {api_key}" } response = requests.get(url, headers=headers) data = response.json() # Putting the data into a dataframe we can use for analysis results = data['results'] df = pd.DataFrame(results) # Adjusting the date field so we can avoid future warnings and be more accurate df['date'] = pd.to_datetime(df['date']) return df
Project mention: Reliably syncing database and frontend state: A realtime competitor analysis | dev.to | 2024-05-16Supabase has a feature called Postgres Changes, which is part of their realtime product offering. It allows you to listen to changes that happen in a single table, and send those changes to clients that are allowed to receive them.
Project mention: Ask HN: How does your CI/CD stack look like today? | news.ycombinator.com | 2023-07-30Another 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...
WalEx instead of pub/sub (listen/subscribe): https://github.com/cpursley/walex
Supavisor connection pooler: https://github.com/supabase/supavisor
Project mention: How to Collapse Your Stack Using PostgreSQL for Everything | news.ycombinator.com | 2024-05-20Check out WalEx for this: https://github.com/cpursley/walex
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).
Elixir Postgresql related posts
-
Reliably syncing database and frontend state: A realtime competitor analysis
-
Postgres as Queue
-
A Technical Dive into PostgreSQL's replication mechanisms
-
Supavisor 1.0: a scalable connection pooler for Postgres
-
Supabase Studio: AI Assistant and User Impersonation
-
Electric SQL – Local-first sync layer for web and mobile apps
-
Unpacking Elixir: Observability
-
A note from our sponsor - InfluxDB
www.influxdata.com | 24 May 2024
Index
What are some of the best open-source Postgresql projects in Elixir? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Plausible Analytics | 18,611 |
| 2 | realtime | 6,498 |
| 3 | changelog.com | 2,670 |
| 4 | supavisor | 1,607 |
| 5 | eventstore | 1,013 |
| 6 | walex | 259 |
| 7 | trans | 227 |
| 8 | ayesql | 131 |
| 9 | yggdrasil | 104 |
| 10 | yesql | 80 |
| 11 | backend-frameworks | 6 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com