search

fossar / selfoss

multipurpose rss reader, live stream, mashup, aggregation web application
https://selfoss.aditu.de
GNU General Public License v3.0
2.38k stars 345 forks source link

daos: Avoid double quotes for string literals #1489

Closed jtojnar closed 4 months ago

jtojnar commented 4 months ago

SQLite, MySQL but not PostgreSQL support using double quotes for string literals in some places. This is generally considered a bad practice and SQLite recommends disabling the feature, which FreeBSD does, resulting in an error on startup:

no such column: table

Let’s fix the syntax to use ANSI SQL quoting style.

Fixes: #1488

netlify[bot] commented 4 months ago

Deploy Preview for selfoss canceled.

Name Link
Latest commit 7ba724ae8baeac886a6478f35621f915505ee87c
Latest deploy log https://app.netlify.com/sites/selfoss/deploys/6688fb30bab8190008390fd9