The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { keepPreviousData } from '@tanstack/react-query'
import { useDebounce, useIntersectionObserver } from '@uidotdev/usehooks'
import { useEffect, useMemo, useState } from 'react'
import { Command, CommandGroup, CommandInput, CommandItem, CommandList } from 'ui'
import type { CustomOptionProps } from 'ui-patterns/FilterBar'
import { ShimmeringLoader } from 'ui-patterns/ShimmeringLoader'
import { useOrgProjectsInfiniteQuery } from '@/data/projects/org-projects-infinite-query'
import { useProjectsInfiniteQuery } from '@/data/projects/projects-infinite-query'
type AuditLogsProject = { ref: string; name: string }
interface AuditLogsProjectOptionProps extends CustomOptionProps {
// Scopes the list to an organization's projects, otherwise lists all of the user's projects
slug?: string
onSelectProject: (project: AuditLogsProject) => void
}
// Select-only project list for the FilterBar. The stored value is the project ref, while the
// chip shows the name through the property's `formatValue`.
export const AuditLogsProjectOption = ({
slug,
onChange,
onSelectProject,
}: AuditLogsProjectOptionProps) => {
const [search, setSearch] = useState('')
const debouncedSearch = useDebounce(search, 500)
const [sentinelRef, entry] = useIntersectionObserver({ threshold: 0, rootMargin: '0px' })
const isOrgScoped = !!slug
const variables = { search: search.length === 0 ? search : debouncedSearch }
const accountQuery = useProjectsInfiniteQuery(variables, {
placeholderData: keepPreviousData,
enabled: !isOrgScoped,
})
const orgQuery = useOrgProjectsInfiniteQuery(
{ slug, ...variables },
{ placeholderData: keepPreviousData, enabled: isOrgScoped }
)
const {
error,
isLoading,
isError,
isSuccess,
isFetching,
isFetchingNextPage,
hasNextPage,
fetchNextPage,
} = isOrgScoped ? orgQuery : accountQuery
const accountProjects = useMemo(
() => accountQuery.data?.pages.flatMap((page) => page.projects) ?? [],
[accountQuery.data?.pages]
)
const orgProjects = useMemo(
() => orgQuery.data?.pages.flatMap((page) => page.projects) ?? [],
[orgQuery.data?.pages]
)
const projects: AuditLogsProject[] = isOrgScoped ? orgProjects : accountProjects
useEffect(() => {
if (entry?.isIntersecting && hasNextPage && !isFetching && !isFetchingNextPage) {
fetchNextPage()
}
}, [entry?.isIntersecting, hasNextPage, isFetching, isFetchingNextPage, fetchNextPage])
const handleSelect = (project: AuditLogsProject) => {
onSelectProject(project)
onChange(project.ref)
}
return (
<Command shouldFilter={false}>
<CommandInput
showResetIcon
value={search}
onValueChange={setSearch}
placeholder="Find project..."
handleReset={() => setSearch('')}
className="text-base sm:text-sm"
// FilterBar keeps focus on the chip's input, so move it here for cmdk's arrow/enter keys
autoFocus
/>
<CommandList className="max-h-[300px] overflow-y-auto overflow-x-hidden">
<CommandGroup>
{isLoading && (
<div className="px-2 py-1">
<ShimmeringLoader className="py-2" />
</div>
)}
{isError && (
<p className="text-xs text-center text-foreground-lighter py-3">
Failed to retrieve projects: {error.message}
</p>
)}
{isSuccess && projects.length === 0 && (
<p className="text-xs text-center text-foreground-lighter py-3">
{search.length > 0 ? 'No projects found based on your search' : 'No projects found'}
</p>
)}
{isSuccess &&
projects.map((project) => (
<CommandItem
key={project.ref}
value={`${project.name.replaceAll('"', '')}-${project.ref}`}
className="cursor-pointer w-full"
onSelect={() => handleSelect(project)}
>
{project.name}
</CommandItem>
))}
<div ref={sentinelRef} className="h-1 -mt-1" />
{hasNextPage && (
<div className="px-2 py-1">
<ShimmeringLoader className="py-2" />
</div>
)}
</CommandGroup>
</CommandList>
</Command>
)
}
// FilterBar invokes `component(props)` as a plain function, so this factory returns that function
// with `onSelectProject` (and optionally `slug`) bound, keeping the component itself defined at
// module level.
export const createAuditLogsProjectOption = (
onSelectProject: AuditLogsProjectOptionProps['onSelectProject'],
slug?: string
) => {
const renderProjectOption = (props: CustomOptionProps) => (
<AuditLogsProjectOption {...props} slug={slug} onSelectProject={onSelectProject} />
)
return renderProjectOption
}