how to export starred items?

sg

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?

Sheldon
Hi,

Hi,

unfortunately there is no such option in QuiteRSS.

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

https://portableapps.com/apps/development/sqlite_database_browser_portable

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,

Sheldon

 

sg
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 sqlite-query.py

(vi or any other editor of course)

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

#!/usr/bin/python3
 
import sqlite3
from sqlite3 import Error
 
 
def create_connection(db_file):
    try:
        conn = sqlite3.connect(db_file)
        return conn
    except Error as e:
        print(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:
        print(row)
 
 
def main():
    database = "/home/USERNAME/.local/share/QuiteRss/QuiteRss/feeds.db"
 
    # create a database connection
    conn = create_connection(database)
    with conn:
        select_all_tasks(conn)
 
 
if __name__ == '__main__':
    main()
 

save and exit

Now we're back in the terminal.

chmod +x sqlite-query.py

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

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