faywong faywong

四步

换上向量数据库： https://github.com/asg017/sqlite-vec?tab=readme-ov-file
基于 llama 的文本嵌入模型：https://github.com/asg017/sqlite-lembed
再把这几个整在一起，跑通一个 RAG 查询：https://alexgarcia.xyz/blog/2024/sqlite-vec-stable-release/index.html
规模化：改造现有数据本地查询，{table} => 平行创建一个 {table-vec} 表。将原有查询升级到 RAG 查询。

性能

export OHOS_SDK=/Users/faywong/Library/Huawei/Sdk/HarmonyOS-NEXT-DP1 cmake -DOHOS_STL=c++_shared -DOHOS_ARCH=armeabi-v7a -DOHOS_PLATFORM=OHOS -DCMAKE_TOOLCHAIN_FILE=${OHOS_SDK}/base/native/build/cmake/ohos.toolchain.cmake -DCMAKE_EXPORT_COMPILE_COMMANDS=1

抱歉，本文在 Gentoo Linux Rime 输入法下写成，由于缺乏敏捷的截图工具，本文图片较少（UML 图后期再补）。

基础

术语

schema -> 输入法方案，比如朙月拼音、倉頡五代，其 schema id 分别为：luna_pinyin、cangjie5
compose -> 选词组句

environment setup

amalg - merge several lua scripts into standalone one net-url - url parser luash - invoke sh commands from lua

brew install --use-clang luarocks
luarocks install --server=http://luarocks.org/dev amalg net-url luash

	#!/bin/sh
	#file: /usr/bin/dis
	#disassemble a function
	#author: sid

	export PATH=/Users/faywong/Library/Android/sdk/ndk/21.1.6352462/toolchains/aarch64-linux-android-4.9/prebuilt/darwin-x86_64/bin:$PATH
	routine=$1
	func=$2

	if [ -z "$routine" ]; then

	#!/usr/bin/python3
	import os
	import glob

	# 使用 glob 模块搜索所有 .gif 文件
	gif_files = glob.glob(os.path.join('in', '*', '.gif'), recursive=True)

	def ensure_dir(file_path):
	# 获取文件路径的目录部分
	directory = os.path.dirname(file_path)

	# 前置条件: cp -rf /opt/maca .; cp -rf test_milvus .; cp milvus-2.3.13-py3-none-manylinux2014_x86_64.whl .
	FROM ubuntu:20.04

	# 将本地的 milvus-2.3.13-py3-none-manylinux2014_x86_64.whl 文件复制到镜像的 /tmp/ 目录下
	COPY milvus-2.3.13-py3-none-manylinux2014_x86_64.whl /tmp/
	COPY example.py /tmp/
	COPY test_milvus /tmp/test_milvus
	RUN mkdir -p /opt
	COPY maca /opt/maca
	# 创建一个新用户并将其添加到video组中

	# docker buildx build . -t sid/android_ci
	# docker push registry.gitlab.com/szndev/ci-droid
	FROM --platform=linux/amd64 openjdk:17-slim

	ENV ANDROID_SDK_TOOLS 9477386
	ENV ANDROID_SDK_URL https://dl.google.com/android/repository/commandlinetools-linux-${ANDROID_SDK_TOOLS}_latest.zip
	ENV ANDROID_BUILD_TOOLS_VERSION 33.0.0
	ENV NDK_VERSION 25.2.9519653
	ENV ANDROID_HOME /usr/local/android-sdk-linux
	ENV ANDROID_VERSION 33

	#!/bin/bash -e

	# Copyright (c) 2012 The Chromium Authors. All rights reserved.
	# Use of this source code is governed by a BSD-style license that can be
	# found in the LICENSE file.

	# Script to install everything needed to build chromium (well, ideally, anyway)
	# See https://chromium.googlesource.com/chromium/src/+/master/docs/linux/build_instructions.md

	usage() {

	# CLion EAP: https://www.jetbrains.com/clion/nextversion/
	# ref: https://stackoverflow.com/questions/26584948/how-do-i-remove-my-intellij-license-in-2019-3
	rm -rf Library/Application Support/JetBrains/CLion*