<feed xmlns='http://www.w3.org/2005/Atom'>
<title>FreshRSS (Customized)/app/Models/StatsDAOSQLite.php, branch 1.20.2</title>
<subtitle>Customized version of FreshRSS, a self-hosted RSS feed aggregator</subtitle>
<id>https://git.rdnlsmith.com/fresh-rss-custom/atom?h=1.20.2</id>
<link rel='self' href='https://git.rdnlsmith.com/fresh-rss-custom/atom?h=1.20.2'/>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/'/>
<updated>2021-10-16T10:00:07+00:00</updated>
<entry>
<title>Stats: replace flotr2 with chart.js (#3858)</title>
<updated>2021-10-16T10:00:07+00:00</updated>
<author>
<name>maTh</name>
<email>math-home@web.de</email>
</author>
<published>2021-10-16T10:00:07+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=02641de32ecc6e0e4fd9de030399728080b6ed41'/>
<id>urn:sha1:02641de32ecc6e0e4fd9de030399728080b6ed41</id>
<content type='text'>
* 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 &lt;alexandre@alapetite.fr&gt;</content>
</entry>
<entry>
<title>PDO refactoring for code simplification (#2522)</title>
<updated>2019-09-29T14:22:50+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2019-09-29T14:22:50+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=e3e5954394f4523850c78e80e496f1b916622677'/>
<id>urn:sha1:e3e5954394f4523850c78e80e496f1b916622677</id>
<content type='text'>
* 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 `-&gt;bd` to `-&gt;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-&gt;exec() to run multiple statements

* Disallow changing the name of the default category

https://github.com/FreshRSS/FreshRSS/pull/2522#discussion_r326967724
</content>
</entry>
<entry>
<title>Fix SQLite</title>
<updated>2016-09-29T21:36:25+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2016-09-29T21:36:25+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=c35111fe53ba2081abc735cb61e83987ade5ce86'/>
<id>urn:sha1:c35111fe53ba2081abc735cb61e83987ade5ce86</id>
<content type='text'>
</content>
</entry>
<entry>
<title>A bit more PostgreSQL</title>
<updated>2016-09-27T21:35:39+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2016-09-27T21:35:39+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=dbc68590da1d95c249f780e2d3ff4707f6f504e9'/>
<id>urn:sha1:dbc68590da1d95c249f780e2d3ff4707f6f504e9</id>
<content type='text'>
Simplified statistics https://github.com/FreshRSS/FreshRSS/pull/1250
</content>
</entry>
<entry>
<title>Simplify SQL in statistics</title>
<updated>2016-09-11T09:24:32+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2016-09-11T09:24:32+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=ccb56bcbf3ef69228ae4147a76cf3059f519bbf3'/>
<id>urn:sha1:ccb56bcbf3ef69228ae4147a76cf3059f519bbf3</id>
<content type='text'>
Reduce the use of product-specific date functions. Improve performances.
Remove redundant functions.
</content>
</entry>
<entry>
<title>CSP for statistics</title>
<updated>2016-02-21T16:26:37+00:00</updated>
<author>
<name>Alexandre Alapetite</name>
<email>alexandre@alapetite.fr</email>
</author>
<published>2016-02-21T16:26:37+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=264d05297c72e87b114a8e930db7eae7affe5690'/>
<id>urn:sha1:264d05297c72e87b114a8e930db7eae7affe5690</id>
<content type='text'>
https://github.com/FreshRSS/FreshRSS/issues/1075
</content>
</entry>
<entry>
<title>Add an average per day for the 30 day period</title>
<updated>2014-09-29T22:54:03+00:00</updated>
<author>
<name>Alexis Degrugillier</name>
<email>github@ainw.org</email>
</author>
<published>2014-09-29T22:54:03+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=cd88414abcffd94cfce933cf578ecc640b691381'/>
<id>urn:sha1:cd88414abcffd94cfce933cf578ecc640b691381</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Fix repartition stats with 0 or 1 article.</title>
<updated>2014-09-19T08:37:29+00:00</updated>
<author>
<name>Marien Fressinaud</name>
<email>dev@marienfressinaud.fr</email>
</author>
<published>2014-09-19T08:37:29+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=8731de5c3ad4eea8ae30d1f6435c569ed31b8828'/>
<id>urn:sha1:8731de5c3ad4eea8ae30d1f6435c569ed31b8828</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add repartition statistic support in Sqlite</title>
<updated>2014-07-25T02:57:31+00:00</updated>
<author>
<name>Alexis Degrugillier</name>
<email>github@ainw.org</email>
</author>
<published>2014-07-25T02:57:31+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=aa317eb2948b5caa5472bf307099efe850f7b314'/>
<id>urn:sha1:aa317eb2948b5caa5472bf307099efe850f7b314</id>
<content type='text'>
</content>
</entry>
<entry>
<title>Add statistics support for Sqlite</title>
<updated>2014-07-19T00:35:03+00:00</updated>
<author>
<name>Alexis Degrugillier</name>
<email>github@ainw.org</email>
</author>
<published>2014-07-19T00:35:03+00:00</published>
<link rel='alternate' type='text/html' href='https://git.rdnlsmith.com/fresh-rss-custom/commit/?id=68c0a827d221eeb398774d558f3d23b6e1c9e76c'/>
<id>urn:sha1:68c0a827d221eeb398774d558f3d23b6e1c9e76c</id>
<content type='text'>
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
</content>
</entry>
</feed>
