No sure if this is an acceptable workaround/alternative [0] for Germany but on the "Request My Data" page (https://www.amazon.de/gp/privacycentral/dsar/preview.html) you can request all of your account data and this should include the following file with all of your orders: Retail.OrderHistory.2/Retail.OrderHistory.2.csv
It has the following format:
"Marketplace","Order ID","Order Date","Purchase Order Number","Currency","Price","Price Tax","Shipping Charge","Total Discounts","Total Owed","Item Subtotal","Item Subtotal Tax","ASIN","Product Condition","Quantity","Payment Instrument Type","Order Status","Shipment Status","Ship Date","Shipping Option","Shipping Address","Billing Address","Carrier Name & Tracking Number","Product Name","Gift Message","Gift Sender Name","Gift Recipient Contact Details"
(Note: My last export is from January so the filename or format might have changed in the meantime.)
[0]: It provides more data but is annoying / time consuming to use.
Not sure how reliable and resilient SQLCipher is but that might (significantly?) increase the risk for a bug/corruption to occur. And the encryption certainly makes the analysis more difficult (while, at least on GNU/Linux, I don't see any advantage as the encryption key is stored unencrypted in ~/.config/Signal/config.json - not sure if other Desktop platforms support secure keystores like on Android and iOS). I briefly tried to analyze my corrupted DB but quickly gave up as I'm not familiar with SQLCipher and basically only got a generic "Error: file is not a database" error message when trying to decrypt it (and there's no plaintext header IIRC so it looks just like random data).
I also had multiple backups of the SQLCipher DB that I could successfully access manually but I was unable to use them for Signal-Desktop (not sure if this was due to some other Electron DBs/state, the stateful Signal protocol, or something else - IIRC the only hint was the "Database startup error: Error: SQLITE_NOTADB: file is not a database" message that didn't really help much).
> unless you want them to see who you recently communicated with in what order as well as the start of the most recent messages.
Thanks for mentioning that. I always wondered why there's no option to at least hide the most recent messages and dates (or temporarily hide the whole sidebar). I guess most people are either fine with it or use their phone instead (and using Signal-Desktop in public / when someone's looking is probably uncommon). It seems like at least Telegram-Desktop has this issue as well (not sure if there's an option for it).
Anyway, a slight modification to the UI to hide/minimize the sidebar would be something I'd appreciate for those rare situations.
> Can't say I'd be happy if it started adding a bunch of features I didn't ask for.
What features do you mean here? The GitHub issue is a bug report and not a feature request. However, there are two features that could help: Backups (export and import functionality) and syncing older messages from the phone during the initial setup. Both of these features can be fully optional and shouldn't require much code.
This whole thing is especially painful/annoying since they neither support backing up the database nor syncing/importing old messages from the phone. So if this happens there's no known/reliable way to recover (even though the data is still on the phone).
(In theory it should be possible to recover from this and I can still access my sqlcipher database manually but Electron and the stateful Signal protocol make it extremely difficult so I gave up. Multiple backups of the whole ~/.config/Signal directory didn't help either.)
It has the following format: "Marketplace","Order ID","Order Date","Purchase Order Number","Currency","Price","Price Tax","Shipping Charge","Total Discounts","Total Owed","Item Subtotal","Item Subtotal Tax","ASIN","Product Condition","Quantity","Payment Instrument Type","Order Status","Shipment Status","Ship Date","Shipping Option","Shipping Address","Billing Address","Carrier Name & Tracking Number","Product Name","Gift Message","Gift Sender Name","Gift Recipient Contact Details"
(Note: My last export is from January so the filename or format might have changed in the meantime.)
[0]: It provides more data but is annoying / time consuming to use.