Commit Graph

5 Commits

Author SHA1 Message Date
towards-a-new-leftypol 9e3c054c53 sql: improve search_posts function 2024-02-19 14:51:56 -05:00
towards-a-new-leftypol 54a14156d0 Move PostsType into submodule, commit local changes 2024-01-13 11:22:06 -05:00
towards-a-new-leftypol 8a10ce4798 sql - fetch_catalog needs ORDER BY bump time after all those operations 2023-11-01 20:23:47 -04:00
towards-a-new-leftypol 2fcd1d0582 Add subject and name to posts table text index 2023-11-01 19:14:50 -04:00
towards-a-new-leftypol c297bae697 - Change fetch_catalog and fetch_top_threads functions
- neither was correct
    - fetch_top_threads doesn't need to be a loop, it will be up to the
      application whether or not to load more results. This simplifies
      the function, which was sometimes returning more than one row for
      each thread_id anyway
    - fetch_catalog is now fairly performant, and fetches all relevant
      information
2023-10-26 18:19:32 -04:00