Las Zenow
|
1536d97d8d
|
Update to use pg/v10
|
2020-11-30 19:03:31 +00:00 |
|
Las Zenow
|
c82fd09e0d
|
Optimize submission deletion
The nested select was producing a sequential lookup into the books
table, that took hours to resolv.
|
2020-11-18 11:52:26 +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
|
3e3ba1bd7e
|
Merge remote-tracking branch 'mr/7'
|
2019-12-23 19:11:03 +00:00 |
|
Las Zenow
|
25bed10456
|
Merge remote-tracking branch 'mr/8'
|
2019-12-23 19:09:13 +00:00 |
|
endangered
|
8ffec7510a
|
Fix getVisitedBooks and getDownloadedBooks queries, preventing persistent error every five minutes when front page data is updated
|
2019-11-30 10:55:26 +09:30 |
|
endangered
|
f836f40f89
|
Provide command line variables for initializing an admin user. Previously to get admin access on a fresh install I had to create a user in the web interface (to make sure the password hash/salt is properly setup) then manually change the role in the database to 'admin' using a postgresql client. This was a pain in the ass, and I think there really needs to be an easy way to create the admin user on the initial deployment. This solution fixes this, and adds documentation to the README file on how to use those variables.
|
2019-11-25 06:58:44 +09:30 |
|
endangered
|
9ea77c095f
|
Submission uploads (lib.uploadRequest.processFile) generate an error: null value in column active violates not-null constraint. This sets a default value on this column of false and columns in the visits table to zero which also have not-null constraints, ensuring errors like these are prevented
|
2019-11-25 06:15:28 +09:30 |
|
Las Zenow
|
defaa2ae0b
|
Update to pg v9
|
2019-11-06 06:53:41 +00:00 |
|
Las Zenow
|
cea8d21105
|
Clean up old submissions
|
2019-03-05 21:07:34 +00:00 |
|
Las Zenow
|
60379ba1ef
|
Be able to list users submisions
- Closes: #45
|
2019-03-05 21:07:34 +00:00 |
|
Las Zenow
|
00d21d8340
|
Treat uses as case-insensitive
|
2018-12-24 10:13:58 +00:00 |
|
Las Zenow
|
8b996803c8
|
Add download counter on each book
* Closes: #40
|
2018-11-19 03:14:26 +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
|
dffd67a9fe
|
Improve usability of the user registration
|
2018-04-09 20:52:40 +00:00 |
|
Las Zenow
|
a40b5ac534
|
Clean up a bit the add book to list interface
|
2018-04-09 19:00:06 +00:00 |
|
Las Zenow
|
1ab2fd882c
|
Add indexes to list entries
|
2018-04-09 10:51:20 +00:00 |
|
Las Zenow
|
46762ea17b
|
Add basic html/rss support for book lists
|
2018-04-09 09:49:30 +00:00 |
|
Las Zenow
|
c0a70a18e1
|
Add book list support in the database
|
2018-04-09 00:15:58 +00:00 |
|
Las Zenow
|
f2b393a453
|
Make the tests pass
|
2018-04-08 22:11:19 +00:00 |
|
Las Zenow
|
6f906ccae4
|
Add user management interface
|
2018-04-08 10:55:30 +00:00 |
|
Las Zenow
|
6cd5b1bc5e
|
Register the date of the last login
|
2018-04-08 08:39:10 +00:00 |
|
Las Zenow
|
5315870dbd
|
Be more strict validating user names
|
2018-04-08 08:20:18 +00:00 |
|
Las Zenow
|
8bcff3c826
|
Add comments to submissions
|
2018-04-07 23:50:01 +00:00 |
|
Las Zenow
|
de58f0251e
|
Fix setting password
We were not acting on the error returning, and the sql sintax was wrong.
|
2018-02-22 09:57:37 +00:00 |
|
Las Zenow
|
c9b967a2ef
|
Create tables, indexes, functions and triggers programatically
|
2017-09-21 21:05:06 +00:00 |
|
Las Zenow
|
cc12981a50
|
Add submission page for uploads
* Closes: #13
|
2017-09-21 12:09:04 +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
|
83ab1b461d
|
Expose AddRaw[User|News] for scripting
|
2017-05-21 22:48:43 +00:00 |
|
Las Zenow
|
d0670c0b62
|
Cache the full book counter
|
2017-05-21 11:07:13 +00:00 |
|
Las Zenow
|
0c3385200e
|
Fix tag indexing
|
2017-05-21 11:05:39 +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
|
b62b303995
|
Helper functions for the migration scripts
|
2017-05-21 10:59:31 +00:00 |
|
Las Zenow
|
fd0b9cf53d
|
Use the right date type for news
|
2017-05-21 10:58:34 +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
|
e1bd235785
|
Implement Read Only mode
|
2017-05-21 10:16:51 +00:00 |
|
Las Zenow
|
8e82ee3702
|
Add search terms to the moderation page
* Closes: #22
|
2017-02-04 12:45:42 +00:00 |
|