~earboxer/apkbrowser-gemini

ref: 86df0fd15da2d5cf1c31a99f5a289a1f2b5a641c apkbrowser-gemini/packages -rwxr-xr-x 388 bytes
86df0fd1Zach DeCook packages: make subscribable 3 months ago
                                                                                
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
#!/bin/sh
. ./config.sh
printf "20 text/gemini\r\n"
echo "# Packages"

printf 'SELECT "=>",
	"/package/%s/" || repo ||"/"||arch||"/"||name,
	datetime(build_time,"unixepoch"),
	(name || "-" || version),
	license
	FROM packages
	ORDER BY build_time desc
	LIMIT 10;' "$default_branch"| \
sqlite3 -separator "$(printf "\t")" "db/$default_branch.db"

# TODO: Add pagination with query string.