No video :(

⚡️4mins Supabase: Get a Random Row out of Supabase with Table Views

Подписаться 2,2 тыс.

Просмотров 3 тыс.

50% 1

It's not necessarily intuitive to get a random row out of Supabase. That's because currently PostgREST does not support it hence supabase-js etc. cannot either. In this video I will show you how to serve a computed table that takes over that task. And it's damn easy 🦄
Sources:
- github.com/Pos...
- github.com/sup...
- github.com/sup...
- www.postgresql...
#supabase #postgres #javascript

Опубликовано:

23 фев 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 22

@Skillthrive Год назад

Thank you! I was trying to create a SQL function for this, but this approach is great because we can use the Supabase API as normal.

@activenode Год назад

Indeed!

@nassersaleemahmed 7 месяцев назад

"I don't know sh*t about Haskell!". Love it. Useful video.

@WhiteTiger339 14 дней назад

Great , even if you give those texts in description or commnent it will be more useful

@user-pc3yi5xw7i 5 месяцев назад

Great solution man, thanks!

@tonyhart2744 Год назад

very helpfull man

@zeny_ic 9 месяцев назад

Oh. That's clever. Thank you!

@foofooss Год назад

Awesome, thanks dude!

@activenode 7 месяцев назад

Very welcome!

@thedelanyo 9 месяцев назад

Great. Exactly what am looking for. Please can it also work with queries?

@activenode 9 месяцев назад

Hey! Thanks for the question, can you clarify it? Not sure if I got it right

@junhanzhu1261 2 года назад

Help a lot! Thanks

@producaldo 6 месяцев назад

thanks for this video!

@jesuscc9225 2 года назад

thanks man, pretty useful

@Gab-mf6xq 6 месяцев назад

can I ask, is this an efficient way of randomising when you are dealing with a couple thousand rows of data?

@activenode 5 месяцев назад

Well let me put it like that: Postgres is pretty good in doing so but if you have many requests with many rows I'd rather suggest you go with the approach shown here jetrockets.com/blog/how-to-quickly-get-a-random-set-of-rows-from-a-postgres-table