database_instances

Creates, updates, deletes, gets or lists a database_instances resource.

Overview

Name	database_instances
Type	Resource
Id	deno.databases.database_instances

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
create	insert	slug, connection		Create a new database instance owned by the organization. Supported engines: postgresql (bring-your-own server), denokv (Deno-managed key-value), and prisma (Prisma-managed Postgres).

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description

INSERT examples

create

Create a new database instance owned by the organization. Supported engines: postgresql (bring-your-own server), denokv (Deno-managed key-value), and prisma (Prisma-managed Postgres).

INSERT INTO deno.databases.database_instances (
slug,
connection
)
SELECT 
'{{ slug }}' /* required */,
'{{ connection }}' /* required */
RETURNING
id,
connection,
created_at,
databases,
engine,
slug
;

Manifest

# Description fields are for documentation purposes
- name: database_instances
props:
  - name: slug
    value: "{{ slug }}"
    description: |
      Slug for the new database instance
  - name: connection
    value:
      engine: "{{ engine }}"
      hostname: "{{ hostname }}"
      port: {{ port }}
      username: "{{ username }}"
      password: "{{ password }}"
      certificate: "{{ certificate }}"
      region: "{{ region }}"