- 8
- 35 227
Mark Burggraf
United States
เข้าร่วมเมื่อ 18 มิ.ย. 2021
Supabase: Full Text Search with PostgreSQL
This video covers full text search queries using PostgreSQL, the world's most powerful open source database that powers Supabase. It covers:
Basic full text search using one or multiple source columns
Creating queries with AND and OR filters
Indexing columns for creating efficient full text search queries that scale
Additional operators for searching exact phrases, proximity searches, negation, and performing complex search filters
Basic full text search using one or multiple source columns
Creating queries with AND and OR filters
Indexing columns for creating efficient full text search queries that scale
Additional operators for searching exact phrases, proximity searches, negation, and performing complex search filters
มุมมอง: 3 266
วีดีโอ
Supabase Authentication: Setting up Apple Auth
มุมมอง 7K3 ปีที่แล้ว
How to set up Apple OAuth for your Supabase application so your users can click a button to authenticate using their Apple account. Source code for secret_gen.rb: gist.githubusercontent.com/janakamarasena/cb1ebb4abec8c903329cb25ecb6fe562/raw/527a92902abbbca01bfb025a544580275f6f8b44/secret_gen.rb Royalty free music from www.FesliyanStudios.com Ruby Documentation: www.ruby-lang.org ruby-jwt libra...
Supabase Authentication: Setting up Gitlab Auth
มุมมอง 5683 ปีที่แล้ว
How to set up Gitlab OAuth for your Supabase application so your users can click a button to authenticate using their Gitlab account. Royalty free music from www.FesliyanStudios.com
Supabase Authentication: Setting up Bitbucket Auth
มุมมอง 1273 ปีที่แล้ว
How to set up Bitbucket OAuth for your Supabase application so your users can click a button to authenticate using their Bitbucket account. Royalty free music from www.FesliyanStudios.com
Supabase Authentication: Setting up Github Auth
มุมมอง 1.4K3 ปีที่แล้ว
How to set up Github OAuth for your Supabase application so your users can click a button to authenticate using their Github account.
Supabase Authentication: Setting up Google Auth
มุมมอง 17K3 ปีที่แล้ว
How to set up Google OAuth for your Supabase application so your users can click a button to authenticate using their Google account. Royalty free music from www.FesliyanStudios.com
Supabase Authentication: Setting up Facebook Auth
มุมมอง 4.6K3 ปีที่แล้ว
How to set up Facebook OAuth for your Supabase application so your users can click a button to authenticate using their Facebook account. Royalty free music from www.FesliyanStudios.com
Supabase Authentication: Setting up Twitter Auth
มุมมอง 1.6K3 ปีที่แล้ว
How to set up Twitter OAuth for your Supabase application so your users can click a button to authenticate using their Twitter account.
They have made this process a lot more complicated now
I love you, you're a lifesaver. Also, if you're developing locally and you get this error ERROR Apple login error: Unacceptable audience in id_token: [host.exp.Exponent] you need to add "host.exp.Exponent" to your client Id's in the supabase dashboard
It works well!! thx xD
Can you please remake this tutorial with the new developers Apple design?
absolute legend.
Believe me or not after spend 40+ tabs I was stuck at this secret key generation , save my hours thank you a lots , SUBSCRIBEDDDDDDDDDDDDDDDDDDDDDDD
Life saver
alter table books add column fts tsvector generated always as (to_tsvector('english', description || ' ' || title)) stored; enerated always as: generated always as: Indicates that the fts column is to be generated automatically from an expression. You cannot manually insert values into this column; They will be calculated every time a record is inserted or updated.
Saviour 😍
dude, i do not know why Supabase delivered a hidden feature that has no doc, but you saved my day! Thanks!
thank you :)
thanks for this but holy shit why does apple make you do all this
same my day!
Quick questin - if I have prod & dev, is that fine by apple to have two services for one app?
Thanks
Please dont add the annoying background music to your videos. It is distracting and serves no purpose whatsoever.
Thank you, Mark 🥰 In my case, when I copied the Apple Developer ID from the top corner of the website and, instead of installing the gem, pasted it into the Supabase tool (found in their auth documentation) to generate a new Apple client secret, the Apple Developer ID was not respecting capital letters. It took me quite a while to figure it out. 🥲 Be careful, people!
hey mark thanks for this. Im using NextJS with supabase. Right now I'm using the basics to signup and sign in, however, I'm planning to have a google auth, do you plan to have a signup too?
How do we get the access_token_secret?
How to import code JavaScript? Help me!
ananskim senin oe
This guy should get paid by Supabase AND Apple. Both are confusing for such info
Great video, in my case it only worked when I put the app Bundle ID in Apple client ID, not the sevice
Good observation
Oh man, thank you. I was missing the part where I configure the services id.
Thank you for your tutorial. I was wondering whether you have used FlutterFlow before? If I use the native Google Authentication service in FlutterFlow and then want to use my app to then log into Supabase, would it be possible to that in the way that you have explained? The reason why I would want to do this, is because that gives one the ability to separate PII user data from transactional data. Any thoughts on how I can achieve that?
Sadly out of date video now
Thanks for the great tutorial!
So there is no "sign up" necessary if the user wants to use a third-party provider such as Google?
Is sign up necessary?
men thank you so much for this video !
Make more videos on react and supabase
no need of background mussing
Beautiful. Thank you
I did same steps and I got invalid _client
What were you using to run the client side?
For the invalid client error message, make sure your Supabase Apple Client ID matches the com.xxxx that you set up in the Apple Developer configuration. (7:00) and that all other configuration values are correct.
Nice Tut but it would be nice if you would show the auth process in action...
Dude! What is this loud background music?
Mute + enabled CC :/
please show how to do it for android/ios (not web!!!)
Still waiting
horrible music for good content like this.
Thanks man, I struggled with FB login config, I was missing the redirect url :)
you saved my life 😅🙏
Lose the music! What a distraction. What's the purpose of it here??
Nice tut, thank you. That music is really distracting and loud. Personally don't like the piano, but I get what you're trying to do. A good example of well done tuts w music is Fireship, in case you're interested.
i am still getting error after logging in with google provider, it's I gues cors error, how do I fix it?
Amazing tutorial, if you lower the music a bit it would perfect.
Great tutorial. Please get rid of the background music. It distracts from learning.
Excellent! thanks
Good job!! Thank you so much !!
Glad you’re enjoying these. Here are the written guides I’ve done: supabase.io/docs/guides/auth/auth-github
@@markburggraf9895 thank you!