Mark Burggraf
Mark Burggraf
  • 8
  • 35 227
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
มุมมอง: 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.

ความคิดเห็น

  • @freddy7304
    @freddy7304 2 วันที่ผ่านมา

    They have made this process a lot more complicated now

  • @haydenthai935
    @haydenthai935 15 วันที่ผ่านมา

    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

  • @jakshim365
    @jakshim365 27 วันที่ผ่านมา

    It works well!! thx xD

  • @revistayounges
    @revistayounges หลายเดือนก่อน

    Can you please remake this tutorial with the new developers Apple design?

  • @michaeldausmann6066
    @michaeldausmann6066 2 หลายเดือนก่อน

    absolute legend.

  • @devx-s9l
    @devx-s9l 2 หลายเดือนก่อน

    Believe me or not after spend 40+ tabs I was stuck at this secret key generation , save my hours thank you a lots , SUBSCRIBEDDDDDDDDDDDDDDDDDDDDDDD

  • @saifcodes
    @saifcodes 3 หลายเดือนก่อน

    Life saver

  • @luisdelo97
    @luisdelo97 3 หลายเดือนก่อน

    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.

  • @DileeshaWeliwaththa
    @DileeshaWeliwaththa 4 หลายเดือนก่อน

    Saviour 😍

  • @albertgao7256
    @albertgao7256 5 หลายเดือนก่อน

    dude, i do not know why Supabase delivered a hidden feature that has no doc, but you saved my day! Thanks!

  • @Krasipeace
    @Krasipeace 5 หลายเดือนก่อน

    thank you :)

  • @CC-xv7hf
    @CC-xv7hf 6 หลายเดือนก่อน

    thanks for this but holy shit why does apple make you do all this

  • @Zero-vn8yy
    @Zero-vn8yy 6 หลายเดือนก่อน

    same my day!

  • @casperon7
    @casperon7 6 หลายเดือนก่อน

    Quick questin - if I have prod & dev, is that fine by apple to have two services for one app?

  • @casperon7
    @casperon7 6 หลายเดือนก่อน

    Thanks

  • @keithlaaks5611
    @keithlaaks5611 7 หลายเดือนก่อน

    Please dont add the annoying background music to your videos. It is distracting and serves no purpose whatsoever.

  • @enqvida
    @enqvida 7 หลายเดือนก่อน

    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!

  • @appstuff6565
    @appstuff6565 7 หลายเดือนก่อน

    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?

  • @Dev_cent
    @Dev_cent 8 หลายเดือนก่อน

    How do we get the access_token_secret?

  • @Theusdogta
    @Theusdogta 8 หลายเดือนก่อน

    How to import code JavaScript? Help me!

  • @puruzsuz31
    @puruzsuz31 8 หลายเดือนก่อน

    ananskim senin oe

  • @Timekeeper20239
    @Timekeeper20239 9 หลายเดือนก่อน

    This guy should get paid by Supabase AND Apple. Both are confusing for such info

  • @alex15996-ro
    @alex15996-ro 10 หลายเดือนก่อน

    Great video, in my case it only worked when I put the app Bundle ID in Apple client ID, not the sevice

    • @vicktorManuel
      @vicktorManuel 8 หลายเดือนก่อน

      Good observation

  • @Zubaz
    @Zubaz 11 หลายเดือนก่อน

    Oh man, thank you. I was missing the part where I configure the services id.

  • @larryvdwalt
    @larryvdwalt ปีที่แล้ว

    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?

  • @michealmclaughlin429
    @michealmclaughlin429 ปีที่แล้ว

    Sadly out of date video now

  • @DrewConley
    @DrewConley ปีที่แล้ว

    Thanks for the great tutorial!

  • @randomtimessomehow
    @randomtimessomehow ปีที่แล้ว

    So there is no "sign up" necessary if the user wants to use a third-party provider such as Google?

  • @julien8097
    @julien8097 ปีที่แล้ว

    men thank you so much for this video !

  • @jittojoyes7533
    @jittojoyes7533 ปีที่แล้ว

    Make more videos on react and supabase

  • @tapasgaming5575
    @tapasgaming5575 ปีที่แล้ว

    no need of background mussing

  • @tyfiero
    @tyfiero ปีที่แล้ว

    Beautiful. Thank you

  • @nouhbelahcen4486
    @nouhbelahcen4486 2 ปีที่แล้ว

    I did same steps and I got invalid _client

    • @benmajkut618
      @benmajkut618 ปีที่แล้ว

      What were you using to run the client side?

    • @skfh82
      @skfh82 7 หลายเดือนก่อน

      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.

  • @sleeplessfox1778
    @sleeplessfox1778 2 ปีที่แล้ว

    Nice Tut but it would be nice if you would show the auth process in action...

  • @howesteve
    @howesteve 2 ปีที่แล้ว

    Dude! What is this loud background music?

    • @Nurpie
      @Nurpie ปีที่แล้ว

      Mute + enabled CC :/

  • @ChristianAlmeidabr
    @ChristianAlmeidabr 2 ปีที่แล้ว

    please show how to do it for android/ios (not web!!!)

  • @bernardcrnkovic3769
    @bernardcrnkovic3769 2 ปีที่แล้ว

    horrible music for good content like this.

  • @olekzaytsev3582
    @olekzaytsev3582 2 ปีที่แล้ว

    Thanks man, I struggled with FB login config, I was missing the redirect url :)

  • @stvlley
    @stvlley 2 ปีที่แล้ว

    you saved my life 😅🙏

  • @JeffreyMRose
    @JeffreyMRose 2 ปีที่แล้ว

    Lose the music! What a distraction. What's the purpose of it here??

  • @davidkim2016
    @davidkim2016 2 ปีที่แล้ว

    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.

  • @rutik42
    @rutik42 3 ปีที่แล้ว

    i am still getting error after logging in with google provider, it's I gues cors error, how do I fix it?

  • @cappuccinopapi3038
    @cappuccinopapi3038 3 ปีที่แล้ว

    Amazing tutorial, if you lower the music a bit it would perfect.

  • @rnarayan98
    @rnarayan98 3 ปีที่แล้ว

    Great tutorial. Please get rid of the background music. It distracts from learning.

  • @JoseAlvarez-uo7fg
    @JoseAlvarez-uo7fg 3 ปีที่แล้ว

    Excellent! thanks

  • @northstarHQ
    @northstarHQ 3 ปีที่แล้ว

    Good job!! Thank you so much !!

    • @markburggraf9895
      @markburggraf9895 3 ปีที่แล้ว

      Glad you’re enjoying these. Here are the written guides I’ve done: supabase.io/docs/guides/auth/auth-github

    • @northstarHQ
      @northstarHQ 3 ปีที่แล้ว

      @@markburggraf9895 thank you!