J-Pilot Usage Statistics

· klm's blog

Original post is here: eklausmeier.goip.de

Since 26-Nov-2023 I no longer user the J-Pilot native format for data storage. Rather, I only use the SQLite data format. I.e., I use SQLite since roughly five months.

The SQLite database tables contain two columns called

  1. InsertDate
  2. UpdateDate

It is therefore now easy to see how many records have been created or changed since these five months.

Table Operation Number
Address Insert 37
. Update 22
Datebook Insert 312
. Update 23
Memo Insert 0
. Update 12

Summarizing:

  1. I insert some addresses, but also correct almost the same number
  2. I mostly insert new datebook entries, and do not edit them very often
  3. I mostly update, already existant memos

Below SQL was used to get above numbers.

1select count(*) from Addr where InsertDate > '2022-11-26T18:23:54';
2select Id, julianDay(UpdateDate) - julianDay(InsertDate) from Addr where julianDay(UpdateDate) - julianDay(InsertDate) > 0.1;
3
4select count(*) from Datebook where InsertDate > '2022-11-26T18:23:54';
5select Id, julianDay(UpdateDate) - julianDay(InsertDate) from Datebook where julianDay(UpdateDate) - julianDay(InsertDate) > 0.1;
6
7select count(*) from Memo where InsertDate > '2022-11-26T18:23:54';
8select Id, julianDay(UpdateDate) - julianDay(InsertDate) from Memo where julianDay(UpdateDate) - julianDay(InsertDate) > 0.1;

The reason for the seemingly funny difference of 0.1 days is: A record updated within a fraction of a day, is probably just first entered and then updated very quickly. Essentially, I count this as "new insert".

#SQLite #statistics