Open-source and local-first Slack and Notion alternative that puts you in control of your data
TypeScript chatchat-applicationcrdteditorelectronknowledge-baselocal-firstnotionnotion-alternativerealtime-collaborationself-hostedslacksqliteteam-collaborationwikiyjs
import {
DeleteResult,
InsertResult,
Kysely,
Migration,
Migrator,
PostgresDialect,
UpdateResult,
} from 'kysely';
import pg from 'pg';
import { databaseMigrations } from '@colanode/server/data/migrations';
import { DatabaseSchema } from '@colanode/server/data/schema';
import { config } from '@colanode/server/lib/config';
import { createLogger } from '@colanode/server/lib/logger';
const logger = createLogger('server:database');
pg.types.setTypeParser(pg.types.builtins.NUMERIC, (val) => {
return parseFloat(val);
});
pg.types.setTypeParser(pg.types.builtins.INT4, (val) => {
return parseInt(val);
});
const dialect = new PostgresDialect({
pool: new pg.Pool({
connectionString: config.postgres.url,
ssl:
config.postgres.ssl &&
Object.values(config.postgres.ssl).some((value) => value)
? config.postgres.ssl
: undefined,
}),
});
export const database = new Kysely<DatabaseSchema>({
dialect,
});
export const migrate = async () => {
const migrator = new Migrator({
db: database,
provider: {
getMigrations(): Promise<Record<string, Migration>> {
return Promise.resolve(databaseMigrations);
},
},
});
const result = await migrator.migrateToLatest();
if (result.error) {
logger.error(result.error, 'Migration failed');
}
if (result.results && result.results.length > 0) {
for (const r of result.results) {
logger.info(
{
direction: r.direction,
name: r.migrationName,
status: r.status,
},
'Migration result'
);
}
}
};
export const hasInsertChanges = (result: InsertResult[]): boolean => {
if (result.length === 0) {
return false;
}
return result.some(
(r) => r.numInsertedOrUpdatedRows && r.numInsertedOrUpdatedRows > 0n
);
};
export const hasUpdateChanges = (result: UpdateResult[]): boolean => {
if (result.length === 0) {
return false;
}
return result.some((r) => r.numUpdatedRows && r.numUpdatedRows > 0n);
};
export const hasDeleteChanges = (result: DeleteResult[]): boolean => {
return result.some((r) => r.numDeletedRows && r.numDeletedRows > 0n);
};