, 1 min read

J-Pilot Usage Statistics

Original post is here eklausmeier.goip.de/blog/2023/04-08-j-pilot-usage-statistics.


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.

select count(*) from Addr where InsertDate > '2022-11-26T18:23:54';
select Id, julianDay(UpdateDate) - julianDay(InsertDate) from Addr where julianDay(UpdateDate) - julianDay(InsertDate) > 0.1;

select count(*) from Datebook where InsertDate > '2022-11-26T18:23:54';
select Id, julianDay(UpdateDate) - julianDay(InsertDate) from Datebook where julianDay(UpdateDate) - julianDay(InsertDate) > 0.1;

select count(*) from Memo where InsertDate > '2022-11-26T18:23:54';
select 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".