Can't Retrieve Data From Sqlite3 File With Unexpected Characters

I have sqlite3 database file that I'm trying to get data from. When I try to open it in sqliteBrowser it will generate the tables but it ignores the data within the file so I get e

Solution 1:

With no warranties at all!

Your database is corrupt or, somehow, records were deleted.

However, you still can open your file in a text editor and see a lot of records like:

...{"channel":"app-emit","payload":{"type":"vehicle","deviceId":"d4f9bb04b6d5","time":1595510864502,"appName":"vehicle","appVersion":"1.0.1","data":{"count":1,"speed":0.0,"zoneId":"inbound","time":1595510864502}}}...

I don't know which table they belong or if they are actual or outdated, not even how many are lost.

Using this method, could recovered 4087 records: https://justpaste.it/38j03

Further knowledge on your application should help you evaluate if they are useful or not.

EDIT: Method used:

I used a hexadecimal/text editor (MadEdit) to:

1. place a break before {"channel": (replace hex 7B226368616E6E656C223A with 0A7B226368616E6E656C223A)
2. place a break after }}} (replace hex 7D7D7D with 7D7D7D0A)
3. removed every occurrence of null (replace hex 00 with nothing)

Then copied everything an pasted into spreadsheet application (Excel), so some sorting and filtering may be done.

Better method: open in Word, make same replacements ({"channel": to ^p"channel": and }}} to }}}^p), then paste to Excel.