What are /r/Supabase's favorite Products & Services?

From 3.5 billion Reddit comments

Supabase developer here. All the examples in the Supabase documentation are already asynchronous by default, using the async/await pattern. For example:

https://supabase.io/docs/reference/javascript/select

const { data, error } = await supabase
.from('cities')
.select();
if (error) { console.error('we got an error:', error); }
else { console.log('we got data:', data);

check out the "Policies with Joins" here: https://supabase.io/docs/guides/auth#policies-with-joins

It looks like you are storing the "text" in the author table though - is that correct? Perhaps there should be a table like "posts" which has an author_id?

create table posts ( id serial primary key, content text, author_id uuid references auth.users.id );

?

I'd recommend checking out the examples and guides: https://supabase.io/docs/guides/examples

There are plenty of tutorials there, in both written and video format.

You could also try out the QuickStart in the API Docs which explains how to create tables and query them: https://supabase.io/docs/guides/api#getting-started

I use generated types (https://supabase.io/docs/reference/javascript/generating-types) with Typescript on tables. Is there a way to generate types for views?

Hey @MathematicianWhole29, we're working on Workflows first, which will be the "co-ordinator" of the functions

https://supabase.io/blog/2021/04/02/supabase-workflows

Should have something released by next quarter

It's Free, 25$ Pro and Pay as you go 25$ + usage costs
For me they are offering a very good value for the price, especially considering that they have just entered the beta phase.

https://supabase.io/pricing

Hi folks, Rory from Supabase here.

Sorry for any confusion caused. We have been building furiously to ship features for launch week. This led to an internal communication error for a change to the pricing page.

To clarify, Pay As You Go still starts at $25 per project per month, plus usage. We have updated the Pay As You Go tier (back to the previous pricing) and added a clarification for optimized database instances to include "starting at $50 per project per month".

This is for our enterprise users. They are already aware of this change as we worked with them to understand what this figure should be based on their needs. This change is now updated on our pricing page, and we have now included a changelog at the bottom of the page. For any future changes to the pricing page, we will email every single user.

I have included a link to the updated pricing page and the PR below :)
https://supabase.io/pricing

https://github.com/supabase/supabase/commit/b42019e09a55ac0073c1501f5551b0d4087399e4

you'll want to filter on the subscription itself https://supabase.io/docs/reference/javascript/subscribe#listening-to-row-level-changes

like

const mySubscription = supabase
  .from('countries:id=eq.200')
  .on('UPDATE', handleRecordUpdated)
  .subscribe()

Hey everyone!

I've got a question, hopefully someone knows the solution, if there is one. I had the idea to create additional schemas to group related tables together. So namespaces, basically.

I created a schema reports and a table reports.unsuppressed_inventory_data, however I have not been able to insert data using the supabase client. Can the client only be used to interact with the public schema? I tried some some things like GRANT USAGE ON SCHEMA public TO postgres; I also fiddled around with some PRIVILEGES stuff, but to no avail.

The supabase docs mention Schemas (https://supabase.io/docs/reference/postgres/schemas) and no word about issues regarding the client. Am I missing something?

You’ll get it, hang in there! SQL is actually a lot of fun.

Read up on doing “joins” or in this case it’s an “INNER JOIN”. You join the two tables using an expression (usually a simple matching field like auth.users.id = public.profile.id but it can be more complex).

Once the tables are “joined” you can think of it like adding a bunch of columns to your spreadsheet. Now you have access to all the columns from both of those tables and you can select individual fields from them:

select auth.users.email, public.profile.webpage from ….

Or you can filter on these fields with a where clause:

… where public.profile.webpage = ‘https://supabase.io’ or auth.users.email like ‘%@supabase.io’

PostgreSQL has complex data types available.

https://supabase.io/blog/2021/02/27/cracking-postgres-interview#know-how-to-use-pg-rich-type-system-arrays-domains-jsonb-timestamptz-enums

One of the extensions to PostgreSQL that Supabase makes available is intarray:

https://supabase.io/docs/guides/database#extensions

Do you have a timeline on when security for realtime data will be available? I noticed the docs say Q1 2021. And is there a page somewhere tracking in-progress and/or planned upcoming work?