Stop being capped by your machine. Parallelize your work without limits.

@@ -12,6 +12,18 @@ export async function GET(request) {

const { searchParams } = new URL(request.url);

- const orders = await db.select().from(ordersTable);

- return Response.json(orders);

+ const limit = Number(searchParams.get("limit") ?? 25);

+ const cursor = searchParams.get("cursor");

+ const orders = await db

+ .select()

+ .from(ordersTable)

+ .where(cursor ? lt(ordersTable.id, cursor) : undefined)

+ .orderBy(desc(ordersTable.id))

+ .limit(limit + 1);

+ const hasMore = orders.length > limit;

+ const rows = hasMore ? orders.slice(0, limit) : orders;

+ const next = hasMore ? last(rows).id : null;

+

+ return Response.json({ rows, next });

}

export async function POST(request) {

const body = orderSchema.parse(await request.json());

const order = await createOrder(body);

return Response.json(order, { status: 201 });

}