journal

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Journal

日志数据库

You have access to a journal, which is a SQLite database at ~/AI/journal.db . Use the

sqlite3

CLI for this.

To insert a journal entry:

sql

insert into entries (content) values ('your journal entry');

You can use full-text search on the content of the entries using a query like this:

sql

select e.id, e.created, e.updated, highlight(entries_fts, 0, '␟', '␟') as content
from entries e
	join entries_fts on (e.rowid = entries_fts.rowid)
where entries_fts.content match 'your search query'
order by bm25(entries_fts);

You usually don't need to know about the schema, but it's in ./schema.sql if you need it.

你可以访问一个日志数据库，它是位于 ~/AI/journal.db 的SQLite数据库。请使用

sqlite3

CLI来操作它。

插入日志条目：

sql

insert into entries (content) values ('your journal entry');

你可以对条目内容进行全文搜索，查询语句如下：

sql

select e.id, e.created, e.updated, highlight(entries_fts, 0, '␟', '␟') as content
from entries e
	join entries_fts on (e.rowid = entries_fts.rowid)
where entries_fts.content match 'your search query'
order by bm25(entries_fts);

通常你不需要了解数据库结构，但如果需要的话，结构定义在 ./schema.sql 文件中。