mirrors/retrospring
1
0
Fork 0
mirror of https://github.com/Retrospring/retrospring.git synced 2025-01-31 07:29:09 +01:00
Code Issues Projects Releases Packages Wiki Activity
5211 commits 26 branches 126 tags 24 MiB
Commit graph

186 commits

Author SHA1 Message Date
Georg Gadinger
44871cbf4a add meilisearch 
this thing is way too fast!  only downside is that indexing takes a bit
longer, and the search indexes are big (16Gi for 2.7 million records)

i have no idea how to properly integrate it in the UI, but it seems
promising :^)
 2023-10-22 19:51:19 +02:00
Georg Gadinger
d5c1e66b1e remove pg_search 2023-10-22 18:34:05 +02:00
Georg Gadinger
c14bae74d5 attempt to add pg_search 
this commit is an attempt at building a search functionality using only
the stuff provided by postgresql

it is, unfortunately, painfully slow:

    PgSearch::Document Load (7869.1ms)  SELECT "pg_search_documents".* FROM "pg_search_documents" INNER JOIN (SELECT "pg_search_documents"."id" AS pg_search_id, (ts_rank((to_tsvector('simple', coalesce("pg_search_documents"."content"::text, ''))), (to_tsquery('simple', ''' ' || 'awoo' || ' ''')), 0)) AS rank FROM "pg_search_documents" WHERE ((to_tsvector('simple', coalesce("pg_search_documents"."content"::text, ''))) @@ (to_tsquery('simple', ''' ' || 'awoo' || ' ''')))) AS pg_search_ce9b9dd18c5c0023f2116f ON "pg_search_documents"."id" = pg_search_ce9b9dd18c5c0023f2116f.pg_search_id ORDER BY pg_search_ce9b9dd18c5c0023f2116f.rank DESC, "pg_search_documents"."id" ASC LIMIT $1  [["LIMIT", 10]]
 2023-10-22 18:13:26 +02:00
Karina Kwiatek
2a6d88abfc Include type in relationship unique constraint 2023-10-18 19:40:15 +02:00
Karina Kwiatek
84d4ac3dc6 Backfill missing created_at on comment notifications 2023-05-26 20:39:53 +02:00
Karina Kwiatek
51638d2eb2 Remove subscriptions.is_active column 2023-05-05 16:01:40 +02:00
Karina Kwiatek
1ec5ffa6d2 Cache inbox and notification counters 2023-03-07 19:14:14 +01:00
Karina Kwiatek
b5b4f11056 Add index for answers.created_at 
This improves query time for the public timeline
 2023-02-18 15:33:10 +01:00
Karina Kwiatek
c2baa86c09 Add pinned_at to answers 2023-02-12 20:19:50 +01:00
Georg Gadinger
e1aee89be0 remove expired service connection notifications 2023-02-12 19:26:31 +01:00
Andreas Nedbal
9246148db4 Add migration to drop services table 2023-02-05 21:54:51 +01:00
Andreas Nedbal
a2e45c85bf Add migration to enable sharing for legacy service owners 2023-02-05 21:54:51 +01:00
Andreas Nedbal
482ffe7d0b Add migration to add sharing fields to users 2023-02-05 21:54:51 +01:00
Andreas Nedbal
0d78442507 Fix up theme value migration 2023-01-29 21:25:24 +01:00
Andreas Nedbal
b5ab9d67d2 Add migration to use body text value for raised texts in themes 2023-01-29 20:58:19 +01:00
Andreas Nedbal
a0a7f4e124 Add raised-text and raised-accent-text theme variables 2023-01-23 23:36:38 +01:00
Karina Kwiatek
09d110eb58 Add option for allowing long questions 2023-01-08 13:03:06 +01:00
Karina Kwiatek
1cfd3250c0 Track failures on Web Push subscriptions 2023-01-02 11:51:46 +01:00
Karina Kwiatek
67423699b6 Use fetch to get contact_email from config in webpush app migration 2023-01-02 11:51:46 +01:00
Karina Kwiatek
22a84ab818 Appease the dog overlords 2023-01-02 11:51:45 +01:00
Karina Kwiatek
10c224b2fe Address review comments from @nilsding 
Co-authored-by: nilsding <nilsding@nilsding.org>
 2023-01-02 11:50:48 +01:00
Karina Kwiatek
2f8126d732 Supress lint errors in Add RPush migration 2023-01-02 11:50:48 +01:00
Karina Kwiatek
29a3bfea88 Fix incorrect internal class names in Rpush migration 
This was caused by `rubocop -A`
 2023-01-02 11:50:47 +01:00
Karina Kwiatek
a04b290067 Appease the dog overlords 2023-01-02 11:50:47 +01:00
Karina Kwiatek
32ab9267ec Add web push subscription model 2023-01-02 11:50:47 +01:00
Karina Kwiatek
4e08f035d1 Create migration for adding an rpush app for webpush 2023-01-02 11:50:47 +01:00
Karina Kwiatek
92ba2d7c9b Add rpush 2023-01-02 11:50:47 +01:00
Andreas Nedbal
d51ef91775 Make question_id on anonymous blocks nullable 2022-12-28 00:10:59 +01:00
Andreas Nedbal
1f401b2e1b Sync schema 2022-12-28 00:10:59 +01:00
Andreas Nedbal
7ccee0c000 Make question_id in anonymous blocks nullable again 2022-12-28 00:10:59 +01:00
Andreas Nedbal
f76f8f706a Fix schema 2022-12-28 00:10:59 +01:00
Andreas Nedbal
e7f60acad5 Add target_user field to anonymous blocks 2022-12-28 00:10:59 +01:00
Andreas Nedbal
60819ff90e Fix schema 2022-11-18 23:29:47 +01:00
Andreas Nedbal
23dafb5bcb
Merge branch 'main' into feature/privacy-noindex 2022-11-18 23:23:01 +01:00
Andreas Nedbal
d3bfbff30a
Merge branch 'main' into feature/input-placeholder-theming 2022-11-18 23:21:08 +01:00
Andreas Nedbal
88375f7d21 Cleanup schema 2022-11-18 23:19:24 +01:00
Andreas Nedbal
fe9a77cd67 Fix lints 2022-11-18 23:19:24 +01:00
Andreas Nedbal
0b499138e0 Add social graph hiding field to user 2022-11-18 23:19:24 +01:00
Andreas Nedbal
2367bb3139 Add noindex field to user 2022-11-16 22:31:49 +01:00
Andreas Nedbal
d7911e9486 Add input placeholder field to theme 2022-11-14 23:11:09 +01:00
Andreas Nedbal
3cefc829f8
Merge branch 'main' into feature/privacy-require-user 2022-11-13 17:27:53 +01:00
Andreas Nedbal
240092be6c Fix schema 2022-11-13 14:46:40 +01:00
Andreas Nedbal
3569cb335c Add frozen string literal comment 2022-11-13 14:40:34 +01:00
Andreas Nedbal
1fd50daa22 Update schema version 2022-11-13 14:39:32 +01:00
Andreas Nedbal
cdc7e2b9cc Add user requirement setting to user 2022-11-13 14:25:03 +01:00
Andreas Nedbal
5f97b87f3c Fix rubocop offenses 2022-11-06 15:23:05 +01:00
Andreas Nedbal
3f6e61e39b Remove non-existent table from schema 2022-11-06 15:21:19 +01:00
Andreas Nedbal
049f92e138 Add inbox locking setting to user 2022-11-06 14:59:56 +01:00
Karina Kwiatek
c7418b5de7 Make user_id on anonymous_blocks nullable 2022-08-20 19:05:55 +02:00
Karina Kwiatek
7b831875b0 Add index to notifications.type and make it non-nullable 2022-07-22 16:52:42 +02:00