게시판 CRUD 구현

// 게시글 목록 (페이지네이션)
export async function getPosts({ page = 1, search = '' }) {
  const from = (page - 1) * 10
  let query = supabase.from('posts')
    .select('*, profiles(username)', { count: 'exact' })
    .order('created_at', { ascending: false })
    .range(from, from + 9)

  if (search) query = query.ilike('title', `%${search}%`)

  const { data, count } = await query
  return { posts: data, total: count, pages: Math.ceil(count / 10) }
}