Personal inventory system
My friend want me to create a database system for his inventory system to save the products, sale, expense and loans. Now i want to create the database in drizzle orm and sqlite. I have just one question will create separate table for loan or add the isLoan column to the sale table.
5 Replies
I have a lot of questions. Out of the gate, he wants a "database" he doesn't want "a tool that helps him manage his inventory/business"?
Is he a dev? Does he know SQL? I feel like handing a business guy an ORM and say "here you go!" without any safety nets is handing him a loaded shotgun and pointing it directly at his foot.
Would a Google sheet suffice? Spreadsheets have their limitations, but they're good enough for most that are starting out, and don't require expensive dev time to maintain
I mean, there are also like... a bajllion solutions for this. Stuff like inventory is mostly a solved problem, hence me wanting more info. Odoo is the one I've heard ads for, probably way more.
a lot are open source too
Depending on your use case and how tech-oriented the friend is, you can configure any kind of Headless CMS for him as a backend or leave him with DB, or google docs. Most Headless CMS-es will have enough of a free tier to use for this kind of thing.
You could even attach a form to a spreadsheet to reduce data errors (such as Google Forms + Google Sheets). When you outgrow a spreadsheet, you can normalize and convert it to a database. I typically prefer to use the simplest and cheapest method first until I reach its limitations. 😉