J-Supabase Now Has More Utility Functions
4 min read
jdgamble555 on (last modified on )
Besides easy subscription functions, I have added more utility functions to my j-supabase package.
Now with Utility Functions
If you use Postgres, you should be using UUID (Universally Unique Identifiers) for your ID fields. However, if you're like me and you want to use them in your path, things can get ugly.
Do you really want a URL like this:
https://code.build/p/2f000099-3042-4513-b67d-f6092d240496/j-supabase-now-has-more-utility-functionsSome people would argue that is not much better than this:
https://code.build/p/6ocrWnu18BM4Ly8UfunJqB/j-supabase-now-has-more-utility-functionsHowever, the extra characters and dashes can make a huge difference. So, added some quick functions to convert the UUID fields into Base 58 versions.
Install the package of course.
npm i j-supabaseImport the functions.
import { decode, encode, range } from 'j-supabase';All you have to do is use it on your data.
Decode
You want to decode your data before you use it on your database.
const pid = decode(id);
const { error, data } = await supabase.from('posts').select('*').eq('id', pid);Encode
You want to encode your data from your database results.
const { error, data } = await supabase.from('posts').select('*');
// map each result
data = data.length ? data.map((p) => ({ ...p, id: encode(p.id) })) : null;Range Function for Pagination
Sometimes you want to do Supabase Pagination, and the range() function confuses you. So, I put it in the package for reusability. Simply input the page number, and the page size, and you will get the correct range pagination numbers. It defaults at page 1 and size 3.
// automatically calculate pagination
const { from, to } = range({ page, size });
const { error, data } = await supabase.from('posts').select('*')
.order('created_at', { ascending: false })
.range(from, to);Note: I wrote my j-supabase package in order to make certain Supabase functions easier, especially Subscriptions.
Please see my previous post.
If anyone has any more ideas, just let me know on github.
J