how to export starred items?

3 posts / 0 new
Last post

Hello, I'd like to export to some plain text file or anything i could read a list of my starred item's. There is quite a few of them and I wanted to share the links with a friend, but I can't find any such option. Is there one?



unfortunately there is no such option in QuiteRSS.

But you can f. e. get DB Browser for SQLIte Portable from

and open the file feeds.db using this tool.

Afterwards you run this query

select * from news where starred = 1 ..

to receive all starred news records.

You can easily mark the column of interest and copy/paste it to a text editor of your choice.

Kind regards,



Thank you!

Thank you!

For those interested in my slightly different solution, here's what I did and it worked for me.

Prerequisites: unix-like system with sed, vi, python3 installed; in my case debian.

In the terminal:


(vi or any other editor of course)

insert this code, adjust to your localization of the feeds.db file

import sqlite3
from sqlite3 import Error
def create_connection(db_file):
        conn = sqlite3.connect(db_file)
        return conn
    except Error as e:
    return None
def select_all_tasks(conn):
    cur = conn.cursor()
    cur.execute("select * from news where starred = 1")
    rows = cur.fetchall()
    for row in rows:
def main():
    database = "/home/USERNAME/.local/share/QuiteRss/QuiteRss/feeds.db"
    # create a database connection
    conn = create_connection(database)
    with conn:
if __name__ == '__main__':

save and exit

Now we're back in the terminal.

chmod +x

./ | sed "s/'.*\(http.*\)/\1/" | awk '{ print $3 }' | sed "s/,$//" > rss_favourites.txt

... and our favourites are in the rss_favourites.txt file.