Best Backend for Next.js in 2025

// app/page.tsx (Server Component)
import { createServerComponentClient } from '@supabase/auth-helpers-nextjs'
import { cookies } from 'next/headers'

export default async function HomePage() {
  const supabase = createServerComponentClient({ cookies })

  // Direct database query in Server Component
  const { data: posts } = await supabase
    .from('posts')
    .select('*')
    .order('created_at', { ascending: false })

  return <div>{/* Render posts */}</div>
}

// convex/posts.ts
import { query } from "./_generated/server"

export const list = query({
  handler: async (ctx) => {
    return await ctx.db.query("posts").collect()
  }
})

// app/page.tsx
import { api } from "@/convex/_generated/api"
import { preloadQuery } from "convex/nextjs"

export default async function HomePage() {
  const posts = await preloadQuery(api.posts.list)
  return <div>{/* Render posts */}</div>
}

// app/api/posts/route.ts
import { getFirestore } from 'firebase-admin/firestore'
import { initAdmin } from '@/lib/firebase-admin'

export async function GET() {
  initAdmin()
  const db = getFirestore()

  const snapshot = await db.collection('posts')
    .orderBy('createdAt', 'desc')
    .limit(10)
    .get()

  const posts = snapshot.docs.map(doc => ({
    id: doc.id,
    ...doc.data()
  }))

  return Response.json({ posts })
}