Skip to content

Instantly share code, notes, and snippets.

View limcheekin's full-sized avatar

Lim Chee Kin limcheekin

View GitHub Profile
@limcheekin
limcheekin / convert_wav_to_mp3.sh
Created March 31, 2025 01:53
Convert all WAV files in the current directory and its subdirectories to MP3 using ffmpeg
find . -name "*.wav" -exec ffmpeg -i {} {}.mp3 \;
@limcheekin
limcheekin / improved_system_prompt.md
Last active December 28, 2025 10:48
System Prompt for Gemini Pro 2.5 - TDD-Focused Code Quality Agent

I'll analyze the system prompt and improve it to focus on what to achieve rather than how to achieve it.

# Expert Code Quality and Refactoring Agent

You are an advanced AI assistant specializing in comprehensive code quality analysis and test-driven refactoring for large, complex codebases.

## Core Capabilities

- Analyze entire codebases across multiple files, modules, and components
@limcheekin
limcheekin / build.sh
Created March 24, 2025 10:06
Build llama.cpp with OpenCL
cmake -B build -DBUILD_SHARED_LIBS=OFF -DGGML_OPENCL=ON
cmake --build build --config Release
@limcheekin
limcheekin / connection-url.txt
Created March 23, 2025 07:55
Open WebUI setup
POSTGRES_DSN="postgresql+asyncpg://postgres:[email protected]:5432/open_webui"
@limcheekin
limcheekin / telegram-bot-chat-ui.md
Created February 28, 2025 12:06
telegram-bot-chat-ui

Create a Telegram Bot for OpenAI API which storing chat history in the PostgreSQL. Give the user option to retrieve the past conversations and select one to continue or resume the conversation. Please implement the application using the following python packages:

  • python-telegram-bot
  • SQLAlchemy
  • asyncpg
  • pytest
  • pytest-asyncio
  • aiosqlite

Please make sure all codes written with comprehensive test coverage.

@limcheekin
limcheekin / git-clone-no-lfs.sh
Created February 25, 2025 07:59
git clone without LFS
GIT_LFS_SKIP_SMUDGE=1 git clone --depth=1 SERVER-REPOSITORY
@limcheekin
limcheekin / gitingest.sh
Created January 24, 2025 23:22
gitingest usage
# gitingest --help
# Usage: gitingest [OPTIONS] SOURCE
# Analyze a directory and create a text dump of its contents.
# Options:
# -o, --output TEXT Output file path (default: <repo_name>.txt in
# current directory)
# -s, --max-size INTEGER Maximum file size to process in bytes
# -e, --exclude-pattern TEXT Patterns to exclude
@limcheekin
limcheekin / Bookcast AI Podcast References.md
Last active January 24, 2025 03:24
Bookcast AI Podcast References
  • Podcastfy: For seamlessly generating the podcast content and making the production process effortless.
  • LocalAI: For providing an OpenAI-compatible API, powering the transcript and audio generation with unmatched efficiency.
  • LLM Model: For its exceptional capabilities in generating accurate and insightful transcripts.
  • Kokoro-FastAPI: For creating high-quality audio and bringing the words to life.
  • Google Slides: For enabling the design of captivating video covers that define the channel’s visual identity.
  • Music For Makers: For providing the inspiring podcast music "Clarity", which has become a signature of our content.
  • Wavbreaker: For precisely splitting the first five seconds of music,
@limcheekin
limcheekin / QRCodeUtility.html
Created January 8, 2025 06:30
Generating a QR-Code with just HTML
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width,initial-scale=1,user-scalable=no">
<title>QR Code Generator & Reader</title>
<script type="text/javascript">
var QRCode;
!function() {
function t(e) {
@limcheekin
limcheekin / SimGRAG_vs_KAG_vs_LightRAG.md
Created January 1, 2025 12:38
SimGRAG vs KAG vs LightRAG
Aspect SimGRAG KAG (Knowledge Augmented Generation) LightRAG
Core Objective Align query texts with knowledge graph (KG) structures for retrieval-augmented generation (RAG). Enhance LLMs in professional domains by integrating KGs and vector retrieval. Improve RAG systems by incorporating graph structures for efficient and context-aware retrieval.
Key Features - Query-to-pattern and pattern-to-subgraph