Skip to content
View ayumilove's full-sized avatar

Block or report ayumilove

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ayumilove/README.md

English | 简体中文

Hi, I'm Andy 👋

I build tools I wish already existed.

Software engineer focused on practical tools for real-world problems — especially in manufacturing, databases, automation, and AI-assisted engineering.

I enjoy turning repetitive, error-prone, or overly complicated workflows into simple tools that people can actually use.


🛠 What I Work With

Languages

Python · C# · VB.NET · PowerBuilder · Kotlin · JavaScript / TypeScript · SQL / PL/SQL

Backend & Data

Oracle · FastAPI · REST API · SOAP · Docker

Engineering

Manufacturing IT · ERP · Database Tools · Automation · Data Processing

AI

LLM · Multimodal AI · Computer Vision · Document Analysis


🚀 Featured Projects

🖼️ xImageDuplicateChecker

High-performance duplicate image detection

Built for large image collections, including datasets with millions of files.

Supports multiple detection strategies:

MD5 · dHash · pHash · aHash · accelerated image comparison

Capable of detecting not only identical files, but also resized, cropped, and modified images.

Python Computer Vision Image Processing


🗄️ OracleSchemaSnapshot

Oracle schema snapshot, comparison & synchronization tool

Capture Oracle database structures, compare schemas across environments without requiring both databases to be online at the same time, and automatically generate auditable synchronization SQL.

Snapshot → Compare → Review → Generate SQL

Designed for development, production, customer environments, and other scenarios where Oracle databases may exist in isolated networks.

Python Oracle Schema Compare Database DevOps


📐 DrawingContrast

AI-assisted engineering drawing comparison

Compare two versions of engineering PDF drawings and automatically identify changes in:

  • dimensions
  • annotations
  • geometry
  • engineering information

Combines traditional computer vision with multimodal AI to understand not only where something changed, but also what changed.

Python OpenCV PDF Multimodal AI Engineering


🧹 OracleArchiveManager

Safe historical data archiving for large Oracle tables

A controlled workflow for archiving large Oracle tables:

Analyze → Copy → Verify → Human Approval → Cleanup

Designed with safety in mind — destructive operations require explicit confirmation, with audit logging throughout the process.

Python Oracle 11g+ Data Archiving Database Maintenance


📺 DataVision

Turn an Android TV into a dedicated data dashboard

A lightweight solution for using Android TVs as reliable fullscreen information displays.

Includes kiosk mode, network recovery, 4K DPI handling, and automatic updates.

Kotlin Android TV Digital Signage


💡 How I Build

I prefer software that solves an actual problem.

Many of my projects start with something simple:

“Why am I still doing this manually?”

or

“Why doesn't a simple tool for this already exist?”

Then I build one.

My projects tend to focus on:

  • 🏭 Manufacturing & ERP workflows
  • 🗄️ Oracle database engineering
  • ⚙️ Automation and productivity tools
  • 📊 Data processing and visualization
  • 🤖 Practical applications of AI
  • 🧰 Small tools that remove big annoyances

🌱 Open Source

I open-source tools when I think they may solve the same problem for someone else.

Some projects come directly from real engineering challenges; others simply started because I wanted a better tool than the ones available.

Not everything needs to become a product.

Sometimes a useful tool is enough.


Thanks for stopping by 👋

If one of my projects saves you some time, solves a problem, or gives you an idea for your own project, then it has done its job.

If you find something useful, feel free to explore, fork, or leave a ⭐.

Pinned Loading

  1. xImageDuplicateChecker xImageDuplicateChecker Public

    高效的Python图像查重工具,支持百万级图片文件的重复检测。集成多种算法包括MD5哈希、感知哈希(dHash/pHash/aHash)和C++加速库,可识别完全相同、分辨率调整、部分截取和水印变更的重复图像。

    Python 8 1

  2. OracleSchemaSnapshot OracleSchemaSnapshot Public

    Oracle 数据库结构快照与差异同步工具:跨环境采集 Schema、离线对比差异、一键生成可审计的升级 SQL。带 GUI、Excel 报告、自动更新,DBA 发布变更的瑞士军刀。

    Python

  3. DrawingContrast DrawingContrast Public

    工程图纸智能差异分析工具:选定两版 PDF 图纸一键比对,自动识别尺寸/标注/几何变更并生成分类变更清单,支持多模态 AI 语义解读与交互式差异可视化,单文件 EXE 开箱即用。

    Python 1

  4. DataVision DataVision Public

    DataVision turns any Android TV into a dedicated data dashboard display. Fullscreen kiosk mode, network auto-recovery, 4K DPI fix, and built-in auto-update. Based on TV Bro.

    Kotlin 1

  5. OracleArchiveManager OracleArchiveManager Public

    面向 Oracle 数据库的大表历史数据归档与安全清理工具(Oracle 11g+):分析 → 复制 → 校验 → 人工确认 → 清理,全链路审计留痕。复制自动执行,删除必须显式确认。

    Python