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