summaryrefslogtreecommitdiffstats
path: root/config (follow)
AgeCommit message (Collapse)Author
2022-01-25config: remove note about QUIC disabled at GoogleSamantaz Fox
The situation is back to normal.
2022-01-22Specify the public schema for public videosTony Finn
Unlike the other migrations, this one uses a bare table name to specify the table. This means it looks in the default search path. Unfortunately, the out of box search path is: 1. Schema with the same name as the user 2. Public Because of this, if a schema exists with the same name as the DB user, the playlist_videos table will get created in _that_ schema, rather than the public schema, and then the grant statement will fail with an error like below if check_table is enabled as it keeps trying to create the table but failing on the grant statement: ``` 2022-01-22 02:27:42 UTC [info] check_table: check_table: CREATE TABLE playlist_videos Unhandled exception: relation "public.playlist_videos" does not exist (PQ::PQError) from /usr/share/crystal/src/primitives.cr:266:3 in 'handle_error' from lib/pg/src/pq/connection.cr:184:9 in 'handle_async_frames' from lib/pg/src/pq/connection.cr:162:7 in 'read' from lib/pg/src/pq/query.cr:53:14 in 'exec_all' from lib/db/src/db/database.cr:126:9 in '__crystal_main' from /usr/share/crystal/src/crystal/main.cr:110:5 in 'main' from src/env/__libc_start_main.c:94:2 in 'libc_start_main_stage2' 2022-01-22 02:27:43 UTC [info] check_table: check_table: CREATE TABLE playlist_videos Unhandled exception: relation "public.playlist_videos" does not exist (PQ::PQError) from /usr/share/crystal/src/primitives.cr:266:3 in 'handle_error' from lib/pg/src/pq/connection.cr:184:9 in 'handle_async_frames' from lib/pg/src/pq/connection.cr:162:7 in 'read' from lib/pg/src/pq/query.cr:53:14 in 'exec_all' from lib/db/src/db/database.cr:126:9 in '__crystal_main' from /usr/share/crystal/src/crystal/main.cr:110:5 in 'main' from src/env/__libc_start_main.c:94:2 in 'libc_start_main_stage2' ```
2022-01-09Create videos caching table as UNLOGGEDÉmilien Devos
2021-11-12Example config: Change 'use_quic' default valueSamantaz Fox
Related to commit a120f143d7bbe67379d0ff51e96b111661e1d385 Also point towards the Github issue.
2021-11-12Fix minor error in config.example.ymlSamantaz Fox
Update the "note" for `locale`
2021-10-21Feature Request: Localization for trending (reword region doc)Dmitry Sandalov
2021-10-21Feature Request: Localization for trending iv-org#331Dmitry Sandalov
2021-10-11variable postgres username and database name (#2451)JuniorJPDJ
2021-10-07Add config option to display source code URL in footer (#2450)Samantaz Fox
2021-10-03Merge pull request #1678 from Rjevski/idempotent-database-migrationssyeopite
Make DB migrations idempotent.
2021-07-16config_example.yaml: document all possible options (#2083)Samantaz Fox
Fixes https://github.com/iv-org/documentation/issues/46
2021-01-30Allow providing 12-Factor-style Database URL in configAndre Borie
2021-01-17Make migrations (mostly) idempotent.Andre Borie
2020-12-10Untrack config.yml (#1557)saltycrys
* Untrack config.yml `config/config.yml` has been untracked and moved to `config/config.example.yml`. The Dockerfile has been updated to copy all `config/config.*` files and to try to move `config/config.example.yml` to `config/config.yml`. If a user supplied `config/config.yml` exists it is not overwritten. * Update Dockerfile to use `shard.lock` * Fix tests
2020-06-15Add migration script for polymer redesignOmar Roth
2020-06-15Add support for polymer redesignOmar Roth
2020-04-14Move privacy type into playlists.sqlOmar Roth
2019-10-15Add support for custom playlistsOmar Roth
2019-08-29Provide db user in migrate-db-3646395.shSilvan Mosberger
2019-06-01Add 'needs_update' column for scheduling feed refreshOmar Roth
2019-05-30Add 'views' to channel_videosOmar Roth
2019-04-28Remove unnecessary indexOmar Roth
2019-04-15Add migrate script for annotations.sqlOmar Roth
2019-04-15Add config option to cache annotations from IAOmar Roth
2019-04-06Add role to psql scriptsOmar Roth
2019-03-25Remove 'crawl_threads', fix sleep in fibersOmar Roth
2019-03-23Rename migrate scriptsOmar Roth
2019-03-22Add support for premieres to search and feedOmar Roth
2019-03-22Add 'liveNow' to subscription feedOmar Roth
2019-03-03Set default value for 'subscribed' dateOmar Roth
2019-03-03Update pubsub to support lease_secondsOmar Roth
2019-03-03Add support for subscribing to channels via PubSubHubbubOmar Roth
2019-03-03Set domain to be nil by defaultOmar Roth
2019-02-11Update change index for channel_videos and add index for noncesOmar Roth
2019-02-10Fix typo in session_idsOmar Roth
2019-02-10Mark migrate-db-3646395.sh as executableOmar Roth
2019-02-10Add migrate script and update READMEOmar Roth
2019-02-10Store session_ids in separate tableOmar Roth
2019-02-09Rename migrate-db-e1aa1ce.sh to migrate-db-30e6d29.shOmar Roth
2019-02-09Add 'deleted' to channel infoOmar Roth
2019-01-20Move 'domain' into config.ymlOmar Roth
2018-11-25Update default configOmar Roth
2018-11-20Fix typo in nonces.sqlOmar Roth
2018-11-19Add 'expire' to filter invalid tokensOmar Roth
2018-11-19Add flat list of proxies for geo-bypassOmar Roth
2018-11-17Remember nonce to prevent replay attacksOmar Roth
2018-11-02Update SQLOmar Roth
2018-10-30Fix channel_videos schemaOmar Roth
2018-10-30Add length_seconds to channel_videosOmar Roth
2018-10-13Add author_thumbnail to '/api/v1/videos'Omar Roth
generated by cgit v1.2.3 (git 2.39.1) at 2025-12-16 23:47:12 +0000