wiyco

wiyco's personal website w/ Supabase & Vercel.

Database

About the Database.

Original ID

An original ID generation function is defined in the database.

create or replace function public.id_generate_v1(length integer)
returns text
language plpgsql
as $$
declare
  chars text[] := '{_,-,=,0,1,2,3,4,5,6,7,8,9,A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z}';
  result text := '';
  i integer := 0;
begin
  if length < 0 then
    raise exception 'Given length cannot be less than 0';
  end if;
  for i in 1..length loop
    result := result || chars[1+random()*(array_length(chars, 1)-1)];
  end loop;
  return result;
end;
$$;

API

About the API.

Revalidate Path

Used when revalidating a specific path. (e.g. /archive, /blog, /blog/abcde)

GET /api/revalidate

Parameters

Name	Description	Required
path	The path you want to revalidate	Yes

Responses

Name	Description	Type
revalidated	The revalidate was successful or not	Boolean
message	Message from the server	String
now	Date and time executed	String

Sample

GET /api/revalidate?path=/blog/abcde

{
  "revalidated": true,
  "message": "Revalidated path: /blog/abcde",
  "now": "2024-07-23T09:16:28.558Z"
}

Tip

The slash / at the beginning of the path can be omitted.

---

🐢