nhoening / gritttt-rss

Implements 'cancelled' sharing-features of Google Reader for the excellent open-source RSS-Reader TinyTiny-RSS: share any page on the web via a bookmarklet and show your shared items in a widget on any website you want. Also allow to import shared&starred articles from Google Reader.
gritttt-rss.nicolashoening.de
Other
48 stars 4 forks source link

PostgreSQL support for import.py #49

Closed tafryn closed 11 years ago

tafryn commented 11 years ago

Hello, Your starred/sharing import script produces SQL that's incompatible with PostgreSQL. The main issue is escaping quotes, both double and single, but there are some issues with booleans and dates as well. I've made some small changes to your script that allows it to produce PostgreSQL compatible output while still defaulting to MySQL.

-Tafryn

nhoening commented 11 years ago

Thanks. As far as I'm concerned, this looks good (I didn't run it on Postgres myself). We already had a ticket for Postgres support, btw (#37), where I'm not sure all issues have been addressed, so I'll l eave that open for now.