Zankaria
1 follower · 1 following
  • Joined on 2025-02-18
Repositories Projects Packages Public activity Starred repositories
1
Zankaria created branch ukko-catalog-sql-perf in leftypol/leftypol 2025-07-06 15:56:59 -05:00
Zankaria pushed to ukko-catalog-sql-perf at leftypol/leftypol 2025-07-06 15:56:59 -05:00
4718ab2085 catalog: use faster CTE query to query threads (made by perdedora)
Zankaria commented on issue leftypol/leftypol#133 2025-07-06 15:36:50 -05:00
High CPU usage on overboards's catalog

Proposal by @perdedora (reformatted)

WITH thread_data AS (
	SELECT id AS thread_id,	COUNT(id) AS reply_count, SUM(num_files) AS image_count, 'b' AS board
	FROM posts_b
	WHERE thread IS…
Zankaria opened issue leftypol/leftypol#133 2025-07-06 15:33:16 -05:00
High CPU usage on overboards's catalog
Zankaria pushed to config at leftypol/leftypol 2025-07-03 15:22:52 -05:00
9878b0c4d2 static: use the alunya favicon
Zankaria opened issue leftypol/leftypol#132 2025-06-17 14:52:11 -05:00
Add password notes
Zankaria opened issue leftypol/leftypol#131 2025-06-13 13:03:54 -05:00
Add staff role to public log
Zankaria pushed to rework-search at leftypol/leftypol 2025-06-10 11:30:27 -05:00
4ebbc0193b SearchService.php: remove spurious initialization
Zankaria pushed to rework-search at leftypol/leftypol 2025-06-10 11:17:54 -05:00
bf98dbca20 search.php: handle query too broad error
2595bced73 style.css: remove fieldset label css (interfered with threads in the search page)
f6b4f21f91 docker: print PHP errors on docker log
42a185f362 SearchService.php: query too broad check
dc62c3f65f SearchService.php: check for query too broad
Compare 50 commits »
Zankaria pushed to config at leftypol/leftypol 2025-06-10 11:08:38 -05:00
342d4f9608 youtube.js: use www.youtube-nocookie.com
Zankaria closed issue leftypol/leftypol#130 2025-06-10 11:05:01 -05:00
Tsuki style is broken
Zankaria commented on issue leftypol/leftypol#130 2025-06-10 11:05:00 -05:00
Tsuki style is broken

Fixed with 76bcbccbf4

Zankaria pushed to config at leftypol/leftypol 2025-06-10 11:01:19 -05:00
76bcbccbf4 tsuki: fix post color
Zankaria pushed to config at leftypol/leftypol 2025-06-10 10:48:50 -05:00
4a884db765 tsuki: fix post color
Zankaria opened issue leftypol/leftypol#130 2025-06-08 02:57:52 -05:00
Tsuki style is broken
Zankaria pushed to rework-search at leftypol/leftypol 2025-06-07 16:40:25 -05:00
2dd2998cda search.php: handle query too broad error
fd0dbf9a82 style.css: remove fieldset label css (interfered with threads in the search page)
5305b605cb docker: print PHP errors on docker log
eb2c0b056e SearchService.php: query too broad check
31f9d9d7fc SearchService.php: check for query too broad
Compare 19 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-06-07 16:31:52 -05:00
92c99c9f16 search.php: handle query too broad error
da679ee56c style.css: remove fieldset label css (interfered with threads in the search page)
428050c5da docker: print PHP errors on docker log
cf1da6b644 SearchService.php: query too broad check
5429f209f1 SearchService.php: check for query too broad
Compare 33 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-06-07 16:28:32 -05:00
eef9c4e7fc SearchService.php: query too broad check
c17d180307 search.php: handle query too broad error
b90ec0f425 SearchService.php: check for query too broad
0d96214a54 style.css: remove fieldset label css (interfered with threads in the search page)
0dfbb47e60 docker: print PHP errors on docker log
Compare 50 commits »
Zankaria pushed to rework-search at leftypol/leftypol 2025-06-06 19:02:40 -05:00
9cda7b807e UserPostQueries.php: remove old comment
Zankaria pushed to rework-search at leftypol/leftypol 2025-06-06 18:57:10 -05:00
fbefcdee4e SearchService.php: query too broad check