divby0
Explore posts from serversDTDrizzle Team
•Created by divby0 on 10/3/2023 in #help
Get Raw query string of a relational query in drizzle
That was exactly what I was looking for, thanks
7 replies
DTDrizzle Team
•Created by divby0 on 10/3/2023 in #help
Get Raw query string of a relational query in drizzle
Oh that's nice, I'll try tomorrow. Thanks soo much
7 replies
DTDrizzle Team
•Created by divby0 on 10/3/2023 in #help
Get Raw query string of a relational query in drizzle
7 replies
DTDrizzle Team
•Created by divby0 on 5/9/2023 in #help
Many-to-Many joins results in weird values
I saw they responded this: https://discord.com/channels/595317990191398933/992060581832032316/1107666967030145075
Does that make sense and can we as drizzle-users try that out or is that something you guys would need to change?
23 replies
DTDrizzle Team
•Created by divby0 on 5/9/2023 in #help
Many-to-Many joins results in weird values
You seem to be certain tho that drizzle is doing it like better-sqlite3. And I am not at all educated about the inner workings of this so I can't really argue, but maybe it would make sense for someone from the drizzle team to write into the d1 channel on cloudflares discord to clarify
23 replies
DTDrizzle Team
•Created by divby0 on 5/9/2023 in #help
Many-to-Many joins results in weird values
23 replies
DTDrizzle Team
•Created by divby0 on 5/9/2023 in #help
Many-to-Many joins results in weird values
I was able to get it working with that, I could even reduce the usage of this elongated syntax to only one of the "ambidiguous" fields, so I only needed to modify how I selected the team object, not the user object.
The one thing I am not sure about is, what does the "user_id" string referring to, is it just an arbitrary unique placeholder that's used to write down the column value?
23 replies
DTDrizzle Team
•Created by divby0 on 5/9/2023 in #help
Many-to-Many joins results in weird values
Thanks so much Alex! I'm trying to understand it and try it and I'll come back to report
23 replies
DTDrizzle Team
•Created by divby0 on 5/9/2023 in #help
Many-to-Many joins results in weird values
Okay, tell me if I can help somehow or if you have anything 🙂
23 replies
DTDrizzle Team
•Created by divby0 on 5/9/2023 in #help
Many-to-Many joins results in weird values
As someone with more experience, What's your recommendation? Should I just change my schema and rename the columns or do you think this will resolve soon?
23 replies
DTDrizzle Team
•Created by divby0 on 5/9/2023 in #help
Many-to-Many joins results in weird values
@Andrew Sherman
The data is transferred over JSON from D1 back to your worker, and it's impossible for there to be 2 identical JSON keys in an object. I'd recommend you use
SELECT "users".id as user_id, "posts".id as post_id or something like that instead
This is what a cloudflare dev said. It makes sense, SQL does return a flat key value array, right? So it's normal that there can't be two with the same name, it's just that we think it would be possible due to using nested jsons.23 replies
DTDrizzle Team
•Created by divby0 on 5/9/2023 in #help
Many-to-Many joins results in weird values
I'll ask about this on the cloudflare discord then, thanks a lot, Andrew!
23 replies