Sync-in · Sovereign platform for file storage, sharing, synchronization, and collaboration.
TypeScript cloud-alternativecollaborationcollaborative-editingdropboxfile-serverfile-sharingfile-storagefile-syncfull-text-searchhomelabnextcloudon-premiseopen-sourceprivacy-firstprivate-cloudrealtimesecureself-hostedstorage-serverwebdav
import fs from 'node:fs'
import path from 'node:path'
import { fileURLToPath } from 'node:url'
const moduleDir = path.dirname(fileURLToPath(import.meta.url))
export const DB_CHARSET = 'utf8mb4'
// Changing this collation after deployment also requires a new database migration.
export const DB_PATH_COLLATION = 'utf8mb4_uca1400_nopad_as_ci'
export const DB_TOKEN_PROVIDER = 'DB'
export const DB_SESSION_INIT_QUERIES = [
// Use UTC for SQL date/time functions and TIMESTAMP values.
`SET time_zone = '+00:00'`,
// Use InnoDB for tables created without an explicit storage engine.
`SET SESSION default_storage_engine = 'InnoDB'`
] as const
export const MIGRATIONS_PATH = path.relative(process.cwd(), path.join(moduleDir, '../../../migrations'))
export function getSchemaPath(): string {
// Look for schema.ts (dev) or schema.js (production), throw if none is found
const extensions = ['js', 'ts']
for (const ext of extensions) {
const filePath = path.join(moduleDir, `schema.${ext}`)
if (fs.existsSync(filePath)) {
return filePath
}
}
throw new Error('No schema.[ts|js] file found !')
}