Urgent.News

What's breaking now, across thousands of outlets.

Tech

Filtered should never mean deleted

We shipped a filter that threw away bad GPS readings. Months later somebody asked whether it was working, and I could not answer. The evidence was gone. That question changed how I build anything that rejects data. The obvious version, and why it rots Mileage tracking depends on trustworthy distance, and GPS lies constantly. So the first version of our cleanup did what everyone's first version…

A filter was added to discard faulty GPS data, but the decision to delete it meant the data was gone forever. Past mistakes prompted a redesign where rejections became labeled instead of deleted. Only two cases are still removed: impossible coordinates and impractical accuracy. All other data is kept and categorized into different groups based on the reason for rejection.

This approach allows for tracking the reasons behind filtering, enabling easier dispute resolution and threshold adjustments. By retaining the rejected data, it's possible to verify the accuracy of the filtering process and make necessary changes. The key takeaway is that filtering should never result in permanent deletion of data, as it hinders the ability to audit the system's effectiveness.

Written by urgent.news from Dev.to's reporting — not their text. Machine-written — may contain errors; check the original before relying on it.

Read the original at dev.to →

More in Tech

Rufus vs Ventoy: Why I Started Using Ventoy for Bootable USBs

If you use Windows or Linux, you may have created a bootable USB at some point. For example, if you want to install Windows 11 or Linux Mint , you can download the ISO file and use a tool like Rufus…

  • Ventoy allows multiple ISO files on a single USB drive
  • Ventoy provides menu for selecting desired ISO during boot
  • Ventoy supports persistence, varies by Linux distribution

How to Pass the Amazon SQL Interview (A Practical Guide)

If you're prepping for a Business Intelligence (BI) Engineer, Data Analyst, Data Engineer, or Data Scientist role at Amazon, you probably already know SQL matters. It's a core part of the hiring bar.

  • Amazon SQL interviews assess business reasoning, not just syntax
  • Correct queries over clever ones that fail in Amazon interviews
  • Use Common Table Expressions (CTEs) for readability and clarity

Why To-Do Lists Fail (21,655 Tasks of Data)

TL;DR. I counted every task in Loggd. Across 21,655 one-off tasks from 1,375 people, 7,774 were completed, which is 35.9%. The shape matters more than the rate: 40.8% of completed tasks were finished the same day they were created, the median completed task took 1 day, and the ones that did not move quickly now sit a median of 56 days…

More from Sunday 6 September →