N
MM
UM
H
H
AA
HAAAH
P
json_object query that requires the higher limit
MAny particular reason why D1 has settled on a limit of 32?https://www.sqlite.org/security.html has 8, someone made a GitHub issue asking for more, we increased it - we'd appreciate a github issue if you'd like more: https://github.com/cloudflare/workerd/issues
H
@id @default(uuid()). Do I need to add an explicit index for each id column? The docs say that they are added automatically, but only for INTEGER PRIMARY KEYS. Prisma generates TEXT NOT NULL PRIMARY KEY id columns. SELECT name, type, sql FROM sqlite_schema WHERE type IN ('index'); shows one sqlite autoindex for each table, for example sqlite_autoindex_Organization_1. Is that sufficient or will explicit id indices help with querying?
MHMH
AAAAA
AAA
F
K
.meta.duration or how long it takes to get a response?A
FUFUFA
BB
json_object@id @default(uuid())INTEGER PRIMARY KEYSTEXT NOT NULL PRIMARY KEYSELECT name, type, sql FROM sqlite_schema WHERE type IN ('index');sqlite_autoindex_Organization_1.meta.durationselect json_array("id", "location_type", "name", "status", "brand_id", "address", "google_maps_url" /* , ... */)
from location;