GPT

Infinite Query Example

// src/hooks/useInfiniteUsers.ts import { useInfiniteQuery } from '@tanstack/react-query'; import { sql } from '../lib/db'; const PAGESIZE = 10; interface User { id: number; name: string; email: string; } export fu

Prompt text

Original English text. Replace placeholders with your own details.

// src/hooks/useInfiniteUsers.ts
import { useInfiniteQuery } from '@tanstack/react-query';
import { sql } from '../lib/db';

const PAGE_SIZE = 10;

interface User {
 id: number;
 name: string;
 email: string;
}

export function useInfiniteUsers() {
 return useInfiniteQuery({
 queryKey: ['users', 'infinite'],
 queryFn: async ({ pageParam = 0 }) => {
 const offset = pageParam * PAGE_SIZE;
 const users = await sql<User[]>`
 SELECT id, name, email
 FROM users
 ORDER BY name ASC
 LIMIT ${PAGE_SIZE}
 OFFSET ${offset}
 `;
 return users;
 },
 getNextPageParam: (lastPage, allPages) => {
 return lastPage.length === PAGE_SIZE ? allPages.length : undefined;
 },
 });
}

Source & attribution

Instructa AI Prompts · Instructa AI Prompts

Source-listed license: CC-BY-4.0. Prompt text is preserved; titles and previews may be shortened for display. Source examples are not NexGateHub test results.

View original source ↗ · Source credits & licenses

Explore more prompts →