, 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
InsertDate
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:
- I insert some addresses, but also correct almost the same number
- I mostly insert new datebook entries, and do not edit them very often
- 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".