Database evolution for a future version of Vienna (v4)

[barijaona]

This discussion has been opened to note possible improvements to database design.

These changes might include:

• more robust definition of smart folders (cf. Make folder selection in smart folders more robust #1906 discussion)
• per folder filters (All articles / Unread Articles / Flagged / Today…) instead of having the same filter apply everywhere: this would be especially useful for smart folders, where filtering might contradict the goal of the smart folder (issue View/Filter By is alway applied even in Smart Folder #218)
• per feed setting for "Mark updated articles as new"
• more presentation options for each feed (in addition to the current "Use Web Page for Articles" , something similar to Safari Reader View would be nice)

[Eitot]

• A separate table for enclosures, to allow for multiple enclosures per feed item (which Atom and JSONFeed support), optionally also supporting fields like MIME type and expected byte size (both of which may be provided by the feed, including RSS)
• "Modern" SQLite3 features like foreign keys to establish relationships between tables, e.g. to "cascade" row updates/deletions to dependent rows in other tables

[barijaona]

I would also like to be able to have different purge policies according to types of feeds.

[barijaona]

The UI would allow to define one or two alternative delays ( which could be slower or faster) to transfer read articles to Trash and assign them to some feeds.

[Eitot]

It would be nice to know which SQLite3 versions are supported so that we can take advantage of newer features. We could add this information to the wiki.

[barijaona]

Isn't this dictated by system's version ?
Running /usr/bin/sqlite3 --version returns:

• 3.19.3 on macOS 10.13.6 (High Sierra)
• 3.51.0 on macOS 26.2 (Tahoe)

[Eitot]

It is, but I want to know which macOS has which SQLite3 version. It helps to know that macOS 10.13.6 has 3.19.3.

I found the SDK headers on GitHub which contain sqlite3.h which has the SQLITE_VERSION constant.

macOS 10.13.0: 3.19.3
macOS 10.14.0: 3.24.0
macOS 10.15.0: 3.28.0
macOS 11.0: 3.32.3
macOS 12.0: 3.36.0
macOS 13.0: 3.39.5
macOS 14.0: 3.39.5
macOS 15.0: 3.43.2
macOS 26.0: 3.51.0