Technical Blog
Deep dives, technical guides, and architectural documentation covering full-stack development, PostgreSQL database management, Linux infrastructure, and enterprise SaaS implementation.
The configure/customize/custom-module decision framework, version discipline, dev/staging/production pipeline, and the Bangladesh business context, using two fictional companies as the running case study.
A realistic hospital implementation — base module mapping, two custom modules (Clinical Management and Laboratory), pharmacy and lab workflows, billing, and Bangladesh VAT configuration considerations.
Property/Project Management and Sales & Installment custom modules, Construction Management, BOQ cost control, apartment sales accounting, and Bangladesh VAT considerations.
How the hospital and real estate custom modules actually get built, tested, and deployed — custom app structure, security, Redis, Nginx, CI/CD, backups, monitoring, and the series wrap-up.
How Frappe, ERPNext, DocTypes, and MariaDB fit together — installation, production deployment, modules, database architecture, permissions, customization, and building a custom Frappe app.
How ERPNext resolves who can do what: user types, roles, role permissions, user permissions, document sharing, and workflow-state permissions, with a tour of the Desk UI.
A module-by-module tour — Accounting, Selling, Buying, Stock, Manufacturing, CRM, Projects, HR & Payroll, Assets, Quality, and Support — with master data, document flow, and impact for each.
How DocTypes become MariaDB tables — master vs transaction vs child tables, naming conventions, Link/Dynamic Link fields, and the ER relationships behind Customer, Item, and Accounting data.
What actually happens under the hood when a transaction posts: GL Entry generation, Stock Ledger Entry updates, the document lifecycle, and how every module connects internally and externally.
The no-code-to-code customization ladder — Custom Field, Client/Server Script, Workflow, Print Format, Report Builder, and Web Form — with a decision tree for choosing the right tool.
Scaffolding a custom Frappe app, hooks and doc events, creating custom DocTypes, and integrating a new module into ERPNext's UI, data, and business logic without touching core.
Connecting an external app to ERPNext over the REST API, securing it in production, backup/recovery strategy, and a practical symptom-to-solution troubleshooting reference.
The final project — a full custom Lab Management app built as a proper Frappe app, integrated into ERPNext's UI, database, and accounting — plus the complete series wrap-up.
A 15-level, 35-phase curriculum blueprint — from absolute-beginner bookkeeping to SAP/Odoo-style ERP accounting architecture — built around one running case study, ABC Trading Ltd.
Entity relationship maps, workflow & activity diagrams, a settlement decision flowchart, and a scenario playbook running a ৳1,000 invoice through 40+ real-world conditions — partial payments, overpayments, credit notes, write-offs, and reversals.
A production guide on implementing robust PostgreSQL backup strategies using Write-Ahead Logging (WAL), setting up primary/standby servers, and ensuring zero data loss.
Complete guide from zero to production: PostgreSQL clusters, replication, read/write splitting, pgBouncer connection pooling, Redis caching, and Nginx for millions of requests.
Understanding configuration commands, data type conversions, set-returning functions, and JSONB operators to dramatically improve application performance and backend code clarity.
Complete end-to-end procurement workflow from Product Request (PR) to PO to GRN to payment. A detailed guide to implementing efficient purchase management in enterprise ERPs.
Step-by-step guide to migrating Docker's data directory to dedicated storage mounts, resolving system partition space issues while maintaining runtime stability.
Technical details on customizing Dolibarr ERP with custom modules for histopathology, cytopathology, and automated diagnostic report generation for cancer testing.
Architecture patterns and best practices for developing enterprise-level multi-tenant SaaS school management systems using Django and Next.js.
Essential security practices for hardening Ubuntu servers in production environments, covering UFW firewalls, SSH configuration, user management, and monitoring.
Comprehensive guide to naming conventions and clean code standards across multiple languages including Python (Django), PHP (Dolibarr), and JavaScript/TypeScript.