Deleting old messages

In the SMAT database, there are no columns that directly show a message’s age. You can use the Time or TimeIn columns to calculate the age.

These columns are INTEGER type in the smat_msgs table.

  1. Access the SMAT database.
  2. Use the sqlite command:
    delete * from smat_msgs where condition
    For example, the current time is 1452510267000 milliseconds, and the time older than 10s is 1452510257000.
    In this case, messages older than 10s can be deleted using:
    delete * from smat_msgs where time <= 1452510257000