Ah i see kde has fixed the issue where dropdowns had broken behavior when scrolling https://invent.kde.org/frameworks/kirigami/-/commit/f6ca218607ff7e5d5066eb3224154c3256cb9516 this was my main blocker why i couldn’t use it when i tried it around 2020. Maybe i could give it another try?
Modern relational databases have support for it too including indexes etc. For example postgres.