Fyi ent contracts are closer to $2000/month last I checked
Fyi ent contracts are closer to $2000/month last I checked
Expression tree is too large (maximum depth 20) for some queries. Those are not particularly complex, it's just like get x -> join this field -> join this field, so I'd guess this would be the depth 2 or 3?SQLITE_LIMIT_EXPR_DEPTH set to 20 on the new backend.alpha backend - try running wrangler d1 info <dbname>EXPLAIN QUERY PLAN which should tell you the actual expression depth of your query.wrangler d1 info <dbname> without the databasedb.query.[....]) only with the ones that start differentlyAdd support for the JSONB binary representation of JSON, which is both smaller and faster than the corresponding RFC 8529 text format.

wrangler -j 

beta, yes.

wrangler d1 info <dbname>?
Expression tree is too large (maximum depth 20)SQLITE_LIMIT_EXPR_DEPTH20alphawrangler d1 info <dbname>wrangler d1 info <dbname>wrangler d1 info <dbname>EXPLAIN QUERY PLANtoSQL();db.query.[....]wrangler -jconst batcher = await db.prepare("SELECT * FROM table WHERE ref = ?1");const batcher = await db.prepare("SELECT * FROM table WHERE ref = ?");beta const teamArticles = await db.query.articles.findMany({
where: ownerOrInTeam(articles.userId, authUser), // this is one equality check
with: {
pineconeReferences: true,
outlineDrafts: { // if I do outlineDrafts: true, I am not over 20 anymore
with: { // this seems to be the edge at which it goes over 20 seemingly
draftPieces: true
}
}
}
});[[d1_databases]]
binding = "db1"
database_name = "test-db"
database_id = "c020574a-5623-407b-be0c-cd192bab9545"
[[d1_databases]]
binding = "db2"
database_name = "test-db"
database_id = "c020574a-5623-407b-be0c-cd192bab9545"d1_databases = [
{ binding = "db1", database_name = "db1", database_id = "1" },
{ binding = "db2", database_name = "db2", database_id = "2" }
]