route creating cache

[LuWroblewski]

Summary

I have route catch the newest metric

import { NextResponse } from 'next/server';
import pg from '../../connection';

export async function GET() {
  try {
    const latestData = await pg('readings_temperature').select('*').orderBy('created_at', 'desc').first();

    if (!latestData) {
      return NextResponse.json({ status: 404, message: 'No data found.' }, { status: 404 });
    }

    return NextResponse.json(
      {
        status: 200,
        message: 'Successfully received the latest data.',
        data: latestData,
      },
      { status: 200 }
    );
  } catch (err) {
    console.error('Error occurred:', err);
    const errorMessage = err instanceof Error ? err.message : 'Unknown error';
    return NextResponse.json({ status: 500, message: 'Failed to load data', error: errorMessage }, { status: 500 });
  }
}

The route don’t work in other times, only work after deploy, in localhost works correctly but on vercel deploy is cache data, other routes i have don’t cache in vercel

Header example for last route i show yours

accept-ranges: bytes
access-control-allow-origin: *
age: 878
cache-control: public, max-age=0, must-revalidate
content-disposition: inline
content-type: application/json
date: Thu, 12 Sep 2024 01:32:11 GMT
etag: "d349be152dc0ba3e1bbb3c8cfb269785"
server: Vercel
strict-transport-security: max-age=63072000; includeSubDomains; preload
vary: RSC, Next-Router-State-Tree, Next-Router-Prefetch
x-matched-path: /api/temperature/getLatest
x-vercel-cache: HIT
x-vercel-id: gru1::dzjm8-1726104731726-35fa96cbc7f4
content-length: 166

Additional information

I tested on edge, chrome and insominia

They in same project but separated folders

i tryed change header using

        headers: {
          'Cache-Control': 'no-store, max-age=0, must-revalidate',
          'x-vercel-cache': 'MISS',
        },

but don't change anything

I expect he not create cache, like localhost

### Example

https://temperature-monitor-system.vercel.app/api/temperature/getLatest

[LuWroblewski]

I resolved using on initial lines

export const dynamic = 'force-dynamic';

and his works fine

Complete code:

import { NextResponse } from 'next/server';
import pg from '../../connection';

export const dynamic = 'force-dynamic';

export async function GET() {
  try {
    const latestData = await pg('readings_temperature').select('*').orderBy('created_at', 'desc').first();

    if (!latestData) {
      return NextResponse.json(
        { status: 404, message: 'No data found.' },
        {
          status: 404,
        }
      );
    }

    return NextResponse.json(
      {
        status: 200,
        message: 'Successfully received the latest data.',
        data: latestData,
      },
      {
        status: 200,
      }
    );
  } catch (err) {
    console.error('Error occurred:', err);
    const errorMessage = err instanceof Error ? err.message : 'Unknown error';
    return NextResponse.json(
      { status: 500, message: 'Failed to load data', error: errorMessage },
      {
        status: 500,
      }
    );
  }
}