Heap Table

Discourse context A heap is a table without a clustered index. One or more nonclustered indexes can be created on tables stored as a heap. Data is stored in the heap without specifying an order. Usually data is initially stored in the order in which is the rows are inserted into the table, but the Database Engine can move data around in the heap to store the rows efficiently; so...

February 10, 2023 381 words 1 min

Clustered Indexes / Index Organized Tables (IOT)

Some databases can indeed use an index as primary table store. The Oracle database calls this concept index-organized tables (IOT), other databases use the term clustered index. In this section, both terms are used to either put the emphasis on the table or the index characteristics as needed. An index-organized table is thus a B-tree index without a heap table. This results in two benefits: (1) it saves the space...

February 10, 2023 580 words 2 min

Lucius's Workflow

Figure 1: workflow 如上图所示,融合了笔记和 GTD 管理。 GTD Capture To-Dos 分为的来源分为六种: Habit Track: 即对于重复事件的循环,有利于习惯的养成。 Cyclic Tasks: 需要循环的任务。 生日提醒 周报...

February 10, 2023 1774 words 4 min

Excalidraw

在 Obsidian 中可以通过 command palette 中搜索 Insert LaTeX formula 就可以弹出弹框输入 \(\textsc{LaTeX}\) 表达式了。其中的 \color{} 可以指定生成文本的颜色。

February 10, 2023 46 words 1 min

JavaScript Refactoring

Refactoring Tips Refactoring Condition statements Converting callbacks to promises Refactoring Promise chains with async/await Refactoring Code examples Callback Hell

February 10, 2023 19 words 1 min

Beancount

precision Beancount 会统计写过的每个货币的金额,然后选择最常见的作为显示格式,如果大多数时候都是整数,它就会用整数显示,所以最好尽量都写成你想要看到的精度,...

February 10, 2023 106 words 1 min

Karabiner-Elements

平时是使用苹果内置键盘以及 HHKB,因为键位有一些不同,设置上也会有一些区别。 Figure 1: Karabiner-Elements --- global: check_for_updates_on_startup: true show_in_menu_bar: true show_profile_name_in_menu_bar: true profiles: - complex_modifications: parameters: basic.simultaneous_threshold_milliseconds: 50 basic.to_delayed_action_delay_milliseconds: 500 basic.to_if_alone_timeout_milliseconds: 1000 basic.to_if_held_down_threshold_milliseconds: 500 mouse_motion_to_scroll.speed: 100 rules: - description: Change tab to...

February 10, 2023 917 words 2 min

Anki

Online Dictionary Helper Figure 1: online-dictionary-helper-result Chrome extension 在线词典助手 Settings Figure 2: online-dictionary-helper-setting Anki Template 模板的样式是根据卡片内容来设置的,其中 glossary 中本身就带了样式。 front <div class="section"> <div id="front" class="items"> {{expression}}<span class="audio">{{audio}}</span> </div> {{#reading}} <hr /> <div id="front-extra1" class="items"> <span>{{reading}}&nbsp;</span> <span>{{extrainfo}}</span> </div> {{/reading}} </div> back...

February 10, 2023 233 words 1 min

Terminal

Starship brew install starship add eval "$(starship init zsh)" to .zshrc mkdir -p ~/.config && touch ~/.config/starship.toml 默认配置 # 设置配置范例,开启编辑器的自动补全 "$schema" = 'https://starship.rs/config-schema.json' # 在命令之间插入空行 add_newline = false # ~/.config/starship.toml # A minimal left prompt format = """$character""" # move the rest of...

February 10, 2023 247 words 1 min

VSCode

Extensions ESLint Markdown All in One Markdown Preview Github MoonScript Language One Dark Pro Prettier - Code formatter Settings { "editor.fontFamily": "'Iosevka', LXGW WenKai Mono, Menlo, Monaco, 'Courier New', monospace", "editor.fontLigatures": true, "editor.fontSize": 14, "security.workspace.trust.untrustedFiles": "open", "editor.bracketPairColorization.enabled": true, "editor.renderWhitespace": "boundary", "workbench.colorCustomizations": { "editorBracketHighlight.foreground1": "#EFBB24", "editorBracketHighlight.foreground2": "#F8C3CD", "editorBracketHighlight.foreground3": "#A5DEE4", "editorBracketHighlight.foreground4": "#8A6BBE", "editorBracketHighlight.foreground5": "#90B44B", "editorBracketHighlight.foreground6": "#FFB11B", "editorBracketHighlight.unexpectedBracket.foreground": "#E83015", "tab.activeBackground": "#724832", "scrollbarSlider.background": "#91AD70", "scrollbarSlider.hoverBackground": "#91AD70", "scrollbarSlider.activeBackground": "#91AD70" }, "[javascript]": { "editor.defaultFormatter": "esbenp.prettier-vscode" }, "[html]": { "editor....

February 10, 2023 98 words 1 min