The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { useMutation, useQueryClient } from '@tanstack/react-query'
import { toast } from 'sonner'
import { DesiredInstanceSize, PostgresEngine, ReleaseChannel } from './new-project.constants'
import { useInvalidateProjectsInfiniteQuery } from './org-projects-infinite-query'
import type { components } from '@/data/api'
import { handleError, post } from '@/data/fetchers'
import { invalidatePermissionsQueryV2 } from '@/data/permissions/permissions-query-v2'
import { PROVIDERS } from '@/lib/constants'
import { captureCriticalError } from '@/lib/error-reporting'
import type { ResponseError, UseCustomMutationOptions } from '@/types'
type CreateProjectBody = components['schemas']['CreateProjectBody']
type CloudProvider = CreateProjectBody['cloud_provider']
export type ProjectCreateVariables = {
name: string
organizationSlug: string
dbPass: string
dbRegion?: string
regionSelection?: CreateProjectBody['region_selection']
dbSql?: string
dbPricingTierId?: string
cloudProvider?: string
authSiteUrl?: string
customSupabaseRequest?: object
dbInstanceSize?: DesiredInstanceSize
dataApiExposedSchemas?: string[]
dataApiUseApiSchema?: boolean
dataApiRevokeDefaultPrivileges?: boolean
postgresEngine?: PostgresEngine
releaseChannel?: ReleaseChannel
highAvailability?: boolean
githubInstallationId?: CreateProjectBody['github_installation_id']
githubRepositoryId?: CreateProjectBody['github_repository_id']
}
export async function createProject({
name,
organizationSlug,
dbPass,
dbRegion,
regionSelection,
dbSql,
cloudProvider = PROVIDERS.AWS.id,
authSiteUrl,
customSupabaseRequest,
dbInstanceSize,
dataApiExposedSchemas,
dataApiUseApiSchema,
dataApiRevokeDefaultPrivileges,
postgresEngine,
releaseChannel,
highAvailability,
githubInstallationId,
githubRepositoryId,
}: ProjectCreateVariables) {
const body: CreateProjectBody = {
cloud_provider: cloudProvider as CloudProvider,
organization_slug: organizationSlug,
name,
db_pass: dbPass,
db_region: dbRegion,
region_selection: regionSelection,
db_sql: dbSql,
auth_site_url: authSiteUrl,
...(customSupabaseRequest !== undefined && {
custom_supabase_internal_requests: customSupabaseRequest as any,
}),
desired_instance_size: dbInstanceSize,
data_api_exposed_schemas: dataApiExposedSchemas,
data_api_use_api_schema: dataApiUseApiSchema,
data_api_revoke_default_privileges: dataApiRevokeDefaultPrivileges,
postgres_engine: postgresEngine,
release_channel: releaseChannel,
high_availability: highAvailability,
github_installation_id: githubInstallationId,
github_repository_id: githubRepositoryId,
}
const { data, error } = await post(`/platform/projects`, {
body,
})
if (error) handleError(error)
return data
}
type ProjectCreateData = Awaited<ReturnType<typeof createProject>>
export const useProjectCreateMutation = ({
onSuccess,
onError,
...options
}: Omit<
UseCustomMutationOptions<ProjectCreateData, ResponseError, ProjectCreateVariables>,
'mutationFn'
> = {}) => {
const queryClient = useQueryClient()
const { invalidateProjectsQuery } = useInvalidateProjectsInfiniteQuery()
return useMutation<ProjectCreateData, ResponseError, ProjectCreateVariables>({
mutationFn: (vars) => createProject(vars),
async onSuccess(data, variables, context) {
await Promise.all([invalidateProjectsQuery(), invalidatePermissionsQueryV2(queryClient)])
await onSuccess?.(data, variables, context)
},
async onError(data, variables, context) {
if (onError === undefined) {
toast.error(`Failed to create new project: ${data.message}`)
} else {
onError(data, variables, context)
}
captureCriticalError(data, 'create project')
},
...options,
})
}