When scrolling through Lemmy, I often will see the same posts from the previous page - usually as the first links on the current page I’m on.

  • @jetA
    link
    English
    11
    edit-2
    9 months ago

    Sir, you hardly know me! Disagree fine, but don’t assume my pedigree.

    FWIW temporal tables, and time travel are real things available now and they are built very similarly to ZFS versioning.

    If we are truly trying to make a highly scalable distributed website, we wouldn’t be querying a database directly, would be using something distributed. Like foundationDB, or memcached. And we would have to modify our approach somewhat, but these are still solvable problems. The architecture and the requirements are tightly coupled. But we can’t make assumptions and rule out solutions at the whiteboard stage.