nk
DTDrizzle Team
•Created by maverickdoge on 8/2/2024 in #help
Help with query
I would probably do a subquery
7 replies
DTDrizzle Team
•Created by maverickdoge on 8/2/2024 in #help
Help with query
And I think it would be smarter to not do all of that anyways
7 replies
DTDrizzle Team
•Created by maverickdoge on 8/2/2024 in #help
Help with query
I dont think "date < CURRENT_DATE + INTERVAL does what you think it does
7 replies
DTDrizzle Team
•Created by maverickdoge on 8/2/2024 in #help
Help with query
I think the first part in your where statement is wrong
7 replies
DTDrizzle Team
•Created by nubb on 4/18/2024 in #help
0 tables
Its okay to make mistakes pumpkin
18 replies
DTDrizzle Team
•Created by nubb on 4/18/2024 in #help
0 tables
It will use node if you don't do --bun or have node installed
18 replies
DTDrizzle Team
•Created by nubb on 4/18/2024 in #help
0 tables
Drizzle-kit has never worked on Bun
18 replies
DTDrizzle Team
•Created by GStudiosX2 on 7/31/2024 in #help
Get N of last rows
id: serial("id").primaryKey()
28 replies
DTDrizzle Team
•Created by GStudiosX2 on 7/31/2024 in #help
Get N of last rows
I only use createdAt for display values not for sorting
28 replies
DTDrizzle Team
•Created by GStudiosX2 on 7/31/2024 in #help
Get N of last rows
I would add back the serial id
28 replies
DTDrizzle Team
•Created by GStudiosX2 on 7/31/2024 in #help
Get N of last rows
I would put an index on id/created_at desc so it's fast
28 replies
DTDrizzle Team
•Created by GStudiosX2 on 7/31/2024 in #help
Get N of last rows
I always use the id
28 replies
DTDrizzle Team
•Created by GStudiosX2 on 7/31/2024 in #help
Get N of last rows
And sorting by createdAt is slower
28 replies
DTDrizzle Team
•Created by GStudiosX2 on 7/31/2024 in #help
Get N of last rows
Just have a number as well
28 replies
DTDrizzle Team
•Created by GStudiosX2 on 7/31/2024 in #help
Get N of last rows
If you have an ID string don't use it like that
28 replies