had anyone setup serverless framework with D1?
had anyone setup serverless framework with D1?
MWhich specific framework? We have a ton of examples:
- D1 + Hono: https://developers.cloudflare.com/d1/tutorials/build-a-comments-api/
- Full stack framework code snippets: https://developers.cloudflare.com/d1/examples/
- Long list of framework guides: https://developers.cloudflare.com/pages/framework-guides/
TEasily develop and monitor auto-scaling applications on AWS Lambda, API Gateway, DynamoDB, etc., with the Serverless Framework and Serverless Monitoring Dashboard.
MMI don't think that serverless plugin supports wrangler 2, let alone D1 
Thmm serverless framework doesnt work much on any other cloud
Tseems it heavily favors AWS
MFYI — if you're using D1's new
--experimental-backend- You can now use a temporary wrangler branch
to restore a database to any minute within the last 30 days.npx wrangler@d1 d1 time-travel restore DB_NAME --timestamp=(unix timestamp|RFC3339 timestamp) - Our preview documentation is at https://silverlock-d1-time-travel.cloudflare-docs-7ou.pages.dev/d1/learning/time-travel/#docs-content
- For the initial release,
overwrites your existing database (with confirmation). In the future, we'll allow you to fork and/or clone to a new DB or over the top of an existing database.d1 time-travel restore DB_NAME - You can read more about Time Travel from our original announcement post back in May: https://blog.cloudflare.com/d1-turning-it-up-to-11/#time-travel
MPer the docs, yes: Time Travel will be the default. We address durability by writing databases to cold (object) storage: this is where idle databases are restored from.
Way too early to comment on anything non-JSON. Unlikely to be Protobuf.
Way too early to comment on anything non-JSON. Unlikely to be Protobuf.
H
SIf I already created a D1 database on the dashboard, how can I interact with it during local development?
Smy wrangler.toml is this:
although when doing wrangler pages dev, it's undefined
although when doing wrangler pages dev, it's undefined
Shonestly I'm just completely lost 
SOk I've figured out what I need to do now, but it does feel janky.
SI have my binding working in Qwik, once the site is uploaded to Cloudflare Pages.
However, locally, the only way I can see testing with the "same" D1 db that's on cloudflare is by making a
However, locally, the only way I can see testing with the "same" D1 db that's on cloudflare is by making a
bootstrap.sqldb-setup.sql
MSomething the Pages team is working on improving. In the meantime (and this is not officially supported; could break/change in the future):
- Create a
with awrangler.toml
key that maps to the same name used forpreview_database_id
you pass to--d1=<BINDING>wrangler pages dev- e.g. "DB" or "PROD_DB" (as appropriate)
- Execute
commands with thewrangler d1
flag against that local database to seed it / run migrations / etc - e.g.--localwrangler d1 execute db-name --file=seed.sql --local - Ensure that you pass
to any--d1=BINDING_NAME
commands so that Pages references the same local DB.wrangler pages dev
MYour
wrangler.toml[[d1_database]]
KMy feedback
So some is needed
Would be nicer.
So some is needed
--local--local--remoteWould be nicer.
MRemote is always the default for any non-local-dev (wrangler dev, wrangler pages dev) commands. You’re creating databases: you don’t want to think you’ve created one and find out on deploy it doesn’t exist.
SHi team, does D1 support using sqlite extensions? For example, if I want to use full text search capability there is a built in Fts5 extension: https://www.sqlite.org/fts5.html, can I use this in D1 without additional configuration?
SAnd second question, is js transactions coming anytime this year or is that a much longer term feature? ( read a value from d1, use that read value to do some calculation then write the result back, all inside a transaction)
SThanks for your response :) Yep! This is basically what I have right now and it works great!
I suppose once DB backups are available to download, it would be nice to download that to use for local development. Making a seed in the meantime is nice anyways because it declares the database structure for reference
I suppose once DB backups are available to download, it would be nice to download that to use for local development. Making a seed in the meantime is nice anyways because it declares the database structure for reference
MFTS5 is built in. On our list to include in our documentation, but works exactly as the SQLite docs say. We also support JSON5 - https://developers.cloudflare.com/d1/learning/querying-json/
D1 has built-in support for querying and parsing JSON data stored within a database. This enables you to:
MI keep randomly encountering this error while using
wrangler d1 executeit's also weird bc about half the time I see the error, the query went through successfully
MAre you using the new experimental backend? You can (should) log
error.cause.messageAs part of our Client API, both static and prepared statements are supported. Best practice is to use prepared statements which are precompiled …
Myes that's correct - it was produced by wrangler
Mand yes, I am using the experimental backend. I was trying to do an
INSERT
MWithout more details it’s hard to debug. Is the data static? Not all rows are created equal.
MI’d take a look through https://developers.cloudflare.com/d1/platform/limits/ to make sure you aren’t hitting limits. We have some changes queued up that will better expose error messages.
Many of these limits will increase during D1’s public alpha. Join the #d1-open-alpha channel in the Cloudflare Developer Discord to keep up to date …
MI seem to be getting a lot of
Error: D1_ERROR: Error: Network connection lost. errors with fairly simple (yet critical) queries my worker is running. The DB is using the experimental d1 backend. Is there a tried and true way to get to the bottom of why this is happening?
MCan you share your database ID here, and an example query? Is this deterministic - e.g. a specific query always causes the error?
MSeems to be, will DM
M@Matt sent.
IDo you have a primary key column?
IWhen you configure a database you need a primary key column (or columns) so that the database knows what data should unique. If you don't set that up, how would the DB know what is new and what is data to be replaced?
IYes!
II'd personally learn to use an actual SQL query (either via the browser console, or directly from
wrangler d1 executeBut this would work.
Myeah it's 3 text fields (all fields <100chars) and an ID, so I seriously doubt I'm hitting any limits. Will watch out for better error messages though
L,Hi all,
I am having an issue with my D1 database. When attempting to index one of the columns I get the error below:
ERROR 9015: SQL engine error: query error: Error code 11: The database disk image is malformed (database disk image is malformed).
CREATE INDEX idx_teams_team_name ON teams(team_name);
Any idea what can I do to get around this? The table has about 90k rows; I surely need an index to search on this column
I am having an issue with my D1 database. When attempting to index one of the columns I get the error below:
ERROR 9015: SQL engine error: query error: Error code 11: The database disk image is malformed (database disk image is malformed).
CREATE INDEX idx_teams_team_name ON teams(team_name);
Any idea what can I do to get around this? The table has about 90k rows; I surely need an index to search on this column
CDo you have the database ID? Sounds like something that the D1 team is going to want to look at on their side
LI restored the database to a 1 day old copy and now it works, the index created. I will need to reload about 40k records, but it is what it is 
MIt sounds like you’re using the original alpha backend - that error is very specific to it.
Msee the note about the experimental backend - https://developers.cloudflare.com/d1/get-started/#2-create-a-database
SHi, is the performance between getting data from KV versus from D1 neglible ? (assuming the DB lookup is a find on PK)
