Blog
Writing on AI, ERP and building intelligent systems.
Notes on artificial intelligence, machine learning, ERPNext & Frappe development, data analytics and the craft of enterprise software.

Getting Started with ERPNext Customization
A practical introduction to customizing ERPNext on the Frappe Framework — custom DocTypes, server scripts, and print formats.

Optimizing SQL Queries for Faster Data Retrieval
Learn essential SQL optimization techniques to dramatically improve query performance and reduce data retrieval times for your applications.

Building Intelligent ERPNext Agents with LLMs
Explore how to integrate Large Language Models (LLMs) with ERPNext to create intelligent agents for automated business processes and enhanced data analysis.

Leveraging LLMs for Smarter Business Analysis
Discover how Large Language Models (LLMs) can revolutionize your business analysis, from data interpretation to strategic decision-making. Explore practical applications and future potential.
Unlocking Business Insights with ERPNext Analytics
Go beyond basic reports. Learn how to leverage ERPNext's powerful analytics tools to gain deeper insights and drive better business decisions.
Testing the New CMS Pipeline
A quick end-to-end test post to confirm the admin CMS, database, and public blog rendering all work correctly together.

Prompt Engineering for Business AI Assistants
How to design system prompts for LLM assistants that answer from a fixed knowledge base without hallucinating — lessons from building this site's own chatbot.