alvorithm - LiuYun

Collect article Table to Database (Solved)

Hello; I imported a markdown file that I want in a database, but the import placed it in a table. Is there anyway to convert a table to a database or import the ..

2 days

Thank reply Configure SiYuan for S3 sync

For those thinking about self-hosting an S3-compatible object storage for SiYuan, it's totally worth it. I've used Minio in a docker container, with SWAG to tak ..

2 days

Vote up article Database relation selector column & dot notation column access

Please consider the possibility: In the database's relation column settings, add the ability to display records not only by key value but also by any data colum ..

4 weeks

Collect article Use AI to find related notes

Hello, Just discoverd Liuyun - would be interested to switch because its open source. One thing I rely on in Obsidian is a plugin called Smart Connections: [url ..

4 weeks

Vote up article Keyboard navigation between documents: How to move cursor to links without mouse?

I'm trying to navigate between linked documents using only keyboard shortcuts. However, the usual Ctrl+Enter or Alt+Enter combinations aren't working for moving ..

5 months

Post reply relative path for link

Hi @88250 , probably @zacl refers to relative links to arbitrary files in the filesystem. The FAQ says only absolute links are supported. But it would be great ..

6 months

Post reply Better Sync: Peer to Peer SiYuan sync plugin

Thanks @dd3boh for this! It sounds as if it could be a workable approach for fast sync, in particular for paid subscribers outside of USA or China (where the da ..

6 months

Follow user ACai

6 months

Follow user SternCat

6 months

Follow user massivebox

6 months

Post reply Blogging with SiYuan and Astro

Thank you @massivebox for this contribution! I am wondering if the script could get the YAML metadata from a SiYuan database instead of a code block. This would ..

6 months

Collect article Some useful SQL snippets

table: blocks This table is used to store content block data. In the blocks table you can find all base attributes you may want to use in your embed blocks like ..

7 months

Collect article SyMark: Transform Your SiYuan Notes into Beautiful Websites

I've been working on an open-source tool that allows you to convert SiYuan notebooks into full websites. Website: [url] GitHub: [url] To use it, replace the con ..

7 months

Collect article CodeSnippet Share - Depth for local graph view

[url]

7 months

Post comment Choose a Primary Workspace

It is understandable - at least in Linux, the path would work unquoted if it does not contain any spaces. It seems safer to always quote, especially in the docu ..

9 months

Post reply Choose a Primary Workspace

Hi there, You can find your workspace path form a running SiYuan instance navigate to the menu (click on the button top right labeled with your workspace name, ..

9 months

Collect article Setup AI locally by Ollama

EDIT: With SiYuan >=3.0.0 setup is much easier. Please see my latest comment. It is possible to serve a LLM locally using an OpenAI compatible API. It seems ..

9 months

Collect article Search asset content not working on pdf files

Hi, I can't seem to be able to search asset content. Perhaps my understanding of the feature is incorrect, so if someone can correct me that would be great too. ..

10 months

Collect article Add the ability to move assets

Hi, This is a follow up to [url]. I can know lists assets in subfolders. The issue ie now I want to re-organize all my existing assets in subfolders, ie move th ..

10 months

Thank article Add the ability to move assets

Hi, This is a follow up to [url]. I can know lists assets in subfolders. The issue ie now I want to re-organize all my existing assets in subfolders, ie move th ..

10 months

Collect article Translated Documentation for Tomato Toolbox

Hi, I'm interested in the Tomato Toolbox plugin, but the documenation is only available in Chinese, and on a website that I cannot translate with google. The do ..

10 months

Collect article Any helpful A-Z english tutorial on using Siyuan?

I scoured through the internet but failed to find any. I found two videos from a youtuber but those weren't that comprehensive & outdated. So if anyone coul ..

10 months

Collect article Setting up siyuan with docker and exposing it with cloudflare

Hi all! I'm new to everything siyuan and docker related and struggling to understand how to set it up so my workspace can be accessible from any computer browse ..

10 months

Collect article SiYuan Plugin Development: Quick Start

Acknowledge: this is the translation version of my early published article '思源插件开发 Quick Start' in Chinese. I used Gemini for translation and did a little langu ..

10 months

Collect article Siyuan Free Tutorial on DeepSeek-R1

注册账号 https://cloud.siliconflow.cn/i/Ucx0UaVz 　　Registering an account on this website can be done through GitHub or email, which is very convenient [pic] GET AP ..

10 months

Collect article Some missing topics on user guide

Hi, I'd like to introduce myself. I've just started using SiYuan as a note-taking app, and I'm really enjoying it! However, while following the provided guide, ..

10 months

Collect article How to use "inbox" feature?

As a lifetime user, how do I use the Inbox feature? The instructions in the user guide are very superficial. It only talks about API, where to find it, but it d ..

10 months

Thank reply How to use "inbox" feature?

Sending to the SiYuan-Inbox is quiet easy from a small script. I have an example for ruby here... You need to change 'token xxx' require 'net/http' require 'jso ..

10 months

Thank article Backlinks with Database possible?

In Siyuan the database feature is one of my favorites. However, when I link documents with it, they don't actually get linked, and therefore the connections don ..

10 months

Thank article [New plug-in: Task List] Automatically summarize the task nodes of the entire workspace together

Change Log 【Task List Plugin Major Update】AI Roast Mode is here, making your task list no longer boring! [Task List plug-in v0.0.3 version update] Supports hidi ..

1 year

Vote up article Allow folders in `/assets/`

Hi, It seems that right now, the assets folders can only have 1 level. Ie, if you create a folder like assets/foo and put an asset in it (assets/foo/bar.png), t ..

1 year

Post reply Allow folders in `/assets/`

I fully support this. As an addition, it would also be great to have symbolic links; then one could integrate much more with the filesystem.

1 year

Post reply SiYuan Template Function Guide for Newcomers: Template Syntax + Functions + Markdown Block Syntax

This is great 👍 @frostime , I was thinking of posting the Google Translate version I had been using myself.

1 year

Post article Template for a date stamp pointing at today's daily note

.action{/*Insert a ref linking to today's daily note*/} .action{$yyyymmdd:= now |date '20060102'} .action{$d := first (queryBlocks 'SELECT * FROM blocks WHERE i ..

1 year

Post article Query to access inline memo content

Hi dear community, Inline memos are annotations that can be added to inline text. While I know how to access via SQL block memos, I can't see how to get at inli ..

1 year

Post reply 'Add to Database' question

Hi, @revachol, your question and @WanChen's answer helpe me come up with a solution to a slightly related problem: [url] Thank you!

1 year

Post article Advice on how to improve a database template

I wanted to collect data from a block's textual content and put it automatically into a database column. The following code is what I came up with in order to g ..

1 year

Vote up article Create & Edit templates directly in SiYuan

I recently discovered the Monaco (vs code editor) plugin for SiYuan. It creates an additional menu entry similar to the DocTree but for files in the SiYuan fold ..

1 year

Collect article Create & Edit templates directly in SiYuan

I recently discovered the Monaco (vs code editor) plugin for SiYuan. It creates an additional menu entry similar to the DocTree but for files in the SiYuan fold ..

1 year

Collect article Weekly planning in SiYuan

I set up my weekly planning workflow in SiYuan and thought I might share in case it is useful for others Setup for the plan First I set up a horizontal Super bl ..

1 year

Post comment SQL query with JavaScript

Thank you, this is useful, if somewhat disappointing. Even just developing a query is cumbersome if it has to be edited outside of SiYuan as a template. It is u ..

1 year

Post comment SQL query with JavaScript

many thanks for these examples @dwinkl! However, we still don't know how to get the id of the parent block or document, right?

1 year

Post reply SQL query with JavaScript

I asked about it [url]. So far I've managed to use the document id only when using the query plugin, but then I can't render the blocks like the default embed b ..

1 year

Post reply Unreadable titles in tabs

This can actually get very bad in other contexts, see below the bug in action in the search widget. @88250, @Vanessa is better to report as a bug in GitHub? [pi ..

1 year

Post reply Unreadable titles in tabs

Hi, I suffer from the same problem: garbled tab labels [pic] [pic] I am on Linux - PopOS! 22.04, using SiYuan 2.11.3, my laptop has an integrated GPU.

1 year

Follow user zuoqiu

1 year

Post reply Parameterized queries

Hi, Tagging @zuoqiu as well (author of widget-query?). Reading [url] and exploring the Refs table ([url]😉 ), I have come up with the following SQL query SELECT ..

1 year

Thank reply Parameterized queries

You can use the Query Widget which will automatically bring out the path [pic] [pic] [pic]

1 year

Post reply Parameterized queries

Hi again, I am wondering if using Javascript in the embed block could help here. Because I only get a partial translation and I don't know JS, I don't follow mu ..

1 year

Follow user frostime

1 year

Follow user 88250

1 year

Post reply Parameterized queries

Dear @ciwoyipang, thank you so much for making me aware of the query widget. It is a very featureful extension. But I think I did not describe my need clearly. ..

1 year

Post article Parameterized queries

Hello, I would like to be able to use an attribute of the parent block when writing an SQL query in an embed block. For the sake of example, consider I am in th ..

1 year