⚡ Project management that doesn't become the project. Boards, Gantt charts, and GitHub integration. Self-host it or use Kaneo Cloud.
TypeScript honoissue-managementissue-trackerjira-alternativekanbanlinear-alternativemcpproject-managementreactself-hostedtypescript
import { config } from "dotenv-mono";
import { drizzle } from "drizzle-orm/node-postgres";
import { Pool } from "pg";
import {
accountTableRelations,
activityTableRelations,
apikeyTableRelations,
assetTableRelations,
columnTableRelations,
commentTableRelations,
customFieldDefinitionTableRelations,
customFieldValueTableRelations,
externalLinkTableRelations,
githubIntegrationTableRelations,
integrationTableRelations,
invitationTableRelations,
labelTableRelations,
notificationTableRelations,
projectTableRelations,
sessionTableRelations,
taskRelationTableRelations,
taskReminderSentTableRelations,
taskTableRelations,
teamMemberTableRelations,
teamTableRelations,
timeEntryTableRelations,
userNotificationPreferenceTableRelations,
userNotificationWorkspaceProjectTableRelations,
userNotificationWorkspaceRuleTableRelations,
userTableRelations,
verificationTableRelations,
workflowRuleTableRelations,
workspaceRoleTableRelations,
workspaceTableRelations,
workspaceUserTableRelations,
} from "./relations";
import { resolveDatabaseConfig } from "./resolve-database-url";
import {
dataMigrationTable,
storageCleanupTable,
accountTable,
activityTable,
adminAuditLogTable,
instanceRoleTable,
instanceSettingsTable,
instanceWebhookTable,
instanceWebhookDeliveryTable,
apikeyTable,
assetTable,
billingEventTable,
billingReminderSentTable,
calendarFeedTable,
columnTable,
commentTable,
customFieldDefinitionTable,
customFieldValueTable,
deviceCodeTable,
externalLinkTable,
githubImportTable,
githubIntegrationTable,
importRunTable,
integrationTable,
invitationTable,
jobLeaseTable,
labelTable,
mcpOauthStateTable,
notificationTable,
projectTable,
sessionTable,
taskRelationTable,
taskReminderSentTable,
taskTable,
teamMemberTable,
teamTable,
timeEntryTable,
trialGrantTable,
userAvatarTable,
userNotificationPreferenceTable,
userNotificationWorkspaceProjectTable,
userNotificationWorkspaceRuleTable,
userTable,
verificationTable,
workflowRuleTable,
workspaceBillingTable,
workspaceRoleTable,
workspaceMemberAccessTable,
workspaceMemberProjectTable,
workspaceTable,
workspaceUserTable,
} from "./schema";
config();
export const schema = {
dataMigrationTable,
storageCleanupTable,
accountTable,
adminAuditLogTable,
instanceRoleTable,
instanceSettingsTable,
instanceWebhookTable,
instanceWebhookDeliveryTable,
assetTable,
activityTable,
apikeyTable,
billingReminderSentTable,
billingEventTable,
calendarFeedTable,
workspaceBillingTable,
columnTable,
commentTable,
deviceCodeTable,
externalLinkTable,
githubIntegrationTable,
githubImportTable,
importRunTable,
integrationTable,
invitationTable,
jobLeaseTable,
labelTable,
mcpOauthStateTable,
notificationTable,
projectTable,
sessionTable,
taskRelationTable,
taskReminderSentTable,
taskTable,
teamMemberTable,
teamTable,
timeEntryTable,
trialGrantTable,
userTable,
userAvatarTable,
userNotificationPreferenceTable,
userNotificationWorkspaceProjectTable,
userNotificationWorkspaceRuleTable,
verificationTable,
workflowRuleTable,
workspaceRoleTable,
workspaceMemberAccessTable,
workspaceMemberProjectTable,
workspaceTable,
workspaceUserTable,
accountTableRelations,
assetTableRelations,
activityTableRelations,
apikeyTableRelations,
columnTableRelations,
commentTableRelations,
externalLinkTableRelations,
githubIntegrationTableRelations,
integrationTableRelations,
invitationTableRelations,
labelTableRelations,
notificationTableRelations,
projectTableRelations,
sessionTableRelations,
taskRelationTableRelations,
taskReminderSentTableRelations,
taskTableRelations,
teamMemberTableRelations,
teamTableRelations,
timeEntryTableRelations,
userTableRelations,
userNotificationPreferenceTableRelations,
userNotificationWorkspaceProjectTableRelations,
userNotificationWorkspaceRuleTableRelations,
verificationTableRelations,
workflowRuleTableRelations,
workspaceRoleTableRelations,
workspaceTableRelations,
workspaceUserTableRelations,
customFieldDefinitionTable,
customFieldValueTable,
customFieldDefinitionTableRelations,
customFieldValueTableRelations,
};
type DatabaseInstance = ReturnType<typeof drizzle<typeof schema>>;
let pool: Pool | undefined;
let dbInstance: DatabaseInstance | undefined;
export function getDatabasePool(): Pool {
if (!pool) {
const config = resolveDatabaseConfig();
pool = new Pool({
connectionString: config.connectionString,
// Fail fast when Railway's internal network is slow rather than hanging
// indefinitely and blocking every API request.
connectionTimeoutMillis: 5_000,
idleTimeoutMillis: 30_000,
max: config.poolMax,
});
}
return pool;
}
export function getDatabase(): DatabaseInstance {
if (!dbInstance) {
dbInstance = drizzle(getDatabasePool(), {
schema,
});
}
return dbInstance;
}
const db = new Proxy({} as DatabaseInstance, {
get(_target, property, receiver) {
const value = Reflect.get(getDatabase(), property, receiver);
if (typeof value === "function") {
return value.bind(getDatabase());
}
return value;
},
});
export default db;