How long does it take for a new repo to come online.
FreshPorts does not have a lot of stats yet, but here is what we have today:
freshports.org=# SELECT abi.name, package_set, inserts, updates, deletes, repo_date
FROM package_imports PI, abi
WHERE PI.abi_id = abi.id and repo_date > '2020-05-31'
ORDER BY abi.name, package_set, repo_date;
name | package_set | inserts | updates | deletes | repo_date
--------------------+-------------+---------+---------+---------+------------------------
FreeBSD:11:aarch64 | quarterly | 13 | 80 | 1 | 2020-06-01 20:41:00+00
FreeBSD:11:amd64 | latest | 12 | 222 | 28 | 2020-06-01 00:43:00+00
FreeBSD:11:amd64 | quarterly | 0 | 10 | 0 | 2020-05-31 22:42:00+00
FreeBSD:11:amd64 | quarterly | 0 | 10 | 0 | 2020-06-02 07:32:00+00
FreeBSD:11:armv6 | quarterly | 0 | 4 | 0 | 2020-06-02 09:59:00+00
FreeBSD:11:i386 | latest | 14 | 210 | 25 | 2020-05-31 19:15:00+00
FreeBSD:11:i386 | quarterly | 0 | 10 | 0 | 2020-05-31 16:20:00+00
FreeBSD:11:i386 | quarterly | 0 | 10 | 0 | 2020-06-02 07:12:00+00
FreeBSD:11:mips | quarterly | 0 | 1 | 0 | 2020-05-31 02:45:00+00
FreeBSD:11:mips | quarterly | 0 | 2 | 0 | 2020-06-02 02:46:00+00
FreeBSD:11:mips64 | quarterly | 0 | 1 | 0 | 2020-05-31 08:32:00+00
FreeBSD:11:mips64 | quarterly | 0 | 2 | 0 | 2020-06-02 08:33:00+00
FreeBSD:12:amd64 | latest | 13 | 225 | 22 | 2020-05-31 23:49:00+00
FreeBSD:12:amd64 | quarterly | 0 | 10 | 0 | 2020-05-31 22:08:00+00
FreeBSD:12:amd64 | quarterly | 0 | 10 | 0 | 2020-06-02 07:21:00+00
FreeBSD:12:armv6 | quarterly | 1 | 6 | 27 | 2020-05-31 18:45:00+00
FreeBSD:12:armv6 | quarterly | 24 | 4 | 0 | 2020-06-02 20:45:00+00
FreeBSD:12:armv7 | quarterly | 11 | 7 | 36 | 2020-05-31 01:22:00+00
FreeBSD:12:armv7 | quarterly | 31 | 4 | 0 | 2020-06-02 12:13:00+00
FreeBSD:12:i386 | latest | 15 | 210 | 25 | 2020-05-31 19:23:00+00
FreeBSD:12:i386 | quarterly | 0 | 10 | 1 | 2020-05-31 16:21:00+00
FreeBSD:12:i386 | quarterly | 0 | 10 | 0 | 2020-06-02 07:07:00+00
FreeBSD:12:mips | quarterly | 0 | 1 | 0 | 2020-05-31 04:21:00+00
FreeBSD:12:mips | quarterly | 0 | 2 | 0 | 2020-06-02 04:24:00+00
FreeBSD:12:mips64 | quarterly | 0 | 1 | 0 | 2020-05-31 15:57:00+00
FreeBSD:12:mips64 | quarterly | 0 | 2 | 0 | 2020-06-02 15:58:00+00
FreeBSD:13:amd64 | latest | 39 | 347 | 40 | 2020-05-31 04:02:00+00
FreeBSD:13:amd64 | latest | 25 | 428 | 59 | 2020-06-03 04:29:00+00
FreeBSD:13:i386 | latest | 16 | 210 | 29 | 2020-05-31 02:56:00+00
FreeBSD:13:i386 | latest | 31 | 419 | 50 | 2020-06-03 04:30:00+00
FreeBSD:13:mips64 | latest | 1 | 5 | 0 | 2020-05-31 09:30:00+00
FreeBSD:13:mips64 | latest | 1 | 30 | 5 | 2020-06-02 09:55:00+00
(32 rows)
freshports.org=#
Roughly, it’s every two days.
The value in repo_date is taken from packagesite.txz as found at https://pkg.freebsd.org/FreeBSD:12:amd64/latest/ for example.
What are inserts, updates, deletes?
- inserts: The number of packages which were not present in the previous instance of this repo but were in this instances (e.g. new ports).
- updates: The number of packages present in the previous instance of this repo but now have different version numbers (e.g. the port has been updated).
- deletes: The number of package present in the prevoius instance of this repo, but were not found in the new repo (e.g. port has been deleted).
Graphing this data is a good idea, but we need help getting graphs working again.
