Conversation
Favour PostgreSQL, based on tests such as: FreshRSS#5648 (comment) FreshRSS#5707 SQLite is generally very fine, although with the challenge that the DB model cannot easily be updated https://www.sqlite.org/lang_altertable.html#why_alter_table_is_such_a_problem_for_sqlite (We should ship a command-line update mechanism) I have verified that FreshRSS still works with `mysql:5.5.62` https://hub.docker.com/layers/library/mysql/5.5.62/images/sha256-d404d78aa797c87c255e5ae2beb5d8d0e4d095f930b1f20dc208eaa957477b74?context=explore
Frenzie
left a comment
Frenzie
left a comment
There was a problem hiding this comment.
What's that about SQLite being built into PHP?
I am not sure how to formulate that better. It does not require installing anything else like a DB server, as the support comes from PHP (with the appropriate extensions) itself. |
|
Maybe something more in the vein of easy setup? |
|
It is not even easy setup, it is no setup at all :-) |
|
Eh, you have to apt/apk install it and you have to set it up in FreshRSS. :-) |
Right, indeed for the package. I was more thinking from the Docker perspective. I was curious of how much that package was adding (on apt install php-sqlite3
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
php8.2-sqlite3
The following NEW packages will be installed:
php-sqlite3 php8.2-sqlite3
0 upgraded, 2 newly installed, 0 to remove and 0 not upgraded.
Need to get 33.8 kB of archives.
After this operation, 145 kB of additional disk space will be used.Regarding the setup in FreshRSS, there is nothing to do (besides picking SQLite, of course) :-)
|
Then maybe "included in Docker image"?
That's what I meant, yes. :-D |
|
I have changed a bit the explanations. SQLite being included in our Docker images is also mentioned in the Docker documentation, so that is probably enough. |
2 participants
Favour PostgreSQL, based on tests such as:
#5648 (comment)
#5707
SQLite is generally very fine, although with the challenge that the DB model cannot easily be updated https://www.sqlite.org/lang_altertable.html#why_alter_table_is_such_a_problem_for_sqlite
(We should ship a command-line update mechanism)
I have verified that FreshRSS still works with
mysql:5.5.62https://hub.docker.com/layers/library/mysql/5.5.62/images/sha256-d404d78aa797c87c255e5ae2beb5d8d0e4d095f930b1f20dc208eaa957477b74?context=explore