FreshRSS (Customized)/app/SQL, branch 1.7.0 Customized version of FreshRSS, a self-hosted RSS feed aggregator https://git.rdnlsmith.com/fresh-rss-custom/atom?h=1.7.0 2017-04-09T22:43:18+00:00 Fix DROP tables for deferred insertion 2017-04-09T22:43:18+00:00 Alexandre Alapetite alexandre@alapetite.fr 2017-04-09T22:43:18+00:00 urn:sha1:5d54e47ff4065167a07085df07a590372ac5d636 https://github.com/FreshRSS/FreshRSS/pull/1470 SQL index auto added 2017-03-26T20:08:17+00:00 Alexandre Alapetite alexandre@alapetite.fr 2017-03-26T20:08:17+00:00 urn:sha1:bc580c5905522143cb3d73a37641f7bf21225545 At the same time as the new temp table SQLite create index if not exists 2017-03-26T16:29:10+00:00 Alexandre Alapetite alexandre@alapetite.fr 2017-03-26T16:29:10+00:00 urn:sha1:a7064dc700f1a41129511866cb2fb36c522c0d6c More defered insertion. New SQL index 2017-03-26T12:07:06+00:00 Alexandre Alapetite alexandre@alapetite.fr 2017-03-26T12:07:06+00:00 urn:sha1:e956aee53d561fbdc11a78a50ad7cc041108e5b5 New index entry_feed_read_index TODO: Auto add this index to existing version Defered insertion MySQL bug 2017-03-26T00:41:08+00:00 Alexandre Alapetite alexandre@alapetite.fr 2017-03-26T00:41:08+00:00 urn:sha1:a20fd9db9f0ed0e27c65671bb10402ced10587b1 The update of cached values remains to be optimized Candidate implementation of defered insertion 2017-03-25T23:01:11+00:00 Alexandre Alapetite alexandre@alapetite.fr 2017-03-25T23:01:11+00:00 urn:sha1:22b41f3bfcbd5a54d59789c2cebfda6dc23b7dde https://github.com/FreshRSS/FreshRSS/issues/530 CLI option no-default-feeds 2016-10-24T18:29:08+00:00 Alexandre Alapetite alexandre@alapetite.fr 2016-10-24T18:29:08+00:00 urn:sha1:1182129ce5f07892afed190ffbb2ea4c7fc28967 https://github.com/FreshRSS/FreshRSS/issues/1095 PostgreSQL workaround for SERIAL strange behaviour 2016-10-15T21:09:21+00:00 Alexandre Alapetite alexandre@alapetite.fr 2016-10-15T21:09:21+00:00 urn:sha1:f1eaf02a0c323c401950bca6189a795915193c3a http://stackoverflow.com/questions/18389537/does-postgresql-serial-work-differently SQL DROP TABLE 2016-10-15T18:01:48+00:00 Alexandre Alapetite alexandre@alapetite.fr 2016-10-15T18:01:48+00:00 urn:sha1:34e38e3a97814eae27174839dd04bcf79c3d62b5 https://github.com/FreshRSS/FreshRSS/issues/1320 PostgreSQL emulate "INSERT IGNORE" 2016-10-14T22:49:10+00:00 Alexandre Alapetite alexandre@alapetite.fr 2016-10-14T22:49:10+00:00 urn:sha1:c24d60372ad59932638964e37cb84ba0de8b1661 Would have liked to use UPSERT, but it is first available from PostgreSQL 9.5.