Is nostr:npub1xtscya34g58tk0z605fvr788k263gsu6cy9x0mhnm87echrgufzsevkk5s's nostrdb work useful in any way for android?
Discussion
Sure, you just need to port filters to the content resolver calls (which look like SQLs if you ever used SQLs in Java). I just don't know if the LMDb idea of mapping file pages to memory works is optimized for android's filesystem.
Its a virtual memory thing more than a filesystem thing. Just need to make sure android supports allocating large virtual memory maps.