Km.Van kmvan

docker run -d \
  --name postgres-zhparser \
  -p 5432:5432 \
  -e POSTGRES_PASSWORD=your_password \
  ghcr.io/mnixry/postgres-zhparser:18
  
  
docker exec -it postgres-zhparser psql -U postgres

sudo install -d /usr/share/postgresql-common/pgdg-key.d
sudo curl -o /usr/share/postgresql-common/pgdg-key.d/pgdg-key.asc https://www.postgresql.org/media/keys/ACCC4CF8.asc
sudo sh -c 'echo "deb [signed-by=/usr/share/postgresql-common/pgdg-key.d/pgdg-key.asc] https://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list'
sudo apt update
sudo apt install -y postgresql-18 postgresql-contrib-18

Installing Google Chrome via APT

Note: This is an updated installation method for Google Chrome, as the previous apt-get approach has been deprecated. Note: sh file is attached.

1. Set Up the Google Signing Key and Repository

Add Google’s public signing key and set up the APT repository for Google Chrome:

curl -fsSL https://dl.google.com/linux/linux_signing_key.pub | sudo gpg --dearmor -o /usr/share/keyrings/google-chrome.gpg

cd /etc/pure-ftpd/auth/
ln -s ../conf/PureDB 50PureDB
ls -l

# check
# 50PureDB -> ../conf/PureDB
# 65unix -> ../conf/UnixAuthentication
# 70pam -> ../conf/PAMAuthentication

	./configure --prefix=/usr/local
	make && make install

	mv /usr/bin/sqlite3 /usr/bin/sqlite3_old
	ln -s /usr/local/bin/sqlite3 /usr/bin/sqlite3

	echo "/usr/local/lib" > /etc/ld.so.conf.d/sqlite3.conf
	ldconfig

	Mroonga 的原理
	Mroonga 實際上是一個 MySQL 系的關係型 SQL 中的外挂，但又與一般的 Plugin 有所區別。Mroonga 實際上在 MySQL 中會被當作一個存儲引擎所被 SQL 辨識。然而實際上 Mroonga 其實只是一個中間件，他的核心帶了一個完整的 Groonga。與 SphinxSearch 的 MySQL 外挂 SphinxSE 作爲一個中間件的原理類似，但又與 SphinxSE 不同的是 Mroonga 中已經自帶了 Groonga，所以並不需要像使用了 SphinxSE 后還需安裝一個 SphinxSearch 本體程式。不管是 SphinxSE 還是 Mroonga，兩者實現原理基本是一致的。

	雖説 Mroonga 也算是 SphinxSearch 師門中的一個弟子，但在實際使用過程中就能發現，Mroonga 算是洗心革面重新做了人，與祖師 SphinxSearch 徹底不同的是，使用的作業指令與 MySQL 保持了最大的相容，基本可以説是 MySQL 的 FullText 全文搜尋指令如何寫，Mroonga 就如何寫，格式可以説是一模一樣。反觀 SphinxSearch，正宗俄國血統，作業指令基本就突出了一個暴力美學，與正常的 SQL 指令相差非常大。

	Mroonga 的使用限制
	Mroonga 的使用限制其實是源自 Groonga 的内部限制。

	表（table）的限制：

	#!/bin/bash

	# FROM https://askubuntu.com/questions/1042436/how-to-install-delegate-libraries-for-image-magick-7-0-7

	# install deps
	sudo apt install chrpath debhelper dh-exec dpkg-dev g++ ghostscript gsfonts libbz2-dev \
	libdjvulibre-dev libexif-dev libfftw3-dev libfontconfig1-dev libfreetype6-dev \
	libjpeg-dev liblcms2-dev liblqr-1-0-dev libltdl-dev liblzma-dev libopenexr-dev \
	libpango1.0-dev libperl-dev libpng-dev librsvg2-bin librsvg2-dev libtiff-dev libwebp-dev \
	libwmf-dev libx11-dev libxext-dev libxml2-dev libxt-dev pkg-config pkg-kde-tools zlib1g-dev

	sudo apt install zsh

	sh -c "$(curl -fsSL https://raw.githubusercontent.com/ohmyzsh/ohmyzsh/master/tools/install.sh)"

	git clone https://github.com/zsh-users/zsh-autosuggestions ~/.oh-my-zsh/custom/plugins/zsh-autosuggestions

	git clone https://github.com/zsh-users/zsh-syntax-highlighting.git ${ZSH_CUSTOM:-~/.oh-my-zsh/custom}/plugins/zsh-syntax-highlighting

	# add zsh-autosuggestions to ~/.zshrc
	# plugins=(git zsh-autosuggestions)

	sudo apt install fcitx5-chinese-addons-bin fcitx5-chinese-addons-data fcitx5-chinese-addons \
	fcitx5-config-qt fcitx5-data fcitx5-frontend-all fcitx5-frontend-gtk3 fcitx5-frontend-gtk4 \
	fcitx5-frontend-qt5 fcitx5-frontend-qt6 fcitx5-pinyin