Engineering Blog

In-depth technical articles, system architecture deep-dives, Odoo ERP breakdowns, DevOps practices, and real lessons learned from production.

FEATURED POST // 01 • System Architecture
Feb 18, 2025 • 8 min read

Inside Our Odoo ERP 17 + SvelteKit Architecture: Real-time Sync for 100k+ Transactions Without Bottlenecks

Bridging frontend E-Commerce with enterprise ERP often leads to database row locks and desynchronized inventory during flash sales. Here is how we used Change Data Capture (CDC), Redis, and event queues to solve it in production.

Key Architectural Takeaway

Separate Read/Write paths, leverage PostgreSQL WAL-based streaming, and offload synchronous Odoo ORM mutations into async worker queues.

#Odoo ERP#SvelteKit#PostgreSQL#Redis#High Concurrency
Nat (ntdotjsx) & Auto Sirawit · Co-Founders & Principal Engineers
Technical Articles

Engineering Lessons & Notes

Frontend Engineering • Feb 10, 2025
POST // 01
6 min read
Nat (ntdotjsx)

Migrating Large Codebases to Svelte 5 Runes: 40% Less Boilerplate and Predictable Reactivity

A deep dive into $state, $derived, $effect, and universal .svelte.ts stores in high-traffic applications, with tips on avoiding cascading re-runs and memory leaks.

Key Takeaway:

Runes make reactivity explicit and fine-grained, enabling cleaner cross-component state management without legacy store stores.

#Svelte 5#TypeScript#Frontend#Reactivity
DevOps & Cloud • Jan 28, 2025
POST // 02
7 min read
Auto Sirawit

Zero-Downtime Deployments for Odoo ERP Using Docker Swarm and Traefik Reverse Proxy

How to ship continuous module updates without interrupting warehouse and retail operations, featuring automated rollback triggers on schema mismatch.

Key Takeaway:

Use rolling updates tied to live healthcheck probes and run database migrations through staging sandboxes before production switchovers.

#Docker Swarm#Odoo#Traefik#CI/CD#DevOps
System Architecture • Jan 15, 2025
POST // 03
9 min read
Engineering Team

Handling 5 Million Daily IoT Telemetry Records with TimescaleDB, MQTT, and Columnar Compression

When factory sensors push high-frequency metrics every 500ms, here is how we designed Hypertables and automated rollups to cut disk footprint by 85%.

Key Takeaway:

Utilize columnar compression and continuous aggregates to precompute analytics without taxing real-time dashboard queries.

#TimescaleDB#IoT#MQTT#PostgreSQL#Data Engineering
Odoo ERP • Jan 02, 2025
POST // 04
5 min read
Nat (ntdotjsx)

7 Common Pitfalls in Odoo Custom Module Development (and How to Fix Them)

Avoid N+1 queries in computed fields, enforce proper security access rules (ir.model.access), and write maintainable unit tests for painless major version upgrades.

Key Takeaway:

Strictly define @api.depends, avoid DB searches inside loops, and separate domain rules from web controllers.

#Odoo#Python#ORM#Best Practices#Security
Frontend Engineering • Dec 19, 2024
POST // 05
4 min read
Engineering Team

Why We Switched to Tailwind CSS v4 for All New Builds: 10x Faster and CSS-First Simplicity

Benchmarking the new Rust-based Oxide engine in Tailwind v4, leveraging native @theme variables without JS config files, and shrinking cold build times from 4.2s to 350ms.

Key Takeaway:

Native CSS Cascade Layers and CSS-first configuration drastically streamline development without extra configuration overhead.

#Tailwind CSS v4#CSS#Vite#Frontend Performance
Engineering Strategy • Dec 05, 2024
POST // 06
6 min read
Auto Sirawit

Pragmatic Automated Testing Strategy for SME Software: Maximum ROI Without Slowing Velocity

Why targeting arbitrary 100% code coverage is often counterproductive for lean teams, and how to focus integration tests on critical paths like checkout, tax calculations, and inventory deduction.

Key Takeaway:

Prioritize end-to-end integration tests on high-risk business logic with Playwright, keeping unit tests for pure deterministic functions.

#Testing#Playwright#Vitest#QA#Agile
ENGINEERING NEWSLETTER

Get Bi-Weekly Engineering Insights & Case Studies

We share real lessons from production codebases, architecture diagrams, and ERP tuning tips every two weeks. Zero spam, unsubscribe anytime.

Bi-weekly updates · 0% Spam · Unsubscribe anytime