1. Android Central Question's Avatar
    Can i find my deleted messages on my LG Style phone?
    06-23-2019 01:36 PM
  2. Rukbat's Avatar
    Yes, if you do 4 things first:

    1. Root the phone.

    2. Install a SQL editor.

    3. Find the SMS database file.

    4. Learn SQL well enough to figure out where the "deleted/active" field is, so you can find the deleted messages and update that feld to active.

    In other words, for all practical purposes, probably not. (Even if you could do #1 , #2 is trivial, #3 might take some time, but it's doable, but #4 could take anywhere from months to years.)
    06-23-2019 02:11 PM
  3. ManiacJoe's Avatar
    Slightly hijacking the thread....

    Is there really a "deleted/active" field in the record?
    As opposed to just deleting the record?
    06-24-2019 12:16 AM
  4. Rukbat's Avatar
    Databases usually just mark the record deleted, then purge the file at some later time. I haven't really studied the SMS database file, but I'd assume that they'd do it the same way. SQL developers get used to doing something, then they do it on all SQL databases (and SQLite is a SQL database).
    06-25-2019 03:12 PM
  5. ManiacJoe's Avatar
    Normally at the SQL level, you would use the command "DELETE FROM table_name WHERE ...", no later purging needed.

    While you could use a "UPDATE table_name SET MyDeleted = TRUE WHERE …" to be able to implement an "undelete" option from the app's UI, that is usually way too much overhead than most programmers will want to deal with, short of being bribed by the sales/marketing dept.

    That said, I have no idea what any of the normal Android database definitions look like; but as a database programmer, I would love to see them.
    06-25-2019 10:48 PM

Similar Threads

  1. Replies: 11
    Last Post: 07-02-2019, 08:05 AM
  2. Stutter issues on the Oneplus 7 Pro
    By Fabi An in forum OnePlus 7 & OnePlus 7 Pro
    Replies: 4
    Last Post: 06-24-2019, 06:59 PM
  3. Youtube crashes on launch
    By Android Central Question in forum Ask a Question
    Replies: 2
    Last Post: 06-24-2019, 01:44 AM
  4. Why is messenger not on my home screen or any screen anymore?
    By Android Central Question in forum Ask a Question
    Replies: 1
    Last Post: 06-23-2019, 02:12 PM
  5. Where are ALL the settings that make the screen turn on automatically?
    By MaxSmart86 in forum General Help and How To
    Replies: 0
    Last Post: 06-23-2019, 11:16 AM