MM
SELECT * FROM example with wrangler or the dashboard console, it works as expected, but the table viewer shows this:
Mtable_info pragma to discover the structure of the table, when, for historical reasons, that pragma doesn't show generated columns - table_xinfo must be used instead. (see https://www.sqlite.org/gencol.html 2.3 #9)
MM
M
PRAGMA foreign_keys=on on every connection, but this seems to always be a no-op. Anyone else run into this before?
LMLMforeign_keys=1, while the beta backend defaults to foreign_keys=0.Mforeign_keys=1 on the beta backend. It's tricky because that's per-SQLite connection, but the D1 API doesn't have a concept of a connectionLLMMM
K
KK
M
PRAGMA defer_foreign_keys = onMMM
B
T
document and document_type and document has a foreign key of document_type. document is a relatively large table and document_type has 10 or 20 records. What should I do when I want to get data from both tables, using JOIN or SELECT two times and use code to get the final data?LTT
AMAM
MM
C
C
C
MC
H
M
M
WM
SELECT * FROM exampletable_infotable_xinfoPRAGMA foreign_keys=onforeign_keys=1foreign_keys=1foreign_keys=0PRAGMA defer_foreign_keys = ondocumentdocumentdocumentdocument_typedocument_typedocument_typeCREATE TABLE example (
fruit TEXT,
fruit_but_lowercase TEXT GENERATED ALWAYS AS (lower(fruit)) VIRTUAL,
vegetable TEXT
);
INSERT INTO example (fruit, vegetable) VALUES
('Apples', 'Carrots'),
('Bananas', 'Broccoli');