running out of space on my 48MB free sql server db. any chance i could keep my hobby proj forever free, or scale up for less than $5/month (basic tier)
there's a small project i made during my programming classes, and i've been using it for the last ~8y running on the free webapp/db tier.
but last year i've opened it up for other people to use, and now the db is slowly running out of storage... the web app is very niche and up to 5 users might visit it per day (total of ~200 users in db).
any ideas what i could do to keep the db forever free, or find a cheaper alternative? just 100MB would keep it runnng for years. i've seen the pricing on aws, which is even worse than Azure Basic tier (12m free, $20/month later for the cheapest tier).
i'd appreciate any advice, thanks
upd:
thanks to u/NastyEbilPiwate i freed up 10mb. turns out my tables were only 1.77mb in size, everything else was consumed by azure metadata, and the query store - which was the largest one that i cleared up and turned off. so i'll stick with my 48mb plan for now.
if it wouldn't work - i would've tried u/irisos suggestion and creating a new db under another free tier that allows to have 100,000 vcore/s per month. with autopause it would've been a lifetime free working solution: https://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql