Martti Malmi on Nostr: Local sqlite db by Kieran is great. So much better than IndexedDB. Iris & Snort can ...
Local sqlite db by
Kieran (npub1v0l…qj49) is great. So much better than IndexedDB. Iris & Snort can now store a lot of data locally, sync only what they don't already have (negentropy & nip-114) and eventually do p2p over webrtc. Works offline.
Iris now features a "for you" feed which uses the local database. It scores events by recentness, author favoriteness (top authors reacted by you) and amount of reactions from users who often react to the same notes as you.
Recentness is randomly weighted to occasionally show older events as well. Recent notes from all followed users are also mixed in.
Events are marked "seen" when they've been in the viewport for 1 second and not shown again in the "for you" feed. I've found it actually pleasant and interesting to use now. New feed every time.
It's not extensively tested yet, and might not show great results before your local database is populated with notes and reactions. Also, it's unfortunate that sqlite wasm persistence (origin-private filesystem) requires some http headers that broke youtube and some other embeds.
Published at
2024-02-06 12:08:43Event JSON
{
"id": "43b87e58f4b50a220bf07c6840fff635bc31f68d3f0d40be8d60b616aef7b7b8",
"pubkey": "4523be58d395b1b196a9b8c82b038b6895cb02b683d0c253a955068dba1facd0",
"created_at": 1707221323,
"kind": 1,
"tags": [
[
"p",
"63fe6318dc58583cfe16810f86dd09e18bfd76aabc24a0081ce2856f330504ed"
]
],
"content": "Local sqlite db by nostr:npub1v0lxxxxutpvrelsksy8cdhgfux9l6a42hsj2qzquu2zk7vc9qnkszrqj49 is great. So much better than IndexedDB. Iris \u0026 Snort can now store a lot of data locally, sync only what they don't already have (negentropy \u0026 nip-114) and eventually do p2p over webrtc. Works offline.\n\nIris now features a \"for you\" feed which uses the local database. It scores events by recentness, author favoriteness (top authors reacted by you) and amount of reactions from users who often react to the same notes as you.\n\nRecentness is randomly weighted to occasionally show older events as well. Recent notes from all followed users are also mixed in.\n\nEvents are marked \"seen\" when they've been in the viewport for 1 second and not shown again in the \"for you\" feed. I've found it actually pleasant and interesting to use now. New feed every time.\n\nIt's not extensively tested yet, and might not show great results before your local database is populated with notes and reactions. Also, it's unfortunate that sqlite wasm persistence (origin-private filesystem) requires some http headers that broke youtube and some other embeds.",
"sig": "e6eb92b55781f7e613853888b74e64b1cb6cc80c5d0b42a846c09ffc949f980432a9063933fbade7d60af2ac3a6c858166e1984f40c7b055ec7674aa3d61660f"
}