-
Notifications
You must be signed in to change notification settings - Fork 0
/
TODO
41 lines (34 loc) · 2.1 KB
/
TODO
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
add restrictions to filters in struct tags
process deleted communities
/amcharts/images/dragIconRoundBig.svg 404
fix logging
clean username versions with the same value but in different cases
fix a lot of connections issue
process deleted
fix user with id 2159282 and 1834991
save last used proxy in redis
reorder columns to save some space
store videos attached to comments(see pikago models)
add community chiefs
limit time per server request
FIX this bug:
postgres@(none):pikagraphs> select pikabu_id, content_blocks from pikabu_stories where NOT (content_blocks @> '[{"type": "t"}]') AND NOT (content_blocks @> '[{"type": "i"}]') AND NOT (content_blocks @> '[{"type": "v"}]') AND NOT (content_blocks @> '[{"type": "vf"}]') limit 10;
+-------------+------------------+
| pikabu_id | content_blocks |
|-------------+------------------|
| 170651 | [] |
| 171171 | [] |
| 170721 | [] |
| 170696 | [] |
| 170746 | [] |
| 170712 | [] |
| 170595 | [] |
| 170537 | [] |
| 170594 | [] |
| 170607 | [] |
+-------------+------------------+
SELECT 10
Fix this bug:
https://pikastat.d3d.info/story/pikabu_id==60
consider using something like prometheus
collect stories views