@lucia-auth/adapter-kysely
Kysely adapter for Lucia
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