shot
shot
PostsComments
DTDrizzle Team
Created by mr nooli on 5/11/2024 in #help
introspection fails (Supabase)
@mr nooli you can see here https://github.com/drizzle-team/drizzle-orm/issues/2338 -- apparently switching up the ports can do the trick. I was able to get it to work by changing the driver from postgres to pg
4 replies
DTDrizzle Team
Created by mr nooli on 5/11/2024 in #help
introspection fails (Supabase)
I am getting this as well
4 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
awesome, well, thanks again ❤️
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
Curious, how big is the team working on drizzle?
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
ahhh this makes good sense. Thanks for all the help! its greatly appreciated
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
i.e. it is deleting cards that match the contractAddress but for every user.
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
If you add the card value, in your playground: 
    {
    id: 4,
    accountId: 2,
    contractAddress: "contract-aa",
  },
    {
    id: 4,
    accountId: 2,
    contractAddress: "contract-aa",
  },
This will also get deleted though no?
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
Which I guess makes sense, as exists(query) I expect to always be true with how I have defined it.
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
hmm, with the following I delete all cards but for every user. Will keep trying. 
const query = db.select().from(accounts).where(eq(accounts.address, "0xdeadbeef"))

const result = await db
    .delete(cards)
    .where(
        and(
            exists(query),
            eq(cards.contractAddress, "0xsomething"),
        ),
    )
const query = db.select().from(accounts).where(eq(accounts.address, "0xdeadbeef"))

const result = await db
    .delete(cards)
    .where(
        and(
            exists(query),
            eq(cards.contractAddress, "0xsomething"),
        ),
    )
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
Right, I see
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
If that is my only option I will have to but I'm trying to avoid changes to the schema if possible atm 😉
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
ah so you're saying I could add a database-level relation with foreign keys?
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
wait, isn't that what there is already?
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
for this POC I am making for tomorrow I won't include the notNull but it should be there I suppose as all cards should be related to an account
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
strictly, yes, because there is no notNull. This isn't the case in my application however
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
I will try 🙂
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
and maybe to be a bit clearer with the query I am after: Delete all cards - that match a given contractAddress and - that reference the account given by the account.address. So cards that match the contractAddress but reference another account are not deleted
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
the playground is 🤌 btw
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
woops, forgot a field, changes pushed
47 replies
DTDrizzle Team
Created by shot on 7/17/2024 in #help
RangeError: Maximum call stack size exceeded on update and delete for small number of rows (10s)
yessir https://drizzle.run/ylvbdkuyfnwkkaube1ux4itc
47 replies