retrospring/app/helpers
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
..
application_helper clean up routes 2022-07-23 12:14:06 +02:00
social_helper add sharing to telegram 2023-02-19 20:58:47 +01:00
ajax_helper.rb added ajax controller 2014-11-10 13:03:42 +01:00
application_helper.rb Cache inbox and notification counters 2023-03-07 19:14:14 +01:00
bootstrap_helper.rb Put IDs directly on nav entries 2023-08-16 21:17:18 +02:00
feedback_helper.rb Fix Ruby codestyle 2022-01-22 22:50:32 +01:00
layouts_helper.rb fix parent_layout for HAML 6 2022-10-25 19:35:53 +02:00
markdown_helper.rb Remove raw markdown options 2023-02-18 20:19:31 +01:00
moderation_helper.rb appease the Cyber Canine 9000 2022-07-23 12:19:47 +02:00
search_helper.rb attempt to add pg_search 2023-10-22 18:13:26 +02:00
social_helper.rb Fix rubocop nits 2023-10-17 20:14:28 +02:00
theme_helper.rb Appease the dog overlords 2023-01-29 21:13:38 +01:00
user_helper.rb Make target a keyword argument for user_screen_name helper 2023-05-09 23:20:36 +02:00