feat(db): update index and fix suggestion from gemini

Currently translated at 100.0% (1719 of 1719 strings)

Translation: Trilium Notes/Client
Translate-URL: https://hosted.weblate.org/projects/trilium/client/ja/

apps/build-docs/package.json

@@ -16,7 +16,7 @@
   "license": "AGPL-3.0-only",
   "packageManager": "pnpm@10.32.1",
   "devDependencies": {
-    "@redocly/cli": "2.24.0",
+    "@redocly/cli": "2.24.1",
     "archiver": "7.0.1",
     "fs-extra": "11.3.4",
     "js-yaml": "4.1.1",

apps/client/package.json

@@ -53,22 +53,22 @@
     "draggabilly": "3.0.0",
     "force-graph": "1.51.2",
     "globals": "17.4.0",
-    "i18next": "25.8.18",
+    "i18next": "25.10.3",
     "i18next-http-backend": "3.0.2",
     "jquery": "4.0.0",
     "jquery.fancytree": "2.38.5",
     "jsplumb": "2.15.6",
-    "katex": "0.16.39",
+    "katex": "0.16.40",
     "leaflet": "1.9.4",
     "leaflet-gpx": "2.2.0",
     "mark.js": "8.11.1",
-    "marked": "17.0.4",
+    "marked": "17.0.5",
     "mermaid": "11.13.0",
     "mind-elixir": "5.9.3",
     "normalize.css": "8.0.1",
     "panzoom": "9.4.3",
     "preact": "10.29.0",
-    "react-i18next": "16.5.8",
+    "react-i18next": "16.6.0",
     "react-window": "2.2.7",
     "reveal.js": "6.0.0",
     "rrule": "2.8.1",

apps/client/src/translations/el/translation.json

@@ -1,6 +1,6 @@
 {
   "about": {
-    "title": "Πληροφορίες για το Trilium Notes",
+    "title": "Σχετικά με το Trilium Notes",
     "homepage": "Αρχική Σελίδα:",
     "app_version": "Έκδοση εφαρμογής:",
     "db_version": "Έκδοση βάσης δεδομένων:",

apps/client/src/translations/ja/translation.json

@@ -1180,7 +1180,8 @@
     "is_owned_by_note": "ノートによって所有されています",
     "and_more": "...その他 {{count}} 件。",
     "print_landscape": "PDF にエクスポートするときに、ページの向きを縦向きではなく横向きに変更します。",
-    "print_page_size": "PDF にエクスポートするときに、ページのサイズを変更します。サポートされる値: <code>A0</code>, <code>A1</code>, <code>A2</code>, <code>A3</code>, <code>A4</code>, <code>A5</code>, <code>A6</code>, <code>Legal</code>, <code>Letter</code>, <code>Tabloid</code>, <code>Ledger</code>。"
+    "print_page_size": "PDF にエクスポートするときに、ページのサイズを変更します。サポートされる値: <code>A0</code>, <code>A1</code>, <code>A2</code>, <code>A3</code>, <code>A4</code>, <code>A5</code>, <code>A6</code>, <code>Legal</code>, <code>Letter</code>, <code>Tabloid</code>, <code>Ledger</code>。",
+    "textarea": "複数行テキスト"
   },
   "link_context_menu": {
     "open_note_in_popup": "クイック編集",

apps/client/src/translations/tw/translation.json

@@ -446,7 +446,8 @@
     "app_theme_base": "設定為 \"next\"、\"next-light \" 或 \"next-dark\"，以使用相應的 TriliumNext 主題（自動、淺色或深色）作為自訂主題的基礎，而非傳統主題。",
     "print_landscape": "匯出為 PDF 時，將頁面方向更改為橫向而非縱向。",
     "print_page_size": "在匯出 PDF 時更改頁面大小。支援的值：<code>A0</code>、<code>A1</code>、<code>A2</code>、<code>A3</code>、<code>A4</code>、<code>A5</code>、<code>A6</code>、<code>Legal</code>、<code>Letter</code>、<code>Tabloid</code>、<code>Ledger</code>。",
-    "color_type": "顏色"
+    "color_type": "顏色",
+    "textarea": "多行文字"
   },
   "attribute_editor": {
     "help_text_body1": "要新增標籤，只需輸入例如 <code>#rock</code> 或者如果您還想新增值，則例如 <code>#year = 2020</code>",
@@ -2182,5 +2183,52 @@
   },
   "setup_form": {
     "more_info": "了解更多"
+  },
+  "media": {
+    "play": "播放 (空白鍵)",
+    "pause": "暫停 (空白鍵)",
+    "back-10s": "往前 10 秒 (左方向鍵)",
+    "forward-30s": "往後 30 秒",
+    "mute": "靜音 (M)",
+    "unmute": "解除靜音 (M)",
+    "playback-speed": "播放速度",
+    "loop": "循環",
+    "disable-loop": "解除循環",
+    "rotate": "旋轉",
+    "picture-in-picture": "畫中畫",
+    "exit-picture-in-picture": "退出畫中畫",
+    "fullscreen": "全螢幕 (F)",
+    "exit-fullscreen": "退出全螢幕",
+    "unsupported-format": "此檔案格式不支援媒體預覽：\n{{mime}}",
+    "zoom-to-fit": "放大至填滿畫面",
+    "zoom-reset": "重設放大至填滿畫面"
+  },
+  "mermaid": {
+    "placeholder": "請輸入您的美人魚圖表內容，或選用下方其中一個範例圖表。",
+    "sample_diagrams": "範例圖表：",
+    "sample_flowchart": "流程圖",
+    "sample_class": "階層圖",
+    "sample_sequence": "時序圖",
+    "sample_entity_relationship": "實體關係圖",
+    "sample_state": "狀態圖",
+    "sample_mindmap": "心智圖",
+    "sample_architecture": "架構圖",
+    "sample_block": "區塊圖",
+    "sample_c4": "C4 圖",
+    "sample_gantt": "甘特圖",
+    "sample_git": "Git 分支圖",
+    "sample_kanban": "看板圖",
+    "sample_packet": "數據包圖",
+    "sample_pie": "圓餅圖",
+    "sample_quadrant": "象限圖",
+    "sample_radar": "雷達圖",
+    "sample_requirement": "需求圖",
+    "sample_sankey": "桑基圖",
+    "sample_timeline": "時間軸",
+    "sample_treemap": "樹狀圖",
+    "sample_user_journey": "用戶旅程",
+    "sample_xy": "XY 圖表",
+    "sample_venn": "韋恩圖",
+    "sample_ishikawa": "魚骨圖"
   }
 }

apps/dump-db/package.json

@@ -6,7 +6,7 @@
   "dependencies": {
     "better-sqlite3": "12.8.0",
     "mime-types": "3.0.2",
-    "sanitize-filename": "1.6.3",
+    "sanitize-filename": "1.6.4",
     "tsx": "4.21.0",
     "yargs": "18.0.0"
   },

apps/server/package.json

@@ -99,7 +99,7 @@
     "html2plaintext": "2.1.4",
     "http-proxy-agent": "8.0.0",
     "https-proxy-agent": "8.0.0",
-    "i18next": "25.8.18",
+    "i18next": "25.10.3",
     "i18next-fs-backend": "2.6.1",
     "image-type": "6.0.0",
     "ini": "6.0.0",
@@ -107,13 +107,13 @@
     "is-svg": "6.1.0",
     "jimp": "1.6.0",
     "lorem-ipsum": "2.0.8",
-    "marked": "17.0.4",
+    "marked": "17.0.5",
     "mime-types": "3.0.2",
     "multer": "2.1.1",
     "normalize-strings": "1.1.1",
     "rand-token": "1.0.1",
     "safe-compare": "1.1.4",
-    "sanitize-filename": "1.6.3",
+    "sanitize-filename": "1.6.4",
     "sanitize-html": "2.17.2",
     "sax": "1.6.0",
     "serve-favicon": "2.5.1",
@@ -127,7 +127,7 @@
     "turnish": "1.8.0",
     "unescape": "1.0.1",
     "vite": "8.0.1",
-    "ws": "8.19.0",
+    "ws": "8.20.0",
     "xml2js": "0.6.2",
     "yauzl": "3.2.1"
   }

apps/server/src/assets/db/schema.sql

@@ -79,7 +79,7 @@ CREATE UNIQUE INDEX `IDX_entityChanges_entityName_entityId` ON "entity_changes"
                                                                                  `entityId`
     );
 CREATE INDEX `IDX_branches_noteId_parentNoteId` ON `branches` (`noteId`,`parentNoteId`);
-CREATE INDEX IDX_branches_parentNoteId ON branches (parentNoteId);
+CREATE INDEX IDX_branches_parentNoteId_isDeleted_notePosition ON branches (parentNoteId, isDeleted, notePosition);
 CREATE INDEX `IDX_notes_title` ON `notes` (`title`);
 CREATE INDEX `IDX_notes_type` ON `notes` (`type`);
 CREATE INDEX `IDX_notes_dateCreated` ON `notes` (`dateCreated`);
@@ -146,6 +146,13 @@ CREATE INDEX IDX_notes_blobId on notes (blobId);
 CREATE INDEX IDX_revisions_blobId on revisions (blobId);
 CREATE INDEX IDX_attachments_blobId on attachments (blobId);
 
+CREATE INDEX IDX_entity_changes_isSynced_id ON entity_changes (isSynced, id);
+CREATE INDEX IDX_entity_changes_isErased_entityName ON entity_changes (isErased, entityName);
+CREATE INDEX IDX_notes_isDeleted_utcDateModified ON notes (isDeleted, utcDateModified);
+CREATE INDEX IDX_branches_isDeleted_utcDateModified ON branches (isDeleted, utcDateModified);
+CREATE INDEX IDX_attributes_isDeleted_utcDateModified ON attributes (isDeleted, utcDateModified);
+CREATE INDEX IDX_attachments_isDeleted_utcDateModified ON attachments (isDeleted, utcDateModified);
+CREATE INDEX IDX_attachments_utcDateScheduledForErasureSince ON attachments (utcDateScheduledForErasureSince);
 
 CREATE TABLE IF NOT EXISTS sessions (
     id TEXT PRIMARY KEY,

apps/server/src/migrations/migrations.ts

@@ -6,6 +6,27 @@
 
 // Migrations should be kept in descending order, so the latest migration is first.
 const MIGRATIONS: (SqlMigration | JsMigration)[] = [
+    // Add missing database indices for query performance
+    {
+        version: 235,
+        sql: /*sql*/`
+            CREATE INDEX IF NOT EXISTS IDX_entity_changes_isSynced_id
+                ON entity_changes (isSynced, id);
+            CREATE INDEX IF NOT EXISTS IDX_entity_changes_isErased_entityName
+                ON entity_changes (isErased, entityName);
+            CREATE INDEX IF NOT EXISTS IDX_notes_isDeleted_utcDateModified
+                ON notes (isDeleted, utcDateModified);
+            CREATE INDEX IF NOT EXISTS IDX_branches_isDeleted_utcDateModified
+                ON branches (isDeleted, utcDateModified);
+            CREATE INDEX IF NOT EXISTS IDX_attributes_isDeleted_utcDateModified
+                ON attributes (isDeleted, utcDateModified);
+            CREATE INDEX IF NOT EXISTS IDX_attachments_isDeleted_utcDateModified
+                ON attachments (isDeleted, utcDateModified);
+            DROP INDEX IF EXISTS IDX_branches_parentNoteId;
+            CREATE INDEX IF NOT EXISTS IDX_branches_parentNoteId_isDeleted_notePosition
+                ON branches (parentNoteId, isDeleted, notePosition);
+        `
+    },
     // Migrate aiChat notes to code notes since LLM integration has been removed
     {
         version: 234,

apps/server/src/services/app_info.ts

@@ -5,7 +5,7 @@ import packageJson from "../../package.json" with { type: "json" };
 import build from "./build.js";
 import dataDir from "./data_dir.js";
 
-const APP_DB_VERSION = 234;
+const APP_DB_VERSION = 235;
 const SYNC_VERSION = 37;
 const CLIPPER_PROTOCOL_VERSION = "1.0";
 

apps/website/package.json

@@ -9,16 +9,16 @@
 		"preview": "pnpm build && vite preview"
 	},
 	"dependencies": {
-		"i18next": "25.8.18",
+		"i18next": "25.10.3",
 		"i18next-http-backend": "3.0.2",
 		"preact": "10.29.0",
 		"preact-iso": "2.11.1",
 		"preact-render-to-string": "6.6.6",
-		"react-i18next": "16.5.8"
+		"react-i18next": "16.6.0"
 	},
 	"devDependencies": {
-		"@preact/preset-vite": "2.10.4",
-		"eslint": "10.0.3",
+		"@preact/preset-vite": "2.10.5",
+		"eslint": "10.1.0",
 		"eslint-config-preact": "2.0.0",
 		"typescript": "5.9.3",
 		"user-agent-data-types": "0.4.2",

flake.lock

@@ -20,11 +20,11 @@
     },
     "nixpkgs": {
       "locked": {
-        "lastModified": 1769184885,
-        "narHash": "sha256-wVX5Cqpz66SINNsmt3Bv/Ijzzfl8EPUISq5rKK129K0=",
+        "lastModified": 1774171785,
+        "narHash": "sha256-upDSNdH1WEL2Z0ISvRXTWk7rEndTxUcaTOLY9imJYa8=",
         "owner": "NixOS",
         "repo": "nixpkgs",
-        "rev": "12689597ba7a6d776c3c979f393896be095269d4",
+        "rev": "f8a13215c766347f3da9beef4cfc952eb23fa46e",
         "type": "github"
       },
       "original": {
@@ -43,15 +43,16 @@
         ]
       },
       "locked": {
-        "lastModified": 1749022118,
-        "narHash": "sha256-7Qzmy1snKbxFBKoqUrfyxxmEB8rPxDdV7PQwRiAR01o=",
-        "owner": "FliegendeWurst",
+        "lastModified": 1774171918,
+        "narHash": "sha256-0OBrtBnowvYP/YMKh7GB1GX22ORK+2X771EVgT+1tsk=",
+        "owner": "TriliumNext",
         "repo": "pnpm2nix-nzbr",
-        "rev": "35f88a41d29839b3989f31871263451c8e092cb1",
+        "rev": "536d67261ffe7c91cb286c8581cc799a1b61e969",
         "type": "github"
       },
       "original": {
-        "owner": "FliegendeWurst",
+        "owner": "TriliumNext",
+        "ref": "fix/optional_dependencies_filtering",
         "repo": "pnpm2nix-nzbr",
         "type": "github"
       }

flake.nix

@@ -5,7 +5,7 @@
     nixpkgs.url = "github:NixOS/nixpkgs";
     flake-utils.url = "github:numtide/flake-utils";
     pnpm2nix = {
-      url = "github:FliegendeWurst/pnpm2nix-nzbr";
+      url = "github:TriliumNext/pnpm2nix-nzbr/fix/optional_dependencies_filtering";
       inputs = {
         flake-utils.follows = "flake-utils";
         nixpkgs.follows = "nixpkgs";
@@ -325,6 +325,8 @@
           buildInputs = [
             nodejs
             pnpm
+            electron
+            nodejs.python
           ];
         };
       }

package.json

@@ -59,7 +59,7 @@
     "cross-env": "10.1.0",
     "dpdm": "4.0.1",
     "esbuild": "0.27.4",
-    "eslint": "10.0.3",
+    "eslint": "10.1.0",
     "eslint-config-preact": "2.0.0",
     "eslint-config-prettier": "10.1.8",
     "eslint-plugin-playwright": "2.10.1",

packages/ckeditor5-admonition/package.json

@@ -29,11 +29,11 @@
     "@vitest/browser": "4.1.0",
     "@vitest/coverage-istanbul": "4.1.0",
     "ckeditor5": "47.6.1",
-    "eslint": "10.0.3",
+    "eslint": "10.1.0",
     "eslint-config-ckeditor5": ">=9.1.0",
     "http-server": "14.1.1",
     "lint-staged": "16.4.0",
-    "stylelint": "17.4.0",
+    "stylelint": "17.5.0",
     "stylelint-config-ckeditor5": ">=9.1.0",
     "ts-node": "10.9.2",
     "typescript": "5.9.3",

packages/ckeditor5-footnotes/package.json

@@ -30,11 +30,11 @@
     "@vitest/browser": "4.1.0",
     "@vitest/coverage-istanbul": "4.1.0",
     "ckeditor5": "47.6.1",
-    "eslint": "10.0.3",
+    "eslint": "10.1.0",
     "eslint-config-ckeditor5": ">=9.1.0",
     "http-server": "14.1.1",
     "lint-staged": "16.4.0",
-    "stylelint": "17.4.0",
+    "stylelint": "17.5.0",
     "stylelint-config-ckeditor5": ">=9.1.0",
     "ts-node": "10.9.2",
     "typescript": "5.9.3",

packages/ckeditor5-keyboard-marker/package.json

@@ -32,11 +32,11 @@
     "@vitest/browser": "4.1.0",
     "@vitest/coverage-istanbul": "4.1.0",
     "ckeditor5": "47.6.1",
-    "eslint": "10.0.3",
+    "eslint": "10.1.0",
     "eslint-config-ckeditor5": ">=9.1.0",
     "http-server": "14.1.1",
     "lint-staged": "16.4.0",
-    "stylelint": "17.4.0",
+    "stylelint": "17.5.0",
     "stylelint-config-ckeditor5": ">=9.1.0",
     "ts-node": "10.9.2",
     "typescript": "5.9.3",

packages/ckeditor5-math/package.json

@@ -32,11 +32,11 @@
     "@vitest/browser": "4.1.0",
     "@vitest/coverage-istanbul": "4.1.0",
     "ckeditor5": "47.6.1",
-    "eslint": "10.0.3",
+    "eslint": "10.1.0",
     "eslint-config-ckeditor5": ">=9.1.0",
     "http-server": "14.1.1",
     "lint-staged": "16.4.0",
-    "stylelint": "17.4.0",
+    "stylelint": "17.5.0",
     "stylelint-config-ckeditor5": ">=9.1.0",
     "ts-node": "10.9.2",
     "typescript": "5.9.3",

packages/ckeditor5-mermaid/package.json

@@ -32,11 +32,11 @@
     "@vitest/browser": "4.1.0",
     "@vitest/coverage-istanbul": "4.1.0",
     "ckeditor5": "47.6.1",
-    "eslint": "10.0.3",
+    "eslint": "10.1.0",
     "eslint-config-ckeditor5": ">=9.1.0",
     "http-server": "14.1.1",
     "lint-staged": "16.4.0",
-    "stylelint": "17.4.0",
+    "stylelint": "17.5.0",
     "stylelint-config-ckeditor5": ">=9.1.0",
     "ts-node": "10.9.2",
     "typescript": "5.9.3",

packages/codemirror/package.json

@@ -52,6 +52,6 @@
     "codemirror-lang-elixir": "4.0.1",
     "codemirror-lang-hcl": "0.1.0",
     "codemirror-lang-mermaid": "0.5.0",
-    "eslint-linter-browserify": "10.0.3"
+    "eslint-linter-browserify": "10.1.0"
   }
 }

packages/share-theme/package.json

@@ -25,7 +25,7 @@
   "license": "Apache-2.0",
   "dependencies": {
     "fuse.js": "7.1.0",
-    "katex": "0.16.39",
+    "katex": "0.16.40",
     "mermaid": "11.13.0"
   },
   "devDependencies": {
@@ -35,7 +35,7 @@
     "@typescript-eslint/parser": "8.57.1",
     "dotenv": "17.3.1",
     "esbuild": "0.27.4",
-    "eslint": "10.0.3",
+    "eslint": "10.1.0",
     "highlight.js": "11.11.1",
     "typescript": "5.9.3"
   }