@lucia-auth/adapter-kysely

Kysely adapter for Lucia

Documentation

Lucia documentation

Changelog

Installation

npm install @lucia-auth/adapter-kysely

Requires lucia-auth@0.11.0.

Testing

First follow the documentation on database set up.

PostgreSQL

Add username column:

ALTER TABLE public.user
ADD COLUMN username TEXT NOT NULL UNIQUE;

pnpm test-psql

PSQL_DATABASE_URL="" # database url

MySQL

Add username column:

ALTER TABLE user
ADD COLUMN username VARCHAR(31) NOT NULL UNIQUE AFTER id;

MYSQL_DATABASE="" # database name
MYSQ_PASSWORD="" # password

pnpm test-mysql-main

SQLITE

Add username column:

ALTER TABLE user ADD COLUMN username VARCHAR(31) NOT NULL;
CREATE UNIQUE INDEX username ON user(username);

pnpm test-sqlite-main