Abdulfatai
@abdulfatai
journal
Your Database Should Not Be Your Application’s Trash Can
1 reply 7 views
Your Database Should Not Be Your Application’s Trash Can
When building an application, it’s easy to keep adding data to the database because “we might need it later.”
But storing everything can create problems.
For example, imagine your users table contains:
Old temporary tokens
Expired sessions
Unused fields
Duplicate records
* Data you no longer need
Over time, your database becomes harder to maintain and query.
A better approach is to regularly ask:
“Do we actually need to store this?”
If the answer is no, don’t store it just because you can.
And if data is temporary, consider whether it belongs in something like Redis, a cache, or another short-lived storage mechanism instead of your main database.
Good database design isn’t only about knowing how to store data.
It’s also knowing what should not be stored in the first place.
What’s one piece of data you’ve stored in a project and later realized you didn’t actually need?
View passport