SQLite possibility (enhancement)

[GLLM]

Hello !

I'll keep a close eye to this selfhosted rss aggregator, as it looks really nice & features-packed :)

However, I'd really love to use SQLite instead of MySQL ... (TBH, I will only really start using it if it does work with SQLite)

Anyway, congartulations for the great job :)

Cya, G_LL_M

[stephanediondev]

Hi

I made a test with sqlite I found a first annoying problem date_add + interval (to manage timezone) not supported

Of course I can move this sum to php I'll look

[stephanediondev]

I have a question

what is the most common with projects using sqlite? a ready to use file, or sql file to load (you have a management interface for that?)

Another problem I found Since my first try with sqlite, now I use "IF" function and it's not supported in sqlite

IF(sub.sub_title IS NOT NULL, sub.sub_title, fed.fed_title) AS ref

I can also move this to php

[GLLM]

Hello @project29k,

I'v been using the following rss aggregator https://github.com/SSilence/selfoss for quite some time, but the dev is a bit slow over there ...

You can choose SQLite ... (as well as MySQL) so it might be of help to you.

Regarding the ready to use file or SQM file to load. I'm not sure to understand the point, so I'll answer what I've understood. When you install Selfoss, you setup a config file, which is then used to create the SQLite file. There is no need to launch SQL instructions to create the DB, all is done (from the php I believe).

For the IF instructions, I do not know how selfoss dealt with it :(

I hope this helped :)

GLLM

[stephanediondev]

Ok

I made a first sqlite compliant version I remove only some statistic blocks (by time of day, day of week...)

You can configure manually (a setup is the next step)

/application/config/database.php $db['default']['hostname'] = 'sqlite:application/database/readerself.sqlite'; $db['default']['dbdriver'] = 'pdo';

[GLLM]

I just tried it, it opened properly ... I'll test this :)