Customized version of FreshRSS, a self-hosted RSS feed aggregator https://git.rdnlsmith.com/fresh-rss-custom/atom?h=1.23.1 2023-12-18T16:59:16+00:00 2023-12-18T16:59:16+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-12-18T16:59:16+00:00 urn:sha1:a80a5f48a16e7d232168a7aaa68e9a1804235ce1 * Pass PHPStan level 8 And prepare for PHPStan level 9 https://phpstan.org/user-guide/rule-levels * Revert wrong replace in comment * Fix PHPStan level 8 * Update PHPStan and other dev dependencies * Remove obsolete comment * noVariableVariables and towards bleedingEdge https://github.com/phpstan/phpstan-strict-rules https://phpstan.org/blog/what-is-bleeding-edge * More bleedingEdge * A bit more PHPStan level 9 * More PHPStan level 9 * Prepare for booleansInConditions Ignore int and null * Revert wrong line * More fixes * Fix keep_max_n_unread * Stricter attribute functions * Stricter callHooks and more PHPStan level 9 * More typing * A tiny more 2023-12-03T18:52:02+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-12-03T18:52:02+00:00 urn:sha1:f0d4f2762d2b74eeadf2fb64ff83039b5cc16c26 * Rework keepmax fix https://github.com/FreshRSS/FreshRSS/issues/5702 fix https://github.com/FreshRSS/FreshRSS/issues/5870 * More WIP * Minor progress * Progress * Beta * Improved debug message * Revert noCommit * Fix variable reset * Remove debug syslogs 2023-11-16T21:43:00+00:00 Luc SANCHEZ 4697568+ColonelMoutarde@users.noreply.github.com 2023-11-16T21:43:00+00:00 urn:sha1:30c7a61a9b410f023c56ef19b9389a61647d8768 * Little's optimisations and booleans in conditions * Apply strict type * Apply strict type * Apply strict type * Fix multiple bugs with PHP 8.2 and 8.3 * Many declares missing, more errors fixed * Apply strict type * Another approach * Stronger typing for Minz_Session * Fix case of SQLite --------- Co-authored-by: Luc <sanchezluc+freshrss@gmail.com> Co-authored-by: Alexandre Alapetite <alexandre@alapetite.fr> 2023-11-08T19:23:54+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-11-08T19:23:54+00:00 urn:sha1:348028a29043b7d1d0f80544c44f0454b2c375c3 * New feature important feeds * Fix PHPStan * Initial style for important feeds + keep unread * Change UI order * Count important unread * Never mark as read important feeds during scroll * Fix i18n conf.iew.normal regression * Fix reader view * More fix reader view * Create important.svg * Fix title * Fix counter * Account for important during mark-all-as-read * Fix underline colour * 📌 * Changelog --------- Co-authored-by: math-gh <> Co-authored-by: maTh <1645099+math-GH@users.noreply.github.com> 2023-11-07T12:15:48+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-11-07T12:15:48+00:00 urn:sha1:85345559c7c66787ad9474da8a63de24e6484843 https://php.net/pdo.errorinfo has slightly changed signature 2023-10-31T01:01:50+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-10-31T01:01:50+00:00 urn:sha1:ad8bae5acadcda0291c3a6ca579303dbd4053f04 * SQL auto-update field length Follow-up of https://github.com/FreshRSS/FreshRSS/pull/5756 Only for PostgreSQL and MySQL / MariaDB. Not possible for SQLite * Account for MySQL 65535 Partial revert of https://github.com/FreshRSS/FreshRSS/pull/5756 > The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead. 2023-10-30T20:10:09+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-10-30T20:10:09+00:00 urn:sha1:21a279179a5e496082f4e43c5a2a5e10d90c0bdb * Ready for year 2038 Fix https://github.com/FreshRSS/FreshRSS/discussions/5569 Requires PHP on a 64-bit platform to take advantage of it. https://en.wikipedia.org/wiki/Year_2038_problem * Allows dates past 2038 Rework of https://github.com/FreshRSS/FreshRSS/pull/3259 https://github.com/FreshRSS/FreshRSS/issues/3258 * Auto alter columns * Changelog 2023-10-30T19:47:50+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-10-30T19:47:50+00:00 urn:sha1:0324df6f889f18500cc8d201fdc2845f3e4d1acf * SQL increase length of VARCHAR fields Increase length of all fields, keeping the limits for: * Unique indexes on UTF-8: 191 bytes for MySQL; * Unique indexes on ASCII: 767 bytes for MySQL; * Max URL for external tools: 32768 characters; * Max VARCHAR: 65535 bytes for MySQL; Follow-up of https://github.com/FreshRSS/FreshRSS/pull/5038 Fix https://github.com/FreshRSS/FreshRSS/issues/4986 * Fix length test 2023-10-30T19:47:27+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-10-30T19:47:27+00:00 urn:sha1:06d00995049db9c7b915f67cfd4a5708aace458f * Require PHP 7.4+ https://github.com/FreshRSS/FreshRSS/discussions/5474 * Update Docker oldest Alpine 3.13 with PHP 7.4.26 * Add missing packets to Docker oldest * Update to typed properties https://php.net/migration74.new-features#migration74.new-features.core.typed-properties * More types 2023-09-12T11:44:17+00:00 Alexandre Alapetite alexandre@alapetite.fr 2023-09-12T11:44:17+00:00 urn:sha1:0bf33abac8cf83dfece4ccd7f3146c373effae2c * SQL: Same updateCacheUnreads for all DBs Use same SQL update request for MySQL / MariaDB than the one we already used for PostgreSQL / SQLite (i.e. using a sub-query). Testing on a DB of 688MB with 270k entries, 199 feeds, 19 categories, using MySQL 8.1.0. The new SQL update using a sub-query took in average 0.02s, while the old SQL update using a join took in average 0.05s. SQL cache was properly invalidated between each run. The new SQL request is thus about twice faster. Another advantage of the SQL update using a sub-query is that it works identically in PostgreSQL, SQLite, MariaDB, MySQL, so we do need different versions anymore. Contributes to https://github.com/FreshRSS/FreshRSS/issues/5008#issuecomment-1709755370 * Force USE INDEX * Use same SQL methods also for markReadEntries, markReadCat