Our great sponsors
-
-
sqlitebrowser
Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
There's a hacky way to make a backup of messages sent on IOS, if you sync messages to desktop client, because desktop client stores messages in a SQLite database. While encrypted, encryption key for the database is kept as plaintext in a JSON file. :)
On Windows:
1. Download "DB Browser for SQLite" https://sqlitebrowser.org/
2. Unpack it and run "DB Browser for SQLCipher.exe".
3. Open database, select "%APPDATA%\Signal\sql\db.sqlite".
4. In the following dialog, select "Raw key" type and enter the encryption key stored in "%APPDATA%\Signal\config.json" into Password field (prefix it with 0x).
5. Now you can work with the database, including exporting its contents to unencrypted SQLite, CSV and JSON.
The process should be similar on other platforms.
It's not, it's an Electron-based App. Even says so on their Github page: https://github.com/signalapp/Signal-Desktop
Unless you're using a non-official version?