-
Notifications
You must be signed in to change notification settings - Fork 7
/
spec.txt
23 lines (16 loc) · 675 Bytes
/
spec.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Functions needed:
- Add search.
- Show full list of tags.
- Moderator functions: moderator users can delete/edit submissions.
Hackernews points formula
-------------------------
(p - 1) / (t + 2)^1.5
Votes divided by age (gravity) factor
p = votes (points) from users.
t = time since submission in hours.
p is subtracted by 1 to negate submitters vote.
age factor is (time since submission in hours plus two) to the power of 1.5.
To compute number of seconds since a particular time:
SELECT (strftime('%s', 'now') - strftime('%s', createdt)) / 60 FROM entry;
custom sqlite functions in Go:
https:/mattn/go-sqlite3/blob/master/_example/custom_func/main.go