Cologler

Results 44 comments of Cologler

SQLite has similar update stmt `insert or replace values (...)` to update single row without where query repr.

@benetherington @msiemens `update` equals `update or failed`, `upsert` equals `update or insert`, which is different. In most cases, I insert a `dict` into tinydb, then load as `Document` from tinydb,...

This issue is about what we can do after we load an entity from a tinydb, and `update` and `remove` are two basic operations of `CRUD`.

I created https://github.com/Cologler/exe2ps1-rust for this and used it for a couple of months. The problem is it will be removed by pyenv after calling `pip install ...`.

When two elements have the same key, if we query one from the database, it would be the first one; if we query all from the database and then map...

Even though the `chapter_id` of `history` has unique constraints, if the `(manga_id, url)` of `chapter` lacks unique constraints, then this is not unique: https://github.com/mihonapp/mihon/blob/c94d212ef471012990bfe02ba43044de476ab9cd/app/src/main/java/eu/kanade/tachiyomi/data/backup/restore/restorers/MangaRestorer.kt#L323C13-L323C106 This issue can lead to restoration...

https://github.com/bit101/quicksettings/blob/fa5d4482ddc1db56859967d078f6bf00c12c453e/quicksettings.js#L964-L968

It looks like the user `www-data` does not have permission to access `/root/.postgresql/postgresql.crt`.