asopi tech
asopi techIndie Developer

Git / Blog evidence

About AsopiTech

AsopiTech is a public software product R&D studio. We publish new software designs as code, data, comparisons, and articles, then grow them into open-source projects and products. Akari Takamine guides from the market side; Asmati Tatsumi explains from the technical side.

Profile

Profile

Over 20 years of software development experience

With over 20 years in software development, I have hands-on experience spanning cloud infrastructure, frontend technologies, blockchain, and AI.

  • Development experience with Java / C# / Python / Go / TypeScript
  • Production experience with Kubernetes / Docker / k3s / GKE
  • Frontend development with TypeScript / Angular / React / Astro
  • Blockchain development with Hyperledger Fabric / Indy
  • Cloud infrastructure on AWS / GCP / Azure
  • AI utilization with ChatGPT / Auto-GPT / Stable Diffusion
  • IoT projects with Raspberry Pi / M5Stack
  • OSS product development in Rust / Nim (Alopex DB, Nimino / Nimculus)

Media

Blog Posts

Technical notes and development logs

All posts
  • Blog

    Recursive CTEs in Alopex DB: Comparing the Implementation with PostgreSQL, SQLite, and DataFusion

    How does WITH RECURSIVE iterate, and where does it stop? This article reads the Alopex DB implementation alongside PostgreSQL, SQLite, and DataFusion.

    Read post
  • Blog

    Alopex DB v0.8.16: Performance Compared with Other Products

    A fixed-case performance comparison of Alopex DB v0.8.16 DataFrame, SQL, KV, and HNSW operations against Polars, SQLite, PostgreSQL, DataFusion, LMDB, hnswlib, and Faiss HNSW.

    Read post
  • Blog

    Alopex DB v0.8.16 Tutorial, Part 5: Opening the Database with a Server

    Open an embedded data directory with alopex-server, run the same SQL over HTTP, and read the server-written row through the file API.

    Read post
  • Blog

    Alopex DB v0.8.16 Tutorial, Part 4: Vector Search and DataFrames

    Store embedding vectors with articles, combine similarity search with SQL filters, and reshape the results with DataFrames in Python and Rust.

    Read post
  • Blog

    Alopex DB v0.8.16 Tutorial, Part 3: CASE, Set Operations, CTEs, and Window Functions

    Use CASE expressions, UNION and other set operations, common table expressions, rankings, and running totals in Alopex DB.

    Read post
  • Blog

    Alopex DB v0.8.16 Tutorial, Part 2: Querying Articles with SQL

    Create a table and query it with SELECT, JOIN, aggregation, and subqueries, then combine SQL and key-value data in one transaction.

    Read post