54 Commits

Author SHA1 Message Date
seger672 1ed7e6a5f6 Optimize tag cloud query
Still does a sort that ought to be indexable, but fixing that would be considerably more work.
2021-01-06 18:20:30 +00:00
perception af14df4238 Document environment variables 2021-01-06 01:53:56 -08:00
perception a199071063 Add word 'periodically' 2021-01-06 01:49:32 -08:00
perception 45df1554b0 Drop old index too 2021-01-06 01:18:56 -08:00
perception f80a820a19 Refine info on downloading articles 2021-01-06 01:15:17 -08:00
perception 21cfc1b157 Use env var P to download less 2021-01-06 01:14:34 -08:00
perception 502e9240fe Rename package to dss 2021-01-04 20:24:20 -08:00
perception cd0d1cfceb Update README w/ more db info 2021-01-02 22:53:52 -08:00
perception 6158f9b703 Prefill search input with current query 2021-01-02 21:40:28 -08:00
perception 53cf904437 Add migration for improved index for article table 2021-01-02 21:39:33 -08:00
perception 705fe1feaa Factor out _article-link ejs partial
Preparation to make article link clickable.
2021-01-02 15:50:49 -08:00
perception fb3a078b7c Redo the README w/ installation instructions 2020-12-28 10:02:12 -08:00
perception c7efe96825 Try to prevent search queries from crashing 2020-12-28 09:44:25 -08:00
perception e86b1548fc Use article.id as a tie-breaker when sorting 2020-12-28 08:24:52 -08:00
perception bd427891df Reverse order of years 2020-12-26 19:54:44 -08:00
perception 4b3dc5ac3f Group by actual columns rather than calculated value 2020-12-26 17:00:08 -08:00
perception a064d70f7a Optimize archive queries 2020-12-26 16:44:43 -08:00
perception 8b11403e0d Add schema migration for optimizing archive queries 2020-12-26 16:44:18 -08:00
perception 5cb84a8737 Preload a static list of top tags on home page 2020-12-23 14:16:04 -08:00
perception 58ee7fe140 Make headers smaller 2020-12-23 08:39:27 -08:00
perception d762e879e8 Use ds.db() 2020-12-23 08:39:11 -08:00
perception 25b3283dc3 Ignore *.db instead of just main.db 2020-12-22 16:56:45 -08:00
perception 7f32002fa5 Use the clean CSS class 2020-12-22 16:56:21 -08:00
perception c015ae06df Add routes and templates for tag pages 2020-12-22 16:56:01 -08:00
perception 1af8847989 Tweak category pages 2020-12-22 16:55:32 -08:00
perception 0e39a2e401 Add routes and templates for archives 2020-12-22 16:54:57 -08:00
perception 15f29e1b8f Use ds.db() 2020-12-22 16:54:01 -08:00
perception 763356956b Add dotenv initialization 2020-12-22 16:53:23 -08:00
perception c304f7ade9 Add options -k and -p 2020-12-22 16:52:52 -08:00
perception 6e754be33b Reset sections list to original form 2020-12-22 16:48:04 -08:00
perception 49cffd9b6f Fetch tag and category info from article (not RSS) 2020-12-22 16:47:33 -08:00
perception a925aa3bc3 Add more tag-related functions 2020-12-22 16:46:57 -08:00
perception b99eb988ba Rename some methods and centralize db instantiation 2020-12-22 16:45:36 -08:00
perception 05df97caaf Initialize global.db in repl 2020-12-22 16:43:22 -08:00
perception 81530aa496 Fill all 12 columns 2020-12-22 14:54:24 -08:00
perception 4269fedf50 Tweak CSS 2020-12-22 14:54:07 -08:00
perception b28754cbf2 Add handler and template for category page 2020-12-21 22:30:55 -08:00
perception 54be576a8c Generalize pagination to work with things other than search 2020-12-21 22:30:14 -08:00
perception c5ebcef2c8 Add routes and templates for archive section 2020-12-21 21:23:43 -08:00
perception 595f814025 Use _search partial 2020-12-21 21:23:18 -08:00
perception 8fea615536 Show archive, catgories, and tags sections 2020-12-21 21:22:52 -08:00
perception c0a69678db Embellish home page 2020-12-21 21:22:27 -08:00
perception 5cd5eac2c8 Create a partial for the search box 2020-12-21 21:21:45 -08:00
perception effdc105d7 Add custom CSS 2020-12-21 21:21:13 -08:00
perception fac3285ac4 Add functions for homepage and archive section data 2020-12-21 16:43:50 -08:00
perception 262521313a Add ability to skip ahead 2020-12-21 16:43:08 -08:00
perception d8a3d16c53 Add qs and ucfirst 2020-12-21 16:42:32 -08:00
perception db71cbc2bd Add routes for Daily Stormer Search 2020-12-20 19:13:23 -08:00
perception 18d1d7490a Add entrypoint for micro web service 2020-12-20 19:12:44 -08:00
perception f611caef58 Setup EJS template rendering 2020-12-20 19:12:12 -08:00