SELECT
posts.id,
posts.title,
posts.updatedOn,
substr(posts.body, 0, 20) as body,
users.firstName || ' ' || users.lastName as author,
count(comments.id) as commentCount,
categories.title as category,
COUNT() OVER() as total
FROM posts
left outer join users
on posts.userid = users.id
left outer join comments
on comments.postId = posts.id
left outer join categoriesToPosts
on categoriesToPosts.postId = posts.id
left outer join categories
on categoriesToPosts.categoryId = categories.id
group by posts.id
order by posts.updatedOn desc
limit 10
offset 0
K
U
MMK
L
C
CREATE TABLE IF NOT EXISTS Messages (id TEXT, userId TEXT, content TEXT); but when I try to select from Messages it says the table doesn't exist?ML
C
--local
Jposts
JL
SS
IFor example, if the users table has an index on a timestamp columnFor https://developers.cloudflare.com/d1/platform/pricing/, I still cannot understand how rows read works at this moment. Rows reading measurement only shows example of full table scan, but not others such like partial read (filterable, join etc).created_at, the querySELECT * FROM users WHERE created_at > ?1would only need to read a subset of the table.
I
D
DD
B
wrangler pages devD1pnpx wrangler -c wrangler.toml d1 execute DB --local --file=migrations/001.sqlD1D1
F
V
pnpx wrangler d1 execute db_name --local --file=./src/dump/dump.sql
Mapping SQL input into an array of statementsB
IIVVIII
Request entity is too large [code: 7011]
MDMII
RMM
CLOUDFLARE_ACCOUNT_ID=1234 CLOUDFLARE_API_TOKEN=4321 wrangler whoami
MMRMCLOUDFLARE_ACCOUNT_ID=1234 CLOUDFLARE_API_TOKEN=4321 wrangler d1 execute test-database --command="SELECT * FROM Customers" CLOUDFLARE_ACCOUNT_IDCLOUDFLARE_API_TOKENCREATE TABLE IF NOT EXISTS Messages (id TEXT, userId TEXT, content TEXT);created_atSELECT * FROM users WHERE created_at > ?1