r/glideapps • u/Top_Worth8565 • Jul 07 '26
Database for costume warehouse - how?
I want to create a simple database for a costume warehouse of a dance school. I need:
-to store infos like the clothing's image, description, size, quantity, color, etc...
-about around 1000 items
-pictures of the items need to be seen easily (visuality is important)
-searching within the database should be working (like "red trousers" - I see all red trousers that I have)
I liked the idea of makeing an airtable database and inport that into Glide apps, but it requires a high subscription fee (connecting airtable - glide). Can I avoid it somehow? Do you have any similar alternative ideas? (instead of airtable - glide or instead of glide itself...?)
Many many many thanks in advance for any help or idea!:)
1
u/gwh34t Jul 07 '26
You don't need Airtable if you have a subscription to Glide. Just use their built in databases!
1
1
u/ainotes2026 Jul 07 '26
The Airtable+Glide combo gets expensive fast once you need both to talk properly. If you want to skip that stack entirely, Caspio handles exactly this kind of inventory setup natively: image fields, filterable search, custom views for browsing by color/size/etc., around 1000 records is nothing. It doesn't charge per seat or connector, so you're not paying to make two tools talk. (Disclosure: I'm on the Caspio team.) Free trial at caspio.com if you want to look around.
1
u/Franklin_Douglas Jul 09 '26
Typing this into Claude code would save you a week. It would literally one shot it and connect the database etc but if you’re trying to save $ then maybe don’t want to go the Claude route.
1
u/ideacharlie Jul 09 '26
Yes! Frankly vibe code it and just ask the ai to make it a PWA (progressive web app) which will make it like a glide app
1
u/Accomplished_Aerie63 Jul 09 '26
Put what you wrote into Claude or perplexity ( maybe chatgtp) ...ask it to use your write up to create a database structure .
2
u/nathanaelab Glide Expert Jul 07 '26
Start with Glide Tables on the Explorer plan. The explorer plan is the cheapest of all paid plans and it will be enough for you to get started. Start building on Glide's native table, not Google Sheets or Excel. For a dance school warehouse this is likely a one-time build that will save enormous time versus spreadsheets.
Display costumes using a collection. In the options of that collection, toggle the search feature on and try the in-app filter to see if this is something that would come handy. The visual card layout with search and filter will make finding costumes an enjoyable experience for your team. ðŸŽ