upper cliff
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/[email protected]/mod.ts'
import { serve } from 'https://deno.land/[email protected]/http/server.ts'
import {
Kysely,
PostgresDialect,
Generated,
ColumnType,
Selectable,
Insertable,
Updateable,
} from 'https://esm.sh/[email protected]'
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
lyric widget