• 0 Posts
  • 70 Comments
Joined 2 years ago
cake
Cake day: October 19th, 2024

help-circle


  • The motion sensing is more accurate in terms of fundamentally detecting movement, but if you’re going from that to assuming it can identify who you are, no it doesn’t do that. It can recognize a person as the same person it saw in the room yesterday, based on their gait and their effect on the local wifi signal, but it has no way of knowing if the pattern belongs to Old Man Wilson or Old Lady Jenkins, because there’s no database tying those patterns to people’s identities. And besides, the patterns are specific to that one signal environmnent anyway. It’s not like a fingerprint or a facial image you could record at home and then match to someone walking around in a store, which has a different signal environment.















  • Lovable Sidekick@lemmy.worldtoProgrammer Humor@programming.dev#NULL!
    link
    fedilink
    English
    arrow-up
    5
    ·
    edit-2
    22 hours ago

    You wouldn’t - what they’re describing is called “SQL injection” - a way to fool poorly written web server code (regardless of what language it’s writen in) into executing SQL code. The poorly written server code takes what’s entered in a form field on a web page and pastes it into a skeleton of a SQL statement - in this case the text in the input field is SQL that ends the intended statement, followed by a new statement that deletes a table. For this to even work, the SQL skeleton on the server would have to be structured in just the right way so the modified version with the pasted-in text still makes sense. For this reason, hackers attempting SQL injection usually have to do a lot of trial and error to get something to happen. The only way it can work at all is if the server software handling the web page sends SQL commands to a database server as text, as if they’re being typed in, and the server executes them. You can’t inject C in this way because unlike SQL, C code isn’t just executed, C programs have to be precompiled.




  • The need for a constant signal to scan movement is a good point. Makes sense that nearby wifi devices can’t just be sitting there, they have to be actively transmitting to the router or there’s no signal for the target to interfere with. I must have gotten CSI and wifi scanning confused. Tbh I’m not even sure why CSI is in the article except for history, but I found the principle fascinating. In your research did you turn the intererence into anything like a heat map of a person standing in the room, or is it more of a signal fingerprint, like chromatography or spectrography?