2025-12-01
Haiku Package Growth
HaikuDepotServer (HDS) was first deployed in 2014. Its purpose is to catalogue the packages available for the Haiku operating system and to provide a curation and delivery system for package meta-data. At first there were very few packages but the number of packages quickly grew and continues to grow.
The database query for obtaining this information is shown below.
WITH x AS (SELECT extract(year from p.create_timestamp) AS year, COUNT(id) AS cnt
FROM haikudepot.pkg p
WHERE p.create_timestamp < '2025-01-01 00:00:00'
GROUP BY extract(year from p.create_timestamp))
SELECT x.year, SUM(x.cnt) OVER (ORDER BY x.year) AS total_cnt
FROM x
ORDER BY x.year
Naturally, and happily, the quantity of versions of packages has also grown over the last decade too.
Since inception, there have been many enhancements both large and small made to both HDS and the desktop HaikuDepot application to support this growth and this work continues with more changes in 2026.