DenoDDeno
Powered by
Thor - Google DeepMindT
Denoβ€’4y agoβ€’
4 replies
Thor - Google DeepMind

example of kysely running on deno deploy?

Deno Deploy awesomely can connect to postgres directly from the edge https://deno.com/blog/deploy-postgres-at-the-edge so I was hoping to use https://github.com/koskimas/kysely#deno

Was trying to make it work like this:
import { Pool } from 'https://deno.land/x/pg@v0.6.1/mod.ts'
import { serve } from 'https://deno.land/std@0.114.0/http/server.ts'
import {
  Kysely,
  PostgresDialect,
  Generated,
  ColumnType,
  Selectable,
  Insertable,
  Updateable,
} from 'https://esm.sh/kysely@0.23.4'

console.log(`Function "kysely-postgres" up and running!`)

interface AnimalTable {
  id: Generated<number>
  animal: string
  created_at: Date
}

// Keys of this interface are table names.
interface Database {
  animal: AnimalTable
}

// You'd create one of these when you start your app.
const db = new Kysely<Database>({
  // Use MysqlDialect for MySQL and SqliteDialect for SQLite.
  dialect: new PostgresDialect({
    // @ts-ignore
    pool: new Pool({
      user: 'postgres',
      hostname: 'db.bljghubhkofddfrezkhn.supabase.co',
      database: 'postgres',
      password: Deno.env.get('DB_PASSWORD')!,
      port: 5432,
    }),
  }),
})
import { Pool } from 'https://deno.land/x/pg@v0.6.1/mod.ts'
import { serve } from 'https://deno.land/std@0.114.0/http/server.ts'
import {
  Kysely,
  PostgresDialect,
  Generated,
  ColumnType,
  Selectable,
  Insertable,
  Updateable,
} from 'https://esm.sh/kysely@0.23.4'

console.log(`Function "kysely-postgres" up and running!`)

interface AnimalTable {
  id: Generated<number>
  animal: string
  created_at: Date
}

// Keys of this interface are table names.
interface Database {
  animal: AnimalTable
}

// You'd create one of these when you start your app.
const db = new Kysely<Database>({
  // Use MysqlDialect for MySQL and SqliteDialect for SQLite.
  dialect: new PostgresDialect({
    // @ts-ignore
    pool: new Pool({
      user: 'postgres',
      hostname: 'db.bljghubhkofddfrezkhn.supabase.co',
      database: 'postgres',
      password: Deno.env.get('DB_PASSWORD')!,
      port: 5432,
    }),
  }),
})

But am getting
Unknown Authentication type, code: 10, message: SCRA
Unknown Authentication type, code: 10, message: SCRA
Deno Blog
Connecting to Postgres from the edge
Many serverless at edge products can not connect to Postgres because they don't support TCP. Deno Deploy can.
Connecting to Postgres from the edge
GitHub
GitHub - koskimas/kysely: A type-safe typescript SQL query builder
A type-safe typescript SQL query builder. Contribute to koskimas/kysely development by creating an account on GitHub.
GitHub - koskimas/kysely: A type-safe typescript SQL query builder
Deno banner
DenoJoin
Chat about Deno, a modern runtime for JavaScript and TypeScript.
20,944Members
Resources
Was this page helpful?

Similar Threads

Recent Announcements

Similar Threads

Running Angular SSR on Deno Deploy
SheikSSheik / help
2y ago
Deno KV on deno deploy
MolanMMolan / help
11mo ago
Possible to deploy the chat example to deno deploy?
patwasalinguistPpatwasalinguist / help
3y ago
Failed deployment Deno Deploy
ssimonlpSssimonlp / help
16mo ago