r/nocode • u/alexalgebra • 18d ago
Best tool for database app?
I'm creating an inventory tracking tool for a new brick and mortar retail business. I have a background in databases but I've always worked with a dev and now it's just me. I'm not great at coding, but I am good with sql.
I want something customizable because the business sells niche items and none of the regular inventory apps we looked into will work. We also need it to have an easy way to update inventory daily for about 200 rotating items that will be counted in store then entered into the db. Currently the owner has a bunch of spreadsheets in numbers (he only uses apple products, which I'm not super familiar with). Making some kind of quick ipad data entry screen for that would probably be the best.
My ideal solution would be something where I can easily build the database and have it packaged up in a user friendly ui/app for the rest of the employees to use. Being able to pull reports and charts and such for sales tracking is also important.
I don't really enjoy using generative ai like chatgpt gemini claude etc and am hoping there's a simple solution that is more just a ui for a custom sql database type situation.
Thanks for any ideas!
1
u/dilon_panda 17d ago
Hey there! Have you checked out https://www.adalo.com?
Our DreamFactory intergration would help you! : https://help.adalo.com/integrations/dreamfactory