Prisma Adapter - Database Strategy - Reduce number of database calls

[joshmcqueen]

Hi there! We successfully setup authjs with our nextjs react app. We're currently using AWS cognito provider, and everything looks good. Strategy is set to database.

I think the issue stems from how we structured our app. For each major section in our app, we have a actions.ts file (server actions) and data-access.ts (SDKs, api calls....etc). To prevent abuse, we have to check if the user is authenticated at the beginning of every function in actions.ts.

This adds up over time. It's not uncommon for a page to call 10+ functions across various actions.ts files, and each time we're using auth() it makes a database call.

example actions.ts:

'use server'
import type { LogActionParams } from 'src/app/(ignite)/log/_components/types'
import { auth } from '@/auth'
import { getAppSettingAction } from 'src/lib/settings/actions'
import { log } from './data-access'

// ----------------------------------------------------------------------

export async function logAction(params: LogActionParams) {
  const session = await auth()
  if (!session) throw new Error('session not authenticated')

  const cloudwatchEnabled = await getAppSettingAction('LOG_CLOUDWATCH')

  try {
    await log(params, cloudwatchEnabled?.value === 'true')
  } catch (error) {
    console.error('Error logging action:', error)
    throw new Error('Failed to log action')
  }
}

On the client side, we are storing the session in the protected layout

<SessionProvider session={session}>
 {children} 
 </SessionProvider>

but this only helps out on the client components. Is there a better approach to reduce the number of calls to the database from server components?