• Blog
  • Docs
  • Pricing
  • We’re hiring!
Log inSign up
balloon

balloon

statusAutoMente

Periodically delete extraneous SQLite data generated by status
Public
Like
statusAutoMente
Home
Code
2
README.md
C
main.tsx
Branches
1
Pull requests
Remixes
History
Environment variables
Val Town is a collaborative website to build and scale JavaScript apps.
Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.
Sign up now
Code
/
README.md
Code
/
README.md
Search
7/12/2025
Viewing readonly version of main branch: v23
View latest version
README.md

Status Mente

For the free plan, SQLite has a capacity of 10MB.
Therefore, you need to work on the deletion of unwanted data on a regular basis.
This Val deletes SQLite data that is never used by the Status Val.


Setting

Change the '-3 days' in main.tsx according to the cron interval.

  • 15 minutes: -3 days
  • 30 minutes: -6 days
  • 1 hour: -12 days
  • 3 hours: -36 days
  • 6 hours: -72 days
  • 12 hours: -144 days
  • 24 hours: -288 days

status (HTTP trigger) defaults to limit 200, so it doesn't make sense to have more rows than this.
Therefore, you can remove the extra number of rows.
But taking into account the time zone, this Val leaves a little more.


Check

Enter the following SQL command from SQLite Management and check that there is no output (Default: Every 15 minutes):

select * from uptime where timestamp < datetime('now', '-3 days');
FeaturesVersion controlCode intelligenceCLIMCP
Use cases
TeamsAI agentsSlackGTM
DocsShowcaseTemplatesNewestTrendingAPI examplesNPM packages
PricingNewsletterBlogAboutCareers
We’re hiring!
Brandhi@val.townStatus
X (Twitter)
Discord community
GitHub discussions
YouTube channel
Bluesky
Open Source Pledge
Terms of usePrivacy policyAbuse contact
© 2026 Val Town, Inc.