Commit graph

24 commits

Author SHA1 Message Date
Las Zenow
1536d97d8d Update to use pg/v10 2020-11-30 19:03:31 +00:00
Las Zenow
3399d0ef1b Do the count stimated
The DB is being overloaded by the qaueries
2020-06-24 11:07:54 +00:00
Las Zenow
a1ee320eba Add hashes for each book
Check if the uploaded book is already in the library
2020-05-03 10:14:50 +00:00
Las Zenow
383214ee19 Add search by date 2020-03-23 11:35:10 +00:00
Las Zenow
defaa2ae0b Update to pg v9 2019-11-06 06:53:41 +00:00
Las Zenow
5bcb08ef37 Don't use count estimate in postgresql
It produces random numbers that misslead the code.
2018-11-19 02:44:34 +00:00
Las Zenow
e1c5399a95 Estimate for more than 10,000 books 2018-07-02 10:58:54 +00:00
Las Zenow
c9b967a2ef Create tables, indexes, functions and triggers programatically 2017-09-21 21:05:06 +00:00
Las Zenow
26894f1438 Add support for quotes in search strings
* Closes: #33
2017-09-20 19:55:37 +00:00
Las Zenow
d40dc21627 Cache front page results 2017-06-05 23:03:24 +00:00
Las Zenow
2562f4c2c8 Fix metadata editor
Convert slices to postgres arrays.
2017-05-30 23:28:42 +00:00
Las Zenow
71d975c2f7 Keep count of downladed/viewed books 2017-05-30 22:10:21 +00:00
Las Zenow
68ffe6cf5b Use all langs for the tsquery
Close: #28
2017-05-29 12:38:35 +00:00
Las Zenow
d0670c0b62 Cache the full book counter 2017-05-21 11:07:13 +00:00
Las Zenow
e0854aa001 Using master pg library 2017-05-21 11:05:37 +00:00
Las Zenow
42ccf52718 trigram indexes 2017-05-21 11:02:35 +00:00
Las Zenow
15e1802a00 Fix tags updater and query parser 2017-05-21 10:56:52 +00:00
Las Zenow
18baa2938b Remove statistics and add frequent tags in memory 2017-05-21 10:55:53 +00:00
Las Zenow
52b9882be9 Convert Id to ID 2017-05-21 10:50:59 +00:00
Las Zenow
f12114c296 Deprecate bad quality flag 2017-05-21 10:47:02 +00:00
Las Zenow
7f9c172853 Rename author to authors and subject to tags 2017-05-21 10:47:00 +00:00
Las Zenow
e72de38725 [WIP] migration to psql
TODO:
[ ] stats
[ ] indexes
2017-05-21 10:44:43 +00:00
Las Zenow
8e82ee3702 Add search terms to the moderation page
* Closes: #22
2017-02-04 12:45:42 +00:00
Las Zenow
9d1f1ad5c0 Move all the code to a lib folder 2016-05-02 21:41:40 -04:00
Renamed from database/books.go (Browse further)