497 Commits

Author SHA1 Message Date
Daniel 342e2d43f6 Use FTS5 external content mode for blocks_fts to deduplicate data with blocks https://github.com/siyuan-note/siyuan/issues/17540
Signed-off-by: Daniel <845765@qq.com>
2026-07-03 14:16:20 +08:00
Daniel 96a2cc4c8e 🎨 Improve booting
Signed-off-by: Daniel <845765@qq.com>
2026-07-02 14:10:24 +08:00
Daniel 6da87f9450 🔒 https://github.com/siyuan-note/siyuan/security/advisories/GHSA-h89q-4j2h-7h88
Signed-off-by: Daniel <845765@qq.com>
2026-07-02 10:24:19 +08:00
Daniel b2b4f37b6a Semantic search using AI embeddings https://github.com/siyuan-note/siyuan/issues/17788
Signed-off-by: Daniel <845765@qq.com>
2026-07-01 07:54:41 +08:00
Daniel 2f133c5b5b Semantic search using AI embeddings https://github.com/siyuan-note/siyuan/issues/17788 https://github.com/siyuan-note/siyuan/issues/18002
Signed-off-by: Daniel <845765@qq.com>
2026-06-30 22:26:42 +08:00
Daniel 12693d503d Improve database view performance https://github.com/siyuan-note/siyuan/issues/17830
Signed-off-by: Daniel <845765@qq.com>
2026-06-27 19:49:47 +08:00
Daniel 2ee9678ce0 Improve database view performance https://github.com/siyuan-note/siyuan/issues/17830
Signed-off-by: Daniel <845765@qq.com>
2026-06-27 16:43:01 +08:00
Daniel db266e7fab 🎨 Improve block op api
Signed-off-by: Daniel <845765@qq.com>
2026-06-20 11:21:15 +08:00
Daniel 2ca1f179f0 Improve database view performance https://github.com/siyuan-note/siyuan/issues/17830
Signed-off-by: Daniel <845765@qq.com>
2026-06-17 19:55:41 +08:00
Daniel 4553a4319d Improve database view performance https://github.com/siyuan-note/siyuan/issues/17830
Signed-off-by: Daniel <845765@qq.com>
2026-06-17 17:47:50 +08:00
Daniel 59dc786120 New settings UI https://github.com/siyuan-note/siyuan/issues/17601
Signed-off-by: Daniel <845765@qq.com>
2026-06-13 12:09:59 +08:00
Daniel 6d6c3b14ac ♻️ No longer create table blocks_fts_case_insensitive https://github.com/siyuan-note/siyuan/issues/17849
Signed-off-by: Daniel <845765@qq.com>
2026-06-12 22:18:07 +08:00
游夏 36f4e3720e 🎨 Add Simplified/Traditional Chinese sensitivity option (#17846)
*  搜索支持区分繁简选项 Add Simplified/Traditional Chinese sensitivity option for search

新增搜索配置 hanSensitive(区分繁简,默认开启 = 现状行为,命名与语义
向 caseSensitive 对齐)。关闭后简体与繁体可互相检索。

- FTS 层:关闭区分繁简时,blocks_fts / blocks_fts_case_insensitive 建表
  追加 han_insensitive 分词器参数(依赖 88250/go-sqlite3 配套补丁),
  繁体在分词时按单字折叠为简体,token 偏移仍指向原文;
- 切换选项复用区分大小写现有的 FullReindex 流程;
- 高亮:EncloseHighlighting 在关闭区分繁简时将关键字逐字符展开为
  繁简等价字符类(如 诗经 -> [诗詩][经經]),与分词器使用同一份
  OpenCC TSCharacters 映射数据;
- 兼容:旧版本 conf.json 缺 hanSensitive 字段时按既往行为置为开启;
  setSearch 请求未携带该字段(现行前端/第三方调用)时保持当前值,
  避免被零值意外翻转并触发重建索引;
- 遵照配置界面重写计划(#17601),本次不改动设置界面与 i18n,仅添加
  配置数据结构字段与前端类型定义(config.d.ts)。

范围说明:本次仅覆盖块全文搜索(关键字/查询语法)的命中与高亮;
历史/资源文件搜索、数据库属性过滤、虚拟引用、查找替换的替换动作
不在本次范围内(替换保持字节精确以避免误改原文)。

Fixes #13304

* 🐛 add missing util.SearchHanSensitive referenced by highlighting and sql.SetHanSensitive

Copilot 评审指出 util.SearchHanSensitive 未定义导致无法编译:补上该全局
变量(默认 true,与既往行为一致,由 sql.SetHanSensitive 维护),并修正
conf/search.go 的 gofmt 对齐。已在本地以 dev 当前 go.mod(已合并的
88250/go-sqlite3 分词器)完成 go build -tags fts5 与 kernel/search 单测验证。
2026-06-12 15:59:50 +08:00
Daniel b0110bc381 Improve database view performance https://github.com/siyuan-note/siyuan/issues/17830
Signed-off-by: Daniel <845765@qq.com>
2026-06-08 10:03:34 +08:00
Daniel 99eb811b86 Improve database view performance https://github.com/siyuan-note/siyuan/issues/17830
Signed-off-by: Daniel <845765@qq.com>
2026-06-08 09:09:39 +08:00
Daniel 88ae06150d 🎨 Improve indexing
Signed-off-by: Daniel <845765@qq.com>
2026-06-04 12:17:50 +08:00
Daniel 5a02e7b28f Semantic search using AI embeddings https://github.com/siyuan-note/siyuan/issues/17788
Signed-off-by: Daniel <845765@qq.com>
2026-05-31 09:46:42 +08:00
Daniel 08aaaedb13 Semantic search using AI embeddings https://github.com/siyuan-note/siyuan/issues/17788
Signed-off-by: Daniel <845765@qq.com>
2026-05-30 21:04:01 +08:00
Daniel f57eb24470 🎨 https://github.com/siyuan-note/siyuan/issues/17786
Signed-off-by: Daniel <845765@qq.com>
2026-05-30 10:37:08 +08:00
Jeffrey Chen eb35db7fbe ♻️ Refactor error messages in SQL statement validation for clarity (#17723) 2026-05-29 09:44:40 +08:00
Daniel f0488af4b3 🐛 https://github.com/siyuan-note/siyuan/issues/17716
Signed-off-by: Daniel <845765@qq.com>
2026-05-24 21:25:11 +08:00
Daniel 4afa0adfa6 🎨 Improve rebuild index https://github.com/siyuan-note/siyuan/issues/17713
Signed-off-by: Daniel <845765@qq.com>
2026-05-24 21:05:03 +08:00
Jeffrey Chen 0a454d3cb7 🎨 Add read-only mode to /api/query/sql (#17696)
* 🧑‍💻 Add read-only mode to `/api/query/sql`

* 🎨 sql.CheckSingleStatement excludes end-of-line comments
2026-05-18 18:28:31 +08:00
Daniel d711ede632 🎨 https://github.com/siyuan-note/siyuan/issues/17695
Signed-off-by: Daniel <845765@qq.com>
2026-05-18 11:36:00 +08:00
Daniel ec0dedcba2 🎨 https://github.com/siyuan-note/siyuan/issues/17695
Signed-off-by: Daniel <845765@qq.com>
2026-05-17 21:31:56 +08:00
Daniel 1987ec3aba 🎨 Improve data indexing stability https://github.com/siyuan-note/siyuan/issues/17610
Signed-off-by: Daniel <845765@qq.com>
2026-05-16 17:53:33 +08:00
Daniel e4c346b65d 🎨 Improve data indexing stability https://github.com/siyuan-note/siyuan/issues/17610
Signed-off-by: Daniel <845765@qq.com>
2026-05-16 16:59:55 +08:00
Daniel 2e33429a37 🎨 Improve index queue https://github.com/siyuan-note/siyuan/issues/17694
Signed-off-by: Daniel <845765@qq.com>
2026-05-16 14:41:53 +08:00
Daniel 2a5356a236 🎨 Improve index queue
Signed-off-by: Daniel <845765@qq.com>
2026-05-16 14:41:53 +08:00
Daniel b0177c4aa1 Command Line Interface https://github.com/siyuan-note/siyuan/issues/17674
Signed-off-by: Daniel <845765@qq.com>
2026-05-13 21:18:21 +08:00
Daniel b6ba091f7d Command Line Interface https://github.com/siyuan-note/siyuan/issues/17674
Signed-off-by: Daniel <845765@qq.com>
2026-05-13 19:55:40 +08:00
Daniel 038dc6e183 🎨 Improve wal queue
Signed-off-by: Daniel <845765@qq.com>
2026-05-10 19:32:03 +08:00
Qiaochu Hu 3071ad22d4 🔒 Use parameterized queries in putStat to prevent SQL injection (#17658)
The putStat function in kernel/sql/stat.go was building SQL queries
via string concatenation instead of using parameterized queries.
While currently only called with hardcoded internal values, this is
a defense-in-depth improvement that prevents future SQL injection
if the function is ever called with user-controlled input.

The execStmtTx helper already supports variadic args, so this is
a straightforward change to use ? placeholders.

Co-authored-by: Test User <test@example.com>
Co-authored-by: Claude Opus 4.7 <noreply@anthropic.com>
2026-05-10 19:24:21 +08:00
Daniel 52b8a7cfed 🎨 add WAL persistence for database index queue to improve data indexing stability https://github.com/siyuan-note/siyuan/issues/17610
Signed-off-by: Daniel <845765@qq.com>
2026-04-29 21:45:55 +08:00
Daniel de5e7fd2b9 🎨 https://github.com/siyuan-note/siyuan/issues/17592
Signed-off-by: Daniel <845765@qq.com>
2026-04-29 09:28:35 +08:00
Daniel 1ae36f885e 🎨 https://github.com/siyuan-note/siyuan/issues/17545#issuecomment-4293316202
Signed-off-by: Daniel <845765@qq.com>
2026-04-22 11:27:46 +08:00
Jeffrey Chen 1cb44c4d24 🐛 Correct the FTS target table branch of indexNode https://github.com/siyuan-note/siyuan/issues/17536 (#17557) 2026-04-20 23:22:17 +08:00
Daniel c66018958e 🎨 https://github.com/siyuan-note/siyuan/issues/17545
Signed-off-by: Daniel <845765@qq.com>
2026-04-19 17:34:22 +08:00
Daniel 1486804d67 🎨 https://github.com/siyuan-note/siyuan/issues/17534 https://github.com/siyuan-note/siyuan/issues/17545
Signed-off-by: Daniel <845765@qq.com>
2026-04-19 17:21:55 +08:00
Daniel 2d052a9400 🎨 https://github.com/siyuan-note/siyuan/issues/17536 https://github.com/siyuan-note/siyuan/issues/5889
Signed-off-by: Daniel <845765@qq.com>
2026-04-19 11:42:43 +08:00
Daniel 9fee2993f9 🐛 https://github.com/siyuan-note/siyuan/issues/17537
Signed-off-by: Daniel <845765@qq.com>
2026-04-19 11:23:59 +08:00
Daniel f5998d84b8 https://github.com/siyuan-note/siyuan/issues/17539
Signed-off-by: Daniel <845765@qq.com>
2026-04-19 10:40:38 +08:00
Daniel 95e96ac41c Improve ristretto NumCounters
Signed-off-by: Daniel <845765@qq.com>
2026-04-15 21:56:43 +08:00
Daniel df897f5390 🎨 https://github.com/siyuan-note/siyuan/issues/17440
Signed-off-by: Daniel <845765@qq.com>
2026-04-09 13:28:41 +08:00
Jeffrey Chen f9c5c482b8 🎨 Parameterized label query statements and escaping LIKE wildcards (#17416) 2026-04-06 09:30:04 +08:00
Jeffrey Chen bb9cb86bd7 🎨 Empty tags are once again displayed in the tag panel (#17408) 2026-04-05 16:59:02 +08:00
Jeffrey Chen 5c674d7249 ♻️ Replace interface{} with any (#17415) 2026-04-05 16:48:32 +08:00
Jeffrey Chen 064754128b ♻️ Replace time.Now().Sub(start) with time.Since(start) (#17401) 2026-04-04 08:48:32 +08:00
Jeffrey Chen a674b14806 🎨 Empty tags no longer appear in the tag panel https://github.com/siyuan-note/siyuan/issues/17367 (#17369)
Co-authored-by: D <845765@qq.com>
2026-03-31 22:14:00 +08:00
Daniel 52fc9bea6b 🐛 Images in the database assets fields are not displaying https://github.com/siyuan-note/siyuan/issues/17368
🔒 https://github.com/siyuan-note/siyuan/security/advisories/GHSA-rx4h-526q-4458

Signed-off-by: Daniel <845765@qq.com>
2026-03-31 22:05:01 +08:00