docs: add Enable Actual to community repos (#7697)

Co-authored-by: Aaron <aaron@noreply.squaresine.com>

.github/workflows/vrt-update-generate.yml

@@ -65,6 +65,10 @@ jobs:
           ref: ${{ steps.pr.outputs.head_sha }}
           persist-credentials: false
 
+      - name: Trust workspace directory
+        run: git config --global --add safe.directory "$GITHUB_WORKSPACE"
+        shell: bash
+
       - name: Set up environment
         uses: ./.github/actions/setup
         with:
@@ -87,9 +91,6 @@ jobs:
       - name: Create patch with PNG changes only
         id: create-patch
         run: |
-          # Trust the repository directory (required for container environments)
-          git config --global --add safe.directory "$GITHUB_WORKSPACE"
-
           git config --global user.name "github-actions[bot]"
           git config --global user.email "github-actions[bot]@users.noreply.github.com"
 

.oxlintrc.json

@@ -15,8 +15,7 @@
     "vi": "readonly",
     "backend": "readonly",
     "importScripts": "readonly",
-    "FS": "readonly",
-    "__APP_VERSION__": "readonly"
+    "FS": "readonly"
   },
   "rules": {
     // Import sorting

package.json

@@ -52,7 +52,7 @@
     "playwright": "yarn workspace @actual-app/web run playwright",
     "vrt": "yarn workspace @actual-app/web run vrt",
     "vrt:docker": "./bin/run-vrt",
-    "rebuild-electron": "./node_modules/.bin/electron-rebuild -m ./packages/desktop-electron -o better-sqlite3,bcrypt --build-from-source -f",
+    "rebuild-electron": "./node_modules/.bin/electron-rebuild -f -o better-sqlite3,bcrypt",
     "rebuild-node": "yarn workspace @actual-app/core rebuild",
     "lint": "oxfmt --check . && oxlint --type-aware --quiet",
     "lint:fix": "oxfmt . && oxlint --fix --type-aware --quiet",

packages/crdt/package.json

@@ -10,10 +10,14 @@
     "!dist/**/*.spec.d.ts",
     "!dist/**/*.spec.d.ts.map"
   ],
-  "main": "src/index.ts",
-  "types": "src/index.ts",
+  "main": "dist/index.js",
+  "types": "dist/index.d.ts",
   "exports": {
-    ".": "./src/index.ts"
+    ".": {
+      "types": "./dist/index.d.ts",
+      "development": "./src/index.ts",
+      "default": "./dist/index.js"
+    }
   },
   "publishConfig": {
     "exports": {
@@ -21,9 +25,7 @@
         "types": "./dist/index.d.ts",
         "default": "./dist/index.js"
       }
-    },
-    "main": "dist/index.js",
-    "types": "dist/index.d.ts"
+    }
   },
   "scripts": {
     "build:node": "vite build",

packages/crdt/tsconfig.json

@@ -4,8 +4,8 @@
     "rootDir": "./src",
     "composite": true,
     "target": "ES2021",
-    "module": "ES2022",
-    "moduleResolution": "bundler",
+    "module": "NodeNext",
+    "moduleResolution": "NodeNext",
     "noEmit": false,
     "emitDeclarationOnly": true,
     "declaration": true,

packages/desktop-client/src/browser-preload.js

@@ -335,17 +335,10 @@ const isUpdateReadyForDownloadPromise = new Promise(resolve => {
     resolve(true);
   };
 });
-// Skip SW registration in dev so stale cached assets don't override edits
-// between page loads. Plugin code that needs a SW can register one itself.
-// In dev there is no SW to install, so applyAppUpdate() can't rely on the
-// SW lifecycle to swap the page — fall back to a plain reload so callers
-// don't hang on the never-resolving promise inside applyAppUpdate.
-const updateSW = IS_DEV
-  ? () => window.location.reload()
-  : registerSW({
-      immediate: true,
-      onNeedRefresh: markUpdateReadyForDownload,
-    });
+const updateSW = registerSW({
+  immediate: true,
+  onNeedRefresh: markUpdateReadyForDownload,
+});
 
 global.Actual = {
   IS_DEV,

packages/desktop-client/src/hooks/usePreviewTransactions.ts

@@ -1,6 +1,7 @@
 import { useEffect, useMemo, useState } from 'react';
 
 import { send } from '@actual-app/core/platform/client/connection';
+import * as monthUtils from '@actual-app/core/shared/months';
 import { computeSchedulePreviewTransactions } from '@actual-app/core/shared/schedules';
 import { ungroupTransactions } from '@actual-app/core/shared/transactions';
 import type { IntegerAmount } from '@actual-app/core/shared/util';
@@ -100,6 +101,13 @@ export function usePreviewTransactions({
             ),
           }));
 
+          // re-sort in case rule actions have changed the dates
+          withDefaults.sort(
+            (a, b) =>
+              monthUtils.parseDate(b.date).getTime() -
+                monthUtils.parseDate(a.date).getTime() || a.amount - b.amount,
+          );
+
           const ungroupedTransactions = ungroupTransactions(withDefaults);
           setPreviewTransactions(ungroupedTransactions);
 

packages/desktop-client/vite.config.mts

@@ -376,9 +376,7 @@ export default defineConfig(async ({ mode, command }) => {
             //   swSrc: `service-worker/plugin-sw.js`,
             // },
             devOptions: {
-              // Disabled: caches stale assets across reloads in dev. Plugin
-              // code that explicitly needs a SW can register one itself.
-              enabled: false,
+              enabled: true, // We need service worker in dev mode to work with plugins
               type: 'module',
             },
             workbox: {

packages/desktop-electron/index.ts

@@ -239,11 +239,12 @@ async function startSyncServer() {
       ),
     };
 
-    // require.resolve will recursively search up the workspace for the module
-    const syncServerRoot = path.dirname(
-      require.resolve('@actual-app/sync-server/package.json'),
+    const serverPath = path.join(
+      // require.resolve will recursively search up the workspace for the module
+      path.dirname(require.resolve('@actual-app/sync-server/package.json')),
+      'build',
+      'app.js',
     );
-    const serverPath = path.join(syncServerRoot, 'build/app.js');
 
     const webRoot = path.join(
       // require.resolve will recursively search up the workspace for the module

packages/docs/docs/community-repos.md

@@ -13,6 +13,7 @@ for it to be added, your project must have a proper README file.
 The following are implementations of bank syncing using the Actual API. For instructions on using them, see the respective repositories.
 
 - **Akahu and Up bank sync to Actual Budget** - https://github.com/tim-smart/actualbudget-sync
+- **Enable Actual: Import transactions from European banks using Enable Banking** - https://github.com/2manyvcos/enable-actual
 - **ICS Cards Holland CVS exporter** - https://github.com/IeuanK/ICS-Exporter/
 - **Lunch Flow: Import transactions from GoCardless, MX, Finicity, Finverse, and more** - https://github.com/lunchflow/actual-flow
 - **MoneyMan an israel banks importer** - https://github.com/daniel-hauser/moneyman

packages/loot-core/src/server/post.ts

@@ -11,7 +11,7 @@ function throwIfNot200(res: Response, text: string) {
       throw new PostError(res.status === 500 ? 'internal' : text);
     }
 
-    const contentType = res.headers.get('Content-Type');
+    const contentType = res.headers.get('Content-Type') ?? '';
     if (contentType.toLowerCase().indexOf('application/json') !== -1) {
       const json = JSON.parse(text);
       throw new PostError(json.reason);

packages/sync-server/bin/actual-server.js

@@ -1,6 +1,7 @@
 #!/usr/bin/env node
 import { existsSync, readFileSync } from 'node:fs';
-import { resolve } from 'node:path';
+import { dirname, resolve } from 'node:path';
+import { fileURLToPath } from 'node:url';
 import { parseArgs } from 'node:util';
 
 const args = process.argv;
@@ -53,7 +54,11 @@ if (values.help) {
 }
 
 if (values.version) {
-  console.log('v' + __APP_VERSION__);
+  const __dirname = dirname(fileURLToPath(import.meta.url));
+  const packageJsonPath = resolve(__dirname, '../../package.json');
+  const packageJson = JSON.parse(readFileSync(packageJsonPath, 'utf-8'));
+
+  console.log('v' + packageJson.version);
   process.exit();
 }
 

packages/sync-server/bin/add-import-extensions.mjs

@@ -0,0 +1,146 @@
+#!/usr/bin/env node
+import { existsSync, readFileSync } from 'node:fs';
+import { readdir, readFile, writeFile } from 'node:fs/promises';
+import { dirname, extname, join, relative, resolve } from 'node:path';
+import { fileURLToPath } from 'node:url';
+
+const __filename = fileURLToPath(import.meta.url);
+const __dirname = dirname(__filename);
+
+const buildDir = resolve(__dirname, '../build');
+const packageRoot = resolve(__dirname, '..');
+
+const packageJson = JSON.parse(
+  readFileSync(join(packageRoot, 'package.json'), 'utf-8'),
+);
+// publishConfig.imports already has ./build/src/ paths with .js extensions
+const importsMap = packageJson.publishConfig?.imports || {};
+
+// Sort wildcard patterns longest-prefix-first so more specific patterns
+// (e.g. #app-gocardless/services/tests/*) match before broader ones (#app-gocardless/*)
+const wildcardEntries = Object.entries(importsMap)
+  .filter(([p]) => p.includes('*'))
+  .sort(([a], [b]) => b.length - a.length);
+
+async function getAllJsFiles(dir) {
+  const files = [];
+  const entries = await readdir(dir, { withFileTypes: true });
+
+  for (const entry of entries) {
+    const fullPath = join(dir, entry.name);
+    if (entry.isDirectory()) {
+      files.push(...(await getAllJsFiles(fullPath)));
+    } else if (entry.isFile() && extname(entry.name) === '.js') {
+      files.push(fullPath);
+    }
+  }
+
+  return files;
+}
+
+function resolveImportPath(importPath, fromFile) {
+  const baseDir = dirname(fromFile);
+  const resolvedPath = resolve(baseDir, importPath);
+
+  // Check if it's a file with .js extension
+  if (existsSync(`${resolvedPath}.js`)) {
+    return `${importPath}.js`;
+  }
+
+  // Check if it's a directory with index.js
+  if (existsSync(resolvedPath) && existsSync(join(resolvedPath, 'index.js'))) {
+    return `${importPath}/index.js`;
+  }
+
+  // Verify the file exists before adding extension
+  if (!existsSync(`${resolvedPath}.js`)) {
+    console.warn(
+      `Warning: Could not resolve import '${importPath}' from ${relative(buildDir, fromFile)}`,
+    );
+  }
+
+  // Default: assume it's a file and add .js
+  return `${importPath}.js`;
+}
+
+function toRelativePath(target, fromFile) {
+  const absoluteTarget = resolve(packageRoot, target);
+  let rel = relative(dirname(fromFile), absoluteTarget);
+  if (!rel.startsWith('.')) rel = './' + rel;
+  return rel.split('\\').join('/');
+}
+
+function resolveSubpathImport(importPath, fromFile) {
+  if (importsMap[importPath]) {
+    return toRelativePath(importsMap[importPath], fromFile);
+  }
+
+  for (const [pattern, target] of wildcardEntries) {
+    const prefix = pattern.replaceAll('*', '');
+    if (importPath.startsWith(prefix)) {
+      const wildcard = importPath.slice(prefix.length);
+      return toRelativePath(target.replaceAll('*', wildcard), fromFile);
+    }
+  }
+
+  console.warn(
+    `Warning: Could not resolve subpath import '${importPath}' from ${relative(buildDir, fromFile)}`,
+  );
+  return null;
+}
+
+function addExtensionsToImports(content, filePath) {
+  const importRegex =
+    /(?:import\s+(?:(?:\{[^}]*\}|\*\s+as\s+\w+|\w+)(?:\s*,\s*(?:\{[^}]*\}|\*\s+as\s+\w+|\w+))*\s+from\s+)?|import\s*\(|require\s*\()['"]((\.\.?\/[^'"]+)|(#[^'"]+))['"]/g;
+
+  return content.replace(importRegex, (match, importPath) => {
+    if (!importPath || typeof importPath !== 'string') {
+      return match;
+    }
+
+    if (importPath.startsWith('#')) {
+      const resolved = resolveSubpathImport(importPath, filePath);
+      if (resolved) {
+        return match.replace(importPath, resolved);
+      }
+      return match;
+    }
+
+    // Skip if already has an extension
+    if (/\.(js|mjs|ts|mts|json)$/.test(importPath)) {
+      return match;
+    }
+
+    // Skip if ends with / (directory import that already has trailing slash)
+    if (importPath.endsWith('/')) {
+      return match;
+    }
+
+    const newImportPath = resolveImportPath(importPath, filePath);
+    return match.replace(importPath, newImportPath);
+  });
+}
+
+async function processFile(filePath) {
+  const content = await readFile(filePath, 'utf-8');
+  const newContent = addExtensionsToImports(content, filePath);
+
+  if (content !== newContent) {
+    await writeFile(filePath, newContent, 'utf-8');
+    const relativePath = relative(buildDir, filePath);
+    console.log(`Updated imports in ${relativePath}`);
+  }
+}
+
+async function main() {
+  try {
+    const files = await getAllJsFiles(buildDir);
+    await Promise.all(files.map(processFile));
+    console.log(`Processed ${files.length} files`);
+  } catch (error) {
+    console.error('Error processing files:', error);
+    process.exit(1);
+  }
+}
+
+void main();

packages/sync-server/loader.mjs

@@ -0,0 +1,26 @@
+import { existsSync } from 'node:fs';
+import { dirname, extname, resolve as nodeResolve } from 'node:path';
+import { pathToFileURL } from 'node:url';
+
+const extensions = ['.ts', '.js', '.mts', '.mjs'];
+
+export async function resolve(specifier, context, nextResolve) {
+  // Only handle relative imports without extensions
+  if (specifier.startsWith('.') && !extname(specifier)) {
+    const parentURL = context.parentURL;
+    if (parentURL) {
+      const parentPath = new URL(parentURL).pathname;
+      const parentDir = dirname(parentPath);
+
+      // Try extensions in order
+      for (const ext of extensions) {
+        const resolvedPath = nodeResolve(parentDir, `${specifier}${ext}`);
+        if (existsSync(resolvedPath)) {
+          return nextResolve(pathToFileURL(resolvedPath).href, context);
+        }
+      }
+    }
+  }
+
+  return nextResolve(specifier, context);
+}

packages/sync-server/package.json

@@ -41,19 +41,47 @@
     "#util/title": "./src/util/title/index.js",
     "#util/*": "./src/util/*.ts"
   },
+  "publishConfig": {
+    "imports": {
+      "#db": "./build/src/db.js",
+      "#account-db": "./build/src/account-db.js",
+      "#load-config": "./build/src/load-config.js",
+      "#migrations": "./build/src/migrations.js",
+      "#accounts/*": "./build/src/accounts/*.js",
+      "#app-gocardless/banks/bank.interface": "./build/src/app-gocardless/banks/bank.interface.js",
+      "#app-gocardless/banks/*": "./build/src/app-gocardless/banks/*.js",
+      "#app-gocardless/errors": "./build/src/app-gocardless/errors.js",
+      "#app-gocardless/gocardless-node.types": "./build/src/app-gocardless/gocardless-node.types.js",
+      "#app-gocardless/gocardless.types": "./build/src/app-gocardless/gocardless.types.js",
+      "#app-gocardless/services/*": "./build/src/app-gocardless/services/*.js",
+      "#app-gocardless/services/tests/*": "./build/src/app-gocardless/services/tests/*.js",
+      "#app-gocardless/util/*": "./build/src/app-gocardless/util/*.js",
+      "#app-gocardless/*": "./build/src/app-gocardless/*.js",
+      "#app-pluggyai/*": "./build/src/app-pluggyai/*.js",
+      "#app-simplefin/*": "./build/src/app-simplefin/*.js",
+      "#app-sync/services/*": "./build/src/app-sync/services/*.js",
+      "#app-sync/*": "./build/src/app-sync/*.js",
+      "#scripts/*": "./build/src/scripts/*.js",
+      "#services/*": "./build/src/services/*.js",
+      "#util/title": "./build/src/util/title/index.js",
+      "#util/*": "./build/src/util/*.js"
+    }
+  },
   "scripts": {
-    "start": "yarn build && node build/app.js",
-    "start-monitor": "nodemon --exec 'yarn build && node build/app.js' --ignore './build/**/*' --ext 'ts,js' build/app.js",
-    "build": "vite build",
+    "start": "yarn build && node build/app",
+    "start-monitor": "nodemon --exec 'yarn build && node build/app' --ignore './build/**/*' --ext 'ts,js' build/app",
+    "build": "tsgo -b && yarn add-import-extensions && yarn copy-static-assets",
     "typecheck": "tsgo -b && tsc-strict",
-    "test": "NODE_ENV=test NODE_OPTIONS='--experimental-vm-modules --trace-warnings' vitest --run",
-    "db:migrate": "yarn build && cross-env NODE_ENV=development node build/scripts/run-migrations.js up",
-    "db:downgrade": "yarn build && cross-env NODE_ENV=development node build/scripts/run-migrations.js down",
-    "db:test-migrate": "yarn build && cross-env NODE_ENV=test node build/scripts/run-migrations.js up",
-    "db:test-downgrade": "yarn build && cross-env NODE_ENV=test node build/scripts/run-migrations.js down",
-    "reset-password": "yarn build && node build/scripts/reset-password.js",
-    "disable-openid": "yarn build && node build/scripts/disable-openid.js",
-    "health-check": "yarn build && node build/scripts/health-check.js"
+    "add-import-extensions": "node bin/add-import-extensions.mjs",
+    "copy-static-assets": "rm -rf build/src/sql && cp -r src/sql build/src/sql",
+    "test": "NODE_ENV=test NODE_OPTIONS='--experimental-vm-modules --import ./register-loader.mjs --trace-warnings' vitest --run",
+    "db:migrate": "yarn build && cross-env NODE_ENV=development node build/src/scripts/run-migrations.js up",
+    "db:downgrade": "yarn build && cross-env NODE_ENV=development node build/src/scripts/run-migrations.js down",
+    "db:test-migrate": "yarn build && cross-env NODE_ENV=test node build/src/scripts/run-migrations.js up",
+    "db:test-downgrade": "yarn build && cross-env NODE_ENV=test node build/src/scripts/run-migrations.js down",
+    "reset-password": "yarn build && node build/src/scripts/reset-password.js",
+    "disable-openid": "yarn build && node build/src/scripts/disable-openid.js",
+    "health-check": "yarn build && node build/src/scripts/health-check.js"
   },
   "dependencies": {
     "@actual-app/crdt": "workspace:*",
@@ -87,7 +115,6 @@
     "nodemon": "^3.1.14",
     "supertest": "^7.2.2",
     "typescript-strict-plugin": "^2.4.4",
-    "vite": "^8.0.5",
     "vitest": "^4.1.2"
   }
 }

packages/sync-server/register-loader.mjs

@@ -0,0 +1,9 @@
+import { register } from 'node:module';
+import { dirname, resolve } from 'node:path';
+import { fileURLToPath, pathToFileURL } from 'node:url';
+
+const __filename = fileURLToPath(import.meta.url);
+const __dirname = dirname(__filename);
+const loaderPath = resolve(__dirname, 'loader.mjs');
+
+register(pathToFileURL(loaderPath).href, pathToFileURL(__dirname));

packages/sync-server/src/app-gocardless/bank-factory.js

@@ -1,14 +1,22 @@
+import fs from 'node:fs';
+import path from 'node:path';
+import { fileURLToPath, pathToFileURL } from 'node:url';
+
 import IntegrationBank from './banks/integration-bank';
 
-// Filename convention: <name>_<bic>.{ts,js} (skips bank.interface,
-// integration-bank, and any other helper without an underscore).
-const bankLoaders = import.meta.glob('./banks/*_*.{ts,js}');
+const dirname = path.resolve(fileURLToPath(import.meta.url), '..');
+const banksDir = path.resolve(dirname, 'banks');
 
 async function loadBanks() {
+  const bankHandlers = fs
+    .readdirSync(banksDir)
+    .filter(filename => filename.includes('_') && filename.endsWith('.js'));
+
   const imports = await Promise.all(
-    Object.values(bankLoaders).map(loader =>
-      loader().then(handler => handler.default),
-    ),
+    bankHandlers.map(file => {
+      const fileUrlToBank = pathToFileURL(path.resolve(banksDir, file)); // pathToFileURL for ESM compatibility
+      return import(fileUrlToBank.toString()).then(handler => handler.default);
+    }),
   );
 
   return imports;

packages/sync-server/src/app.ts

@@ -124,32 +124,17 @@ app.get('/metrics', (_req, res) => {
   });
 });
 
-// The web frontend.
-// Dev mode proxies to Vite, which injects inline preamble scripts and uses
-// a websocket for HMR. Loosen script-src and connect-src accordingly.
-// `'unsafe-eval'` is required at runtime for the Electron app, so it is
-// kept in both branches.
-const isDev = process.env.NODE_ENV === 'development';
-const scriptSrc = isDev
-  ? "'self' 'unsafe-inline' 'unsafe-eval' blob:"
-  : "'self' 'unsafe-eval' blob:";
-const connectSrc = isDev ? "'self' ws: wss: http: https:" : 'http: https:';
-const csp = [
-  "default-src 'self' blob:",
-  "img-src 'self' blob: data:",
-  `script-src ${scriptSrc}`,
-  "style-src 'self' 'unsafe-inline'",
-  "font-src 'self' data:",
-  `connect-src ${connectSrc}`,
-].join('; ');
-
+// The web frontend
 app.use((req, res, next) => {
   res.set('Cross-Origin-Opener-Policy', 'same-origin');
   res.set('Cross-Origin-Embedder-Policy', 'require-corp');
-  res.set('Content-Security-Policy', csp);
+  res.set(
+    'Content-Security-Policy',
+    "default-src 'self' blob:; img-src 'self' blob: data:; script-src 'self' 'unsafe-eval' blob:; style-src 'self' 'unsafe-inline'; font-src 'self' data:; connect-src http: https:;",
+  );
   next();
 });
-if (isDev) {
+if (process.env.NODE_ENV === 'development') {
   console.log(
     'Running in development mode - Proxying frontend routes to React Dev Server',
   );

packages/sync-server/src/load-config.js

@@ -21,6 +21,8 @@ const defaultDataDir = process.env.ACTUAL_DATA_DIR
 
 debug(`Project root: '${projectRoot}'`);
 
+export const sqlDir = path.join(__dirname, 'sql');
+
 const actualAppWebBuildPath = path.join(
   path.dirname(require.resolve('@actual-app/web/package.json')),
   'build',

packages/sync-server/src/migrations.ts

@@ -1,34 +1,40 @@
-import path from 'node:path';
+import { readdir } from 'node:fs/promises';
+import path, { dirname } from 'node:path';
+import { fileURLToPath, pathToFileURL } from 'node:url';
 
 import { load } from 'migrate';
 
 import { config } from './load-config';
 
 type MigrationCallback = (err?: Error) => void;
-type MigrationModule = {
-  up: (next?: MigrationCallback) => void;
-  down: (next?: MigrationCallback) => void;
-};
-
-// Vite resolves this glob at build time and inlines a static map of
-// () => import('chunks/...js') calls. Each migration becomes its own chunk.
-// Runtime fs reads against a migrations/ directory disappear.
-const migrationsLoaders = import.meta.glob<MigrationModule>(
-  '../migrations/*.{ts,js}',
-);
 
 export async function run(direction: 'up' | 'down' = 'up'): Promise<void> {
   console.log(
     `Checking if there are any migrations to run for direction "${direction}"...`,
   );
 
-  try {
-    const sortedKeys = Object.keys(migrationsLoaders).sort();
-    const migrationsModules: Record<string, MigrationModule> = {};
+  const __dirname = dirname(fileURLToPath(import.meta.url)); // this directory
+  const migrationsDir = path.join(__dirname, '../migrations');
 
-    for (const key of sortedKeys) {
-      const fileName = key.split('/').pop()!;
-      migrationsModules[fileName] = await migrationsLoaders[key]();
+  try {
+    // Load all script files in the migrations directory
+    const files = await readdir(migrationsDir);
+    const migrationsModules: Record<
+      string,
+      {
+        up: (next?: MigrationCallback) => void;
+        down: (next?: MigrationCallback) => void;
+      }
+    > = {};
+
+    for (const f of files
+      .filter(
+        f => (f.endsWith('.js') || f.endsWith('.ts')) && !f.endsWith('.d.ts'),
+      )
+      .sort((a, b) => (a > b ? 1 : a < b ? -1 : 0))) {
+      migrationsModules[f] = await import(
+        pathToFileURL(path.join(migrationsDir, f)).href
+      );
     }
 
     return new Promise<void>((resolve, reject) => {

packages/sync-server/src/sync-simple.js

@@ -1,9 +1,10 @@
-import { existsSync } from 'node:fs';
+import { existsSync, readFileSync } from 'node:fs';
+import { join } from 'node:path';
 
 import { merkle, SyncProtoBuf, Timestamp } from '@actual-app/crdt';
 
 import { openDatabase } from './db';
-import messagesSql from './sql/messages.sql?raw';
+import { sqlDir } from './load-config';
 import { getPathForGroupFile } from './util/paths';
 
 function getGroupDb(groupId) {
@@ -13,7 +14,8 @@ function getGroupDb(groupId) {
   const db = openDatabase(path);
 
   if (needsInit) {
-    db.exec(messagesSql);
+    const sql = readFileSync(join(sqlDir, 'messages.sql'), 'utf8');
+    db.exec(sql);
   }
 
   return db;

packages/sync-server/vite.config.mts

@@ -1,73 +0,0 @@
-import { readFileSync } from 'node:fs';
-import path from 'node:path';
-
-import { defineConfig } from 'vite';
-import type { Plugin } from 'vite';
-
-const pkg = JSON.parse(
-  readFileSync(path.resolve(__dirname, 'package.json'), 'utf-8'),
-);
-
-const shebangPlugin = (entryFile: string): Plugin => ({
-  name: 'sync-server-shebang',
-  generateBundle(_options, bundle) {
-    const chunk = bundle[entryFile];
-    if (chunk?.type === 'chunk' && !chunk.code.startsWith('#!')) {
-      chunk.code = `#!/usr/bin/env node\n${chunk.code}`;
-    }
-  },
-});
-
-export default defineConfig({
-  ssr: {
-    target: 'node',
-    // Inline workspace deps that ship as TS source. Anything else
-    // (express, better-sqlite3, bcrypt, @actual-app/web, etc.) stays
-    // external so Node resolves it at runtime.
-    noExternal: ['@actual-app/crdt'],
-  },
-  build: {
-    ssr: true,
-    target: 'node22',
-    outDir: path.resolve(__dirname, 'build'),
-    emptyOutDir: true,
-    sourcemap: true,
-    minify: false,
-    rollupOptions: {
-      input: {
-        app: path.resolve(__dirname, 'app.ts'),
-        'bin/actual-server': path.resolve(__dirname, 'bin/actual-server.js'),
-        'scripts/run-migrations': path.resolve(
-          __dirname,
-          'src/scripts/run-migrations.js',
-        ),
-        'scripts/reset-password': path.resolve(
-          __dirname,
-          'src/scripts/reset-password.js',
-        ),
-        'scripts/disable-openid': path.resolve(
-          __dirname,
-          'src/scripts/disable-openid.js',
-        ),
-        'scripts/enable-openid': path.resolve(
-          __dirname,
-          'src/scripts/enable-openid.js',
-        ),
-        'scripts/health-check': path.resolve(
-          __dirname,
-          'src/scripts/health-check.js',
-        ),
-      },
-      output: {
-        format: 'esm',
-        entryFileNames: '[name].js',
-        chunkFileNames: 'chunks/[name]-[hash].js',
-      },
-    },
-  },
-  define: {
-    __APP_VERSION__: JSON.stringify(pkg.version),
-  },
-  assetsInclude: ['**/*.sql'],
-  plugins: [shebangPlugin('bin/actual-server.js')],
-});

upcoming-release-notes/7691.md

@@ -0,0 +1,6 @@
+---
+category: Bugfixes
+authors: [matt-fidd]
+---
+
+Fix schedules not appearing on the mobile view when the date is changed by rules

upcoming-release-notes/7699.md

@@ -0,0 +1,6 @@
+---
+category: Maintenance
+authors: [matt-fidd]
+---
+
+Fix VRT update workflow failing

upcoming-release-notes/7702.md

@@ -1,6 +0,0 @@
----
-category: Maintenance
-authors: [MatissJanis]
----
-
-Refactor module resolution to load `@actual-app/crdt` from source during development.

upcoming-release-notes/7704.md

@@ -0,0 +1,6 @@
+---
+category: Bugfixes
+authors: [alecbakholdin]
+---
+
+Fixed cannot read properties of null in throwIfNot200 (reading 'toLowerCase')

yarn.lock

@@ -203,7 +203,6 @@ __metadata:
     pluggy-sdk: "npm:^0.83.0"
     supertest: "npm:^7.2.2"
     typescript-strict-plugin: "npm:^2.4.4"
-    vite: "npm:^8.0.5"
     vitest: "npm:^4.1.2"
     winston: "npm:^3.19.0"
   bin: