~/tags/sqlite

SQLite

$ cat ~/tags/sqlite — 3 entries

~/work ×1

Automated AI Inventory Forecasting: Python & Prophet

Built an ETL and forecasting pipeline using Python, SQLite, and Meta's Prophet AI to automate replenishment for ~7,800 SKUs. Reduced the supply chain planning cycle from days to hours.

7,800 SKUs automated

Read case study

~/blog ×2

Jul 29, 2026 | Data Engineering |4 min read

Tally Prime XML to SQLite ETL Cookbook

The unglamorous plumbing behind the 18h-to-4h forecasting win: streaming a 1.8 GB Tally Prime XML export with lxml iterparse, surviving mixed encodings and damaged nodes, into an indexed SQLite frame.

Mar 30, 2025 | Data Engineering |7 min read

AI Inventory Forecasting: From 18 Hours to 4 Hours

How I replaced a crashing Excel-based inventory planning process for 7,800+ SKUs with a Python multiprocessing pipeline using Meta's Prophet AI — cutting weekly planning time from 18 hours to 4 hours overnight.