jdev - 2023-07-21

  1. lovetox

    i think i have thought through all cases, and the tuple idea looks good to me, i want to try that. Last open question i would have is, can i express a tuple like (100, -1) in one database field?

  2. lovetox

    or will i need 2, maybe there is some magic how i can turn this tuple into some integer that is sortable

  3. singpolyma

    If you're willing to live with some limits you could bit pack something equivalent into one 64bit field or so

  4. singpolyma

    I think

  5. singpolyma

    That's not my area as much

  6. singpolyma

    Or in some db you can store a tuple directly but probably not in sqlite

  7. lovetox

    i never did this, but can i really have a - sign in the later part of the integer?

  8. lovetox

    because its important that the first int is positive, and only the second in the tuple can become negative

  9. singpolyma

    No, it wouldn't be a minus but rather ordering the fields inside the bits so that sorting works out

  10. singpolyma

    I'd just do two fields myself probably

  11. lovetox

    yeah i think thats over my head, i probably will do also 2, thought i asked maybe there was something obvious i missed