The Changelog: Software Development, Open Source Avoiding the soft delete anti-pattern (News)
May 13, 2024
Tim Fisken dives into the pitfalls of soft deletion in databases and offers alternatives for better data management. The discussion on 'lib years' sheds light on software dependency freshness, helping developers make informed choices. Sound design’s impact on software is highlighted, along with a special workshop by Supabase and Sentry. Additionally, programming mantras are explored as reflective proverbs that guide development decisions, emphasizing their philosophical value.
AI Snips
Chapters
Transcript
Episode notes
Avoiding Soft Deletion
- Avoid the soft delete anti-pattern, as it misleads the database.
- Consider alternatives like hard deletion, lifecycle with archive states, temporal tables, or a data warehouse.
Libyear for Dependency Freshness
- Libyear is a simple measure of software dependency freshness.
- Calculate it by adding up the lib years of all dependencies, indicating how outdated they are.
Sound Design in Software
- Consider sound design in software, as it's often overlooked but impactful.
- Sound can elevate user experience, even in mundane applications.