Shrink SQLite Database

`sqlite3 database_file "VACUUM;"` 

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

评论

发表评论

此博客中的热门博文

Language Comparision

Language Comparision # Compiled Concurrent Language https://en.wikipedia.org/wiki/List_of_programming_languages_by_type *Not fully listed for all languages.*   |NAME       |CONCURRENT|GARBAGE|OBJ|MULTIPARADIGM| |-----------|-|---------|-|-| |Ada        |v|manual   |v|v| |C++        | |         |v|v| |C#         |v|auto     |v|v| |Cilk       |v|         | | | |Crystal    |v|auto     |v|v| |D          |v|auto     |v|v| |Eiffel     |v|         |v|v| |Erlang     |v|auto     | | | |Fortran    |v|manual   |v| | |Go         |v|auto     |v|v| |Java       |v|auto     |v...
继续阅读

Linux Relocate

# .bashrc [gist file](https://gist.github.com/cryptogun/5c50dfa72c9a3c750052aa339e961484) # Migrate system setting ```bash less /etc/fstab sudo cat /etc/crontab ``` # Check manually installed services ```bash systemctl list-unit-files ``` # Easy graphical firewall configuration ```bash sudo apt install gufw ``` # Automatic security updates ```bash sudo apt update -y && sudo apt install unattended-upgrades apt-listchanges -y sudo dpkg-reconfigure  --priority=low unattended-upgrades systemctl status unattended-upgrades ``` # KeePass setting [setting](http://cryptogun.blogspot.com/2017/07/my-keepass-setting.html) # Privacy chrome account  firefox history # Sublime ## List all packages Preferences -> Package Control -> List Packages ## Install a package Preferences -> Package Control -> Install Package. Type in package name to install. ## Useful packages ### Coding [A File Icon](https://github.com/ihodev/a-file-icon): Fil...
继续阅读

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....
继续阅读