Cale McCollough
DTDrizzle Team
•Created by Cale McCollough on 10/7/2023 in #help
How do you use 128-bit values with varbinary and what is the fastest way to search for rows?
8 replies
DTDrizzle Team
•Created by Cale McCollough on 10/7/2023 in #help
How do you use 128-bit values with varbinary and what is the fastest way to search for rows?
This function appears to do it, but I'm still having trouble importing my npm linearid package into my Next.JS project. When I try to load my website it says "ReferenceError: module is not defined" I think I don't have my npm package.json configured correctly.
8 replies
DTDrizzle Team
•Created by Cale McCollough on 10/7/2023 in #help
How do you use 128-bit values with varbinary and what is the fastest way to search for rows?
8 replies
DTDrizzle Team
•Created by Cale McCollough on 10/7/2023 in #help
How do you use 128-bit values with varbinary and what is the fastest way to search for rows?
In this example i'm passing in eq(users.uid, LID()) (LID() returns two BigInt [msb, lsb]) which isn't right because the second that the LID gets assigned is not necessarily the same second as the SQL timestamp, so I need to search for a range of some number of seconds after the the LID was generated. I haven't figured out yet. The algorithm does rely on the clocks being accurate.
8 replies