pg_cron
supabase-js
pg_cron | supabase-js | |
---|---|---|
20 | 28 | |
2,558 | 2,819 | |
2.4% | 2.8% | |
5.8 | 8.2 | |
10 days ago | 9 days ago | |
C | TypeScript | |
PostgreSQL License | MIT License |
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.
pg_cron
-
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
supabase-js
- Chrome Extension MV3 Template : Supabase Auth, Plasmo, Tailwinds CSS & Shadcn UI
-
Supabase Beta May 2023
[Edge Functions] Custom domains and vanity domains support for Edge Functions. PR
-
How do errors look like? Handling errors.
First of all, the code you provided is not directly supabase, but is whatever is provided from the javascript library. The auth part is then redirecting to the gotrue-js library, and as seen here [Gotrue-JS#L238] it returns a `Promise` and that specific type is declared here Where we see it could be two return types. ```ts | { data: { user: User | null session: Session | null } error: null } | { data: { user: null session: null } error: AuthError }
-
Authentication in Next.js with Supabase and Next 13
Next up, Supabase released v2 of their JavaScript client library (supabase-js), which brought with it a number of developer experience type improvements, and streamlined how we use some of the API's. A number of methods were also deprecated in this new release, which we'll cover later in this guide.
-
Develop a Cryptocurrency Tracking WebApp with Instant Email Notifications
We install the Supabase client library and also Chakra-UI which we will be using to build our React components.
-
Sign in with Apple using Supabase and Ionic Angular
The last part is the easiest as we simply need to connect Supabase to our Ionic app and call one function. Get started by bringing up a new Ionic app and install the Supabase JS client:
- Lucia, the authentication library for SvelteKit, had tons of updates in the last month - It now supports the latest version of SvelteKit and allows you to run load functions in parallel for faster load times (even when using auth)!
-
Using env. variables without VITE_ prefix
Under src/lib I have a .ts file where I create a supabase client inside.
-
Building In Public: Cartta Tech Stack
First and foremost, the language and framework – Typescript & React. Typescript is a must for a project of this size. It provides safety and peace of mind as I iterate quickly to solve bugs and add new features. React is a by-product of the next two things I will mention, Next and Remix. Both of these are higher abstractions on top of React and supply incredible tooling to build fast server side rendered applications. Picking one or the other was driven by my database and auth provider, Supabase. I could have tried to make it work with Remix, but there was already an authentication helper for Next from the Supabase community so I decided on Next. Still using Remix for this current website since I do love Remix so much.
-
Idea Validation - No Code RestAPI creator from relational DB
Have a look at https://postgrest.org/en/stable/. They do something in this direction and e.g. supabase.io uses them. Their approach is, if you have a database you have a REST API.
What are some alternatives?
pg_timetable - pg_timetable: Advanced scheduling for PostgreSQL
storage - S3 compatible object storage service that stores metadata in Postgres
pg_dbms_job
Grafana - The open and composable observability and data visualization platform. Visualize metrics, logs, and traces from multiple sources like Prometheus, Loki, Elasticsearch, InfluxDB, Postgres and many more.
pg_background - pg_background
DefinitelyTyped - The repository for high quality TypeScript type definitions.
Spring Boot - Spring Boot
auth - A JWT based API for managing users and issuing JWT tokens
docker-pg-cron - Dockerfile with extension pg_cron
supabase-nextjs-auth - Example project implementing authentication, authorization, and routing with Next.js and Supabase
Express - Fast, unopinionated, minimalist web framework for node.
platforms - A full-stack Next.js app with multi-tenancy and custom domain support. Built with Next.js App Router and the Vercel Domains API.