Shrink SQLite Database

`sqlite3 database_file "VACUUM;"` 

[sqlite3 download link](https://sqlite.org/download.html)

评论

发表评论

此博客中的热门博文

Google Drive 代理设置

# Google Drive Proxy Settings `English keywords: Successfully synced Google Drive app with Google server by using COW app and setting up Internet Options.` 成功利用[COW](https://github.com/cyfdecyf/cow)加上设置系统代理服务器实现谷歌盘的翻墙同步，方法如下。 # 名词解释 [Google Drive Sync](https://www.google.com/drive/download/)： 这个软件只能自动检测代理。无法设置代理类型、IP、帐号、密码。 [COW](https://github.com/cyfdecyf/cow)： 一个智能中间代理。可以智能判断是否翻墙；可以聆听多个端口；可以均衡分发到多个多种类型的目标代理。 尝试的解决步骤： ## 无效 1. 无法同步。全局翻墙： ``` Google备份同步：代理设置：自动检测 Internet选项：代理服务器：localhost:1080 ShadowSocks客户端：localhost:1080 ``` ## 有效 1. 可同步。COW代理于80端口和8080端口： ``` Google备份同步：代理设置：自动检测 Internet选项：代理服务器：localhost:80 COW：         listen = http://127.0.0.1:80         listen = http://127.0.0.1:8080         proxy = http://127.0.0.1:1080 ShadowSocks客户端：localhost:1080 ``` 2. 可同步。COW代理于8080端口： ``` Google备份同步：代理设置：自动检测 Internet选项：代理服务器：localhost:8080 COW：         listen = http://127.0....
继续阅读

How to Install KeePass on M1 Mac

图片
KeePass is good at syncing (via FTP or DAV). I missed that functionality on Windows. Here's how I install and use KeePass on MacOS: ## Install wine-crossover ```bash brew tap gcenx/wine brew install --cask --no-quarantine wine-crossover ``` ## Install winetricks ```bash brew install winetricks ``` ## Install .NET ```bash winetricks -q dotnet472 ``` ## Install mono ref: [StackOverflow](https://askubuntu.com/questions/644236/mono-does-not-appear-to-be-installed-error-winetricks) 1. Download [wine-mono.msi](http://dl.winehq.org/wine/wine-mono) from the official winehq site. 1. Run `wine64 uninstaller` 1. A window should popup. Inside the window choose the `mono.msi` file you just downloaded, and then click `install` ## Install clipboard dependences ```bash brew install xsel brew install xdotool ``` ## Install KeePass.zip Please download the exact KeePass version that you used on Windows. Or you may encounter the error `keepass failed to load the specified file the master key is invali...
继续阅读

How User Friendly is a MacOS

From a Windows user point of view, MacOS is differ for the purpose of difference only. Intuition doesn't work in the Mac universe. ```txt macbook hide safari macbook hide safari from dock macos latest version macbook check cpu macbook check cpu usage macbook chrome shortcut to find KeePass alternative Cannot Be Opened Because the Developer Cannot be Verified where is the macbook file explorer macbook stop changing screen temperature macbook stop changing screen color to blue how do I browse my file system on a mac 2021 pin hard drive to docker macbook 2021 pin hard drive to hub macbook what is super key mac sublime mac auto save sublime mac closed without ask me to save hot_exit not working on macbook (depending on close by x v.s. exit completely from docker) Preserve unsaved files macbook Sublime Text 3 keep unsaved files macbook Sublime Text 3 why macbook so antihuman why macbook so against human why macos so not user friendly macbook how to add hard drive to dock macbook how to ...
继续阅读