M
/tmp/<some random ID> file that gets thrown away by your OS. That way, if you have a larger DB, we don't eat all of your CI containers' memory 
V
AD1 sqlite? I was using bun sqlite where I create a local db.sqlite file and interact with it using the imported client. In the case of Cloudflare & wrangler, I'm a little confused as to how I can create and seed a local sqliteA
dev commandwrangler.jsonA
--persist-to=/path/to/file to persist data to a specific location but no luck and on seeding I couldn't find any relevant info.
CAAprestart script that runs a ts file to init local sqlite and seed itVVwrangler d1 migrations, you can use a migration to seed the database or if you want a more programatic approach scroll up a bit, we had a discussion about possibilites just a few hours agoAA--persist-to=/path/to/fileMpreview_database_id (per https://developers.cloudflare.com/d1/platform/migrations/#wrangler-customizations) and use wrangler d1 migrations apply <db-name> --local -> you can apply migrations locally to seed the DB. As above, you can also do that programatically via your test harness
AA
name.sqlite file?AAAAMwrangler d1 migrations inside your tests: the example shows that.MAAdb. Is there a way to change that by just changing binding in wrangler config?
DDwrangler d1 execute --local --comand="SELECT NOTHING"DDDD
A
Error: statement too longMAM
I
I
BBB
M
cause should not be deprecated, it's still thereMBError: too many terms in compound SELECT (coming from a select {condition} union all select {another condition} ).. I suppose I'm wondering what SQLite differences would account for this seeing that the query works in the regular backend but errors out in the experimental?/tmp/<some random ID>D1bundb.sqlitedevwrangler.json--persist-to=/path/to/file--persist-to=/path/to/fileprestartwrangler d1 migrationswrangler d1 migrationspreview_database_idwrangler d1 migrations apply <db-name> --localname.sqlitedbbindingwrangler d1 execute --local --comand="SELECT NOTHING"Error: statement too longcauseError: too many terms in compound SELECTselect {condition} union all select {another condition} NO_D1_WARNING=true ./node_modules/.bin/wrangler dev --persist-to=./tokens.sqlite --experimental-json-config{
"$schema": "https://gist.githubusercontent.com/o-az/d298a1776165407ba63ee763d32f7a89/raw/7f87871dd9a5efb9d3cc147fac0174ebdc9858fa/wrangler.json",
"name": "tokens",
"workers_dev": true,
"main": "./src/index.ts",
"compatibility_date": "2023-05-18",
"compatibility_flags": [ "nodejs_compat" ],
"placement": { "mode": "smart" },
"d1_databases": [
{
"binding": "database",
"database_name": "tokens",
"preview_database_id": "local-tokens-sqlite"
}
]
}⛅️ wrangler 3.1.0 (update available 3.1.1)