The “Order By” Clause With Supabase

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

Jérémie Litzler
1 min readJan 28, 2025
Objects ordered by size
Photo by Pavel Danilyuk.

I’m writing ⏩ this small tip of the dayto 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.

--

--

Jérémie Litzler
Jérémie Litzler

Written by Jérémie Litzler

I am a software engineer, but not just that: I thrive to improve life around me through observation and awareness about my impact in my environment.

No responses yet