Choose an appropriate license suitable for open-source apps, and add copyright notices to the files.

Current indigo is not very "lovely".

Tool to help pick colour - https://uicolors.app/create

Tailwind CSS color candidates:

• rose
• amber
• orange

It is currently impossible to return from the "Display" window (where statistics for selected conversation is shown). We need a back button so that the user can choose the conversation again.

We need a simple logo for the app launch. This is required by AppStore and ProductHunt

Instead of showing "22-04-2022" use "22nd April 2022". It is not perfect in terms of locale support, but better than what it is now.

The calls can be found in the messages table. Each call has a type of "call-history". Most of the information regarding call is stored in the json column of the table.

We should only count calls that were not declined ($.callHistoryDetails.wasDeclined == false). Ideally we should also ensure that even accepted calls took a place (e.g, where not dropped right away due to network or other errors).

There are two types of calls, incoming ("You called") and outgoing ("I called"). They can be found in json column via query $.callHistoryDetails.wasIncoming.

The incoming call JSON looks like this:

{
   "conversationId":"44",
   "type":"call-history",
   "sent_at":1647888307356,
   "received_at":66722,
   "received_at_ms":1647888307356,
   "readStatus":0,
   "callHistoryDetails":{
      "callMode":"Direct",
      "wasIncoming":true,
      "wasVideoCall":false,
      "wasDeclined":false,
      "endedTime":1647888307356
   },
   "id":"55",
   "schemaVersion":10,
   "attachments":[
      
   ],
   "hasAttachments":0,
   "contact":[
      
   ],
   "seenStatus":0
}

The outgoing call JSON looks like this:

{
   "conversationId":"44",
   "type":"call-history",
   "sent_at":1647789536680,
   "received_at":65851,
   "received_at_ms":1647789536680,
   "readStatus":0,
   "callHistoryDetails":{
      "callMode":"Direct",
      "wasIncoming":false,
      "wasVideoCall":true,
      "wasDeclined":false,
      "acceptedTime":1647785450766,
      "endedTime":1647789536680
   },
   "id":"55",
   "schemaVersion":10,
   "attachments":[
      
   ],
   "hasAttachments":0,
   "contact":[
      
   ],
   "seenStatus":0
}

Using json_extract function (docs), it is possible to efficiently query json in SQLite.

Looks like received_at is just an incremental counter and not an actual timestamp (code link).

When the the Signal Desktop database is missing, show a screen explaining that the Signal Your Love app requires Signal Desktop to be installed.

It would be nice to have a number of hours or minutes in total that two people spend on a call.

Currently, it might not be clear to users what a calendar heatmap means. Adding a name for the section and a short description would be good. For example, "How often have we texted each other" as a section title, and as a short description "Each cell represents a single day, hover over to see a number of messages".

It would be nice to have a footer in the "Select conversation" view that shows something like this:

Created by Vladyslav Moisieienkov
Visit signalyourlove.app for more details

"endlessly" can imply a streak, whereas, in reality, it means how many days is between the first and last message.

We need a way to save statistics from a chat somehow. It can be useful for keeping track of history or for documenting (example article)

Now that we switched to the donations model (in VMois/signalyourlove-web#5), it would be good to have a link to the donation page in the "SelectConversation" view. It can be placed in the footer section.

We can use library - https://www.npmjs.com/package/react-calendar-heatmap