Keine Beschreibung

jherve 1cba153024 Create backend outside of Storage.__init__		vor 1 Jahr
src	1cba153024 Create backend outside of Storage.__init__	vor 1 Jahr
static	3501a02749 Add logo information and display it in the UI	vor 1 Jahr
templates	823e4ba58d Add viewport meta tag for mobile display	vor 1 Jahr
tests	1c91c4bfe6 Initial commit	vor 1 Jahr
.gitignore	d51ff03bb2 Switch to Annoy for vector search/indexing	vor 1 Jahr
README.md	7e076bd9d7 Add a note about a bug	vor 1 Jahr
config.py	caa854cba8 Format some file	vor 1 Jahr
pyproject.toml	cf34257719 Extend duration display to similar articles	vor 1 Jahr
requirements-dev.lock	cf34257719 Extend duration display to similar articles	vor 1 Jahr
requirements-embeddings.lock	5d907e27a8 Add a requirements file for embeddings	vor 1 Jahr
requirements.lock	cf34257719 Extend duration display to similar articles	vor 1 Jahr
settings.toml	207cc110db Move database URL to secrets	vor 1 Jahr

de_quoi_parle_le_monde

Bug

In the featured_article_snapshot_id view, the field featured_article_snapshot_id is taken as if it was unique by row, but it is not.

This can be easily checked with this query :

SELECT * FROM (
    SELECT featured_article_snapshot_id, json_group_array(snapshot_id), COUNT(*) as count
    FROM snapshot_apparitions
    WHERE is_main -- Not required
    GROUP BY featured_article_snapshot_id
)
WHERE count > 1

Among other things it leads to "deadends" while browsing the UI, likely because the timestamp search and time diff relies on this false assumption.

README.md

de_quoi_parle_le_monde

Bug