xeon06
Explore posts from serversDTDrizzle Team
•Created by nr7751 on 4/1/2024 in #help
Drizzle spontaneously trying to truncate my db
Yikes
21 replies
DTDrizzle Team
•Created by xeon06 on 1/12/2024 in #help
Update with inner join?
I'm just worried about the performance of a large inArray, but maybe I shouldn't?
14 replies
DTDrizzle Team
•Created by xeon06 on 1/12/2024 in #help
Update with inner join?
So for now I'm doing two queries, one to get user IDs with the country and then an
inArray... Not great14 replies
DTDrizzle Team
•Created by xeon06 on 1/12/2024 in #help
Update with inner join?
That or a subquery but doesn't look like that's possible in Drizzle either
14 replies
DTDrizzle Team
•Created by xeon06 on 1/12/2024 in #help
Update with inner join?
For instance, just typed from my phone
14 replies
DTDrizzle Team
•Created by xeon06 on 1/12/2024 in #help
Update with inner join?
Typically in SQL I'd do
UPDATE entity INNER JOIN users ON users.id = entity.userId SET thing = 2 WHERE user.country = "CAN"14 replies
DTDrizzle Team
•Created by xeon06 on 1/12/2024 in #help
Update with inner join?
Sure! Essentially I want to update records with a WHERE clause that references another table
14 replies
DTDrizzle Team
•Created by xeon06 on 1/9/2024 in #help
Select fields with the same name in two different tables in a join
Ah this might be this bug with D1
https://github.com/drizzle-team/drizzle-orm/issues/555
2 replies
DTDrizzle Team
•Created by xeon06 on 1/9/2024 in #help
Shifted properties in join
Ah this seems to be this bug with D1
https://github.com/drizzle-team/drizzle-orm/issues/555
2 replies
DTDrizzle Team
•Created by xeon06 on 1/3/2024 in #help
String default for integer timestamps?
9 replies
DTDrizzle Team
•Created by xeon06 on 1/3/2024 in #help
String default for integer timestamps?
9 replies
DTDrizzle Team
•Created by xeon06 on 1/3/2024 in #help
String default for integer timestamps?
No sir
9 replies
DTDrizzle Team
•Created by xeon06 on 1/3/2024 in #help
String default for integer timestamps?
I'm starting to think this is a bug
9 replies
DTDrizzle Team
•Created by xeon06 on 1/3/2024 in #help
String default for integer timestamps?
SQLite doesn't have a timestamp type
9 replies