supabase-mailer
Send and track email from Supabase / PostgreSQL using a Transactional Email Provider (by burggraf)
pg_cron
Run periodic jobs in PostgreSQL (by citusdata)
Our great sponsors
supabase-mailer | pg_cron | |
---|---|---|
11 | 20 | |
182 | 2,545 | |
- | 3.9% | |
1.1 | 6.1 | |
4 months ago | 4 days ago | |
PLpgSQL | C | |
- | PostgreSQL License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
supabase-mailer
Posts with mentions or reviews of supabase-mailer.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-05-10.
-
Looking for contributors for StaticBackend, a backend API in Go
Supabase developer here. Just to clarify, Supabase has server-side functions (edge functions), emails can be sent with something like my repo here (https://github.com/burggraf/supabase-mailer) or through edge functions -- but you're right, while we do have the ability to send any auth-related emails built-in (sign up, sign in with magic link, MFA, reset password, etc.) we don't have an out-of-the-box solution for sending emails, that's why I wrote that repo. And lastly, it's quite easy to schedule tasks using pg_cron, which is built into every Supabase project by default.
-
Modifying Email Remotely
Hello, I've tried these instructions https://github.com/burggraf/supabase-mailer/blob/main/Mail_Providers/Sendgrid.md when I tried to execute the first line INSERT INTO private.keys (key, value) values ('SENDGRID_API_KEY', 'aaaaaaaaaa'); in SQL editor (with my API key) in Supabase I've got this error: "Failed to run sql query: relation "private.keys" does not exist"
-
Edge Functions or Database Functions?
Here's a repo where I use the http extension extensively: https://github.com/burggraf/supabase-mailer
-
Sending Email From Postgres
I was excited to find the supabase-mailer project, but unfortunately it seems that only the Mailgun provider is fully supported and working. Mailgun only has a 30 day trial, which didn't work for my needs.
-
How to send Emails from Supabase in case of an event?
You can't call the http function like that. You need to use a SELECT statement. See https://github.com/burggraf/supabase-mailer/blob/main/02A_send_email_mailgun.sql for an example: SELECT content INTO retval FROM http (('POST', ....etc
-
Functions?
I'm not 100% sure you could do this with PostgreSQL functions, but you probably can. Since we have http access from these functions, I've written interfaces to some of the transactional email apis here: https://github.com/burggraf/supabase-mailer . (It's probably even easier if you use straight SMTP mailers.)
- Questions about sending emails
-
Open source Firebase alternative (Supabase) raises $30M Series A
Not sure what you mean. I have a couple open-source repos on github that show you how you can send emails or text messages from a Postgres function using third-party providers. I also have a repo that shows how you could roll your own auth using functions. Assigning permissions and roles is definitely something you can do in functions -- that's standard postgres stuff....
pg_cron
Posts with mentions or reviews of pg_cron.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-06-09.
-
Supabase Beta May 2023
[Postgres Extensions] pg_cron 1.5.2 (new projects only) now supports sub-minute schedules. PR
-
🏺Database Architecture - History Over State
(Your PostgreSQL installation might already have pg_cron available, but if not, you would need to install it)
- Edge Functions or Database Functions?
-
Upgrading to PostgreSQL 15 on Mac OS
I’d set up citusdata/pg_cron in 14, so I’ll need to set that up in 15 as well.
-
PostgreSQL Functions in Typescript
Functions can be executed via a database query or on a regular schedule. Trigger functions are a special type of function that are covered in a previous article. They provide a way to execute an action based on a database event.
-
Pulling Cloud API data to PostgreSQL server (Supabase)
* extraction and loading: the psql-http PostgreSQL extension which is available in Supabase (but not all services like AWS RDS). Not sure how it works with OAuth but something to look into. * automation: use pg_cron to automate the ingest. * transformation: leverage Postgresql JSON functions.
- How to : trigger a MV refresh after another MV refreshed ?
-
Is it conventional to use Redis in an authentication service?
A low-level alternative is using a PostgreSQL-side facility like https://github.com/citusdata/pg_cron - this, however, requires installing a PostgreSQL extension.
- Como agendar execução de consultas e comandos pelo PostgreSQL no RDS
-
Do you know of a robust library that handles persistent job scheduling and queuing using PostgreSQL
If you just want scheduling queries, you can use this https://github.com/citusdata/pg_cron
What are some alternatives?
When comparing supabase-mailer and pg_cron you can also consider the following projects:
SupaScript
pg_timetable - pg_timetable: Advanced scheduling for PostgreSQL
plv8 - V8 Engine Javascript Procedural Language add-on for PostgreSQL
pg_dbms_job
pgsql-http - HTTP client for PostgreSQL, retrieve a web page from inside the database.
pg_background - pg_background
supabase-roll-your-own-auth - Custom Supabase authentication using PostgreSQL functions
Spring Boot - Spring Boot
supabase-sms - Send and receive sms messages from Supabase / PostgreSQL using a Transactional SMS Provider
docker-pg-cron - Dockerfile with extension pg_cron
supabase - The open source Firebase alternative.
Express - Fast, unopinionated, minimalist web framework for node.
supabase-mailer vs SupaScript
pg_cron vs pg_timetable
supabase-mailer vs plv8
pg_cron vs pg_dbms_job
supabase-mailer vs pgsql-http
pg_cron vs pg_background
supabase-mailer vs supabase-roll-your-own-auth
pg_cron vs Spring Boot
supabase-mailer vs supabase-sms
pg_cron vs docker-pg-cron
supabase-mailer vs supabase
pg_cron vs Express