The “Order By” Clause With Supabase

With Supabase, performing ordering of recordsets is simple and intuitive. But there is a caveat.

Photo by Pavel Danilyuk.

I’m writing ⏩ this small tip of the day ⏪to describe the behavior when you order a query result and null values exist on a target column.

Follow me

Thanks for reading this article. Make sure to follow me on X, subscribe to my Substack publication and bookmark my blog to read more in the future.

Why does this post link to my blog?

I have been on Medium for a while, frankly, the editor isn’t the best:

• When I copy-paste a post content from my blog posts on Medium, all the code extracts need manual adjustments.
• Medium doesn’t support WEBP or AVIF…
• Setting the alternative text on an image bumps the focus back to the top… Not great for a long post!

Moreover, my analytics shows that very little traffic to my blog comes from Medium.