aboutsummaryrefslogtreecommitdiff
path: root/app/Models/StatsDAOSQLite.php
AgeCommit message (Collapse)Author
2021-10-16Stats: replace flotr2 with chart.js (#3858)Gravatar maTh
* include Chart.js * page: main statistics. Flotr.js replaced with Chart.js * main stats + repartition * Delete: repartition.js + stats.js * delete flotr2 * add libs in README * polish * code polish * fixed amount of week days and months * added manget link for LibreJS * added: @license-end * phpcbf + jshint formatting * delete old code * fix stats * fix Comments * finally I found the issue and fixed its best * fix the month stats * Whitespace fixes * Remove flotr2 * Rename to chart.min.js * Remove console.log Co-authored-by: Alexandre Alapetite <alexandre@alapetite.fr>
2019-09-29PDO refactoring for code simplification (#2522)Gravatar Alexandre Alapetite
* PDO refactor * Automatic prefix when using the syntax `_tableName` * Uniformity: MySQL is now PDO::ATTR_EMULATE_PREPARES = false just like SQLite and PostgreSQL, with consequences such as only one statement per query * Use PDO methods exec(), query(), prepare() + execute() in a more efficient way * Remove auto-update SQL code for versions older than FreshRSS 1.5 (3 years old) * The name of the default category is set in PHP instead of in the DB (simplies SQL and allows changing the name according to the FreshRSS language) * Rename `->bd` to `->pdo` (less of a frenshism, and more informative) * Fix some requests, which were not compatible with MySQL prepared statements * Whitespace * Fix syntax for PostgreSQL sequences + MySQL install * Minor formatting * Fix lastInsertId for PostgreSQL * Use PHP 5.6+ const Take advantage of https://github.com/FreshRSS/FreshRSS/pull/2527 https://www.php.net/manual/en/migration56.new-features.php * A bit of forgotten PHP 5.6 simplification for cURL * Forgotten $s * Mini fix custom user config https://github.com/FreshRSS/FreshRSS/pull/2490/files#r326290346 * More work on install.php but not finished * install.php working * More cleaning of PDO in install * Even more simplification Take advantage of PDO->exec() to run multiple statements * Disallow changing the name of the default category https://github.com/FreshRSS/FreshRSS/pull/2522#discussion_r326967724
2016-09-29Fix SQLiteGravatar Alexandre Alapetite
2016-09-27A bit more PostgreSQLGravatar Alexandre Alapetite
Simplified statistics https://github.com/FreshRSS/FreshRSS/pull/1250
2016-09-11Simplify SQL in statisticsGravatar Alexandre Alapetite
Reduce the use of product-specific date functions. Improve performances. Remove redundant functions.
2016-02-21CSP for statisticsGravatar Alexandre Alapetite
https://github.com/FreshRSS/FreshRSS/issues/1075
2014-09-29Add an average per day for the 30 day periodGravatar Alexis Degrugillier
2014-09-19Fix repartition stats with 0 or 1 article.Gravatar Marien Fressinaud
2014-07-24Add repartition statistic support in SqliteGravatar Alexis Degrugillier
2014-07-18Add statistics support for SqliteGravatar Alexis Degrugillier
Add statistics support for Sqlite by tweeking one query and rewrite an other. The rewrite implied a complete refactor of the MySql query as well. Now the code is more flexible and make less queries to the database. See #527
2014-07-06Prepare statistics for SQLiteGravatar Alexandre Alapetite
Temporarily disable 30-day statistics for SQLite https://github.com/marienfressinaud/FreshRSS/issues/100 https://github.com/marienfressinaud/FreshRSS/issues/90
generated by cgit v1.2.3 (git 2.39.1) at 2026-02-11 01:46:06 +0000