Hi all, even though D1 is in alpha, I am considering using it for a new startup (hoping D1 would be

Hi all, even though D1 is in alpha, I am considering using it for a new startup (hoping D1 would be beta around the time the MVP is ready). Worst case scenario is that I would have to migrate to another database before official launch (to avoid migration headaches early on). BUT I would need JS transactions. Is there any insight / timeline into the complexity of this feature? How likely will it be delayed? Is it the next focus, or are there other major changes / features coming first? I understand this is hard to answer, so "We don't know" is perfectly valid too of course!

ScottF•7/24/23, 3:01 PM

Has there been any indication when D1 will move from public alpha to public beta? I noticed it was on the roadmap in the last blog post but they didnt mention timing. Would love to plan my team's next solution around SQLite and I feel like D1 has the best DX out of all the available options. Just hard to sell it when there's all the alpha disclaimers everywhere.

BBram Hi all, even though D1 is in alpha, I am considering using it for a new startup ...

micromashor•7/24/23, 4:10 PM

JS transactions

support for SQL transactions in the JS API? if so, look into

db.batch

db.batch

(https://developers.cloudflare.com/d1/platform/client-api/#batch-statements)

D1 client API · Cloudflare D1 docs

As part of our Client API, both static and prepared statements are supported. Best practice is to use prepared statements which are precompiled …

Mmicromashor > JS transactions support for SQL transactions in the JS API? if so, look into `...

BramOP•7/24/23, 4:24 PM

I would love to integrate D1 with kysely, according to the author of kysely-d1, integrating with the

batch

batch

API is not feasible for this

see: https://github.com/aidenwallis/kysely-d1/issues/2#issuecomment-1327869881

GitHub

Transactions support · Issue #2 · aidenwallis/kysely-d1

Transactions are not currently supported in D1. Once they are, this package needs support added for them.

Farhian•7/25/23, 1:40 AM

Hi all, is there a way to restore a D1 from a backup? I have 2 databases - one has some data and the other is empty. I am trying to copy all the data from the first to the second. I was hoping that I could export a backup from the first one (which I was able to do) and then use the restore on the second (and hope to 'clone' the first it into the second - including structure and data)

FFarhian Hi all, is there a way to restore a D1 from a backup? I have 2 databases - one h...

Catt0s•7/25/23, 2:32 AM

cloudflare has built in backups on experimental backend.
edit: i was confused, backups are normal, time travel is on experimental

FFarhian Hi all, is there a way to restore a D1 from a backup? I have 2 databases - one h...

Catt0s•7/25/23, 2:33 AM

try this https://developers.cloudflare.com/d1/learning/importing-data/

Importing data · Cloudflare D1 docs

D1 allows you to import existing SQLite tables and their data directly, enabling you to migrate existing data into D1 quickly and easily. This can be …

CCatt0s try this https://developers.cloudflare.com/d1/learning/importing-data/

Farhian•7/25/23, 1:17 PM

Thanks! I'll have a look. I knew about the Backup function, I just could not find the Import from an external backup.

micromashor•7/25/23, 3:32 PM

wrangler.toml

wrangler.toml

, why do we need to specify database_namedatabase_name? it seems redundant, given that you specify the database ID

micromashor•7/25/23, 3:32 PM

(could also be a question for #wrangler , just lmk and ill move this over there)

Mmicromashor in `wrangler.toml`, why do we need to specify `database_name`? it seems redundan...

Max (@rozenmd)•7/25/23, 4:19 PM

it probably wasn't well thought out tbh

Max (@rozenmd)•7/25/23, 4:19 PM

much like how we have envs in wrangler.toml but also preview_database_id

kian•7/25/23, 4:32 PM

At least D1 doesn't error if you don't specify a preview_preview_ :^)

Kkian At least D1 doesn't error if you don't specify a `preview_` :^)

Hyper•7/25/23, 7:02 PM

yeah with r2 i had to specify a preview for any env that is not at the top level configuration of wrangler.toml

Hyper•7/25/23, 7:02 PM

which i just set to be the same as the top level bucket anyway

kian•7/25/23, 7:05 PM

Yeahhh, it's not the best

micromashor•7/25/23, 11:15 PM

ah I see

micromashor•7/25/23, 11:29 PM

wow the beta backend is incredibly fast compared to the alpha backend

James•7/25/23, 11:49 PM

new D1 backend be zoomin' yeah, it's such a wild improvement

micromashor•7/26/23, 12:27 AM

yeah I did a double take because I thought they just changed the units in wrangler from msms to ss, but no, the query really did only take 0.3ms

micromashor•7/26/23, 2:00 AM

does stmt.raw()stmt.raw() return an empty array or null if there are no results?

SScottF Has there been any indication when D1 will move from public alpha to public beta...

wangtiezhu•7/26/23, 3:21 AM

same question. I am very much looking forward to the day D1 officially launches.

Mmicromashor wow the beta backend is incredibly fast compared to the alpha backend

Max (@rozenmd)•7/26/23, 10:56 AM

turns out native code is faster than WASM

DDenys Question: how can I specify binding name other than default when creating D1 dat...

Max (@rozenmd)•7/26/23, 11:14 AM

update your wrangler.toml to be:

[[d1_databases]]
binding = "MY_DB" # i.e. available in your Worker on env.DB
database_name = "...."
database_id = "..."

[[d1_databases]]
binding = "MY_DB" # i.e. available in your Worker on env.DB
database_name = "...."
database_id = "..."

DDenys @rozenmd Thanks ... I was thinking about that ... will it work on Cloudflare sid...

Max (@rozenmd)•7/26/23, 11:16 AM

in Pages you'd have to configure the binding via the Cloudflare dashboard

Tony Leung•7/26/23, 11:45 AM

Hi guys, has the new D1 engine had backup feature?

Tony Leung•7/26/23, 11:45 AM

and is it stable enough to not losing data or failed unexpectedly?

Max (@rozenmd)•7/26/23, 12:01 PM

You can now roll your database back in time up to 30 days - we're still in alpha though.

Tony Leung•7/26/23, 12:08 PM

thanks

MMax (@rozenmd)You can now roll your database back in time up to 30 days - we're still in alpha...

Tony Leung•7/26/23, 12:11 PM

the old D1 engine works pretty well for me! Should I expect the same consistency with D1 new engine?

Tony Leung•7/26/23, 12:12 PM

and is there anyway I can restore database from a local backup?

TTony Leung the old D1 engine works pretty well for me! Should I expect the same consistency...

Max (@rozenmd)•7/26/23, 12:16 PM

you can expect a performance improvement, here's what we noticed:

TTony Leung and is there anyway I can restore database from a local backup?

Max (@rozenmd)•7/26/23, 12:17 PM

you'll need to dump the local backup to sql first: https://developers.cloudflare.com/d1/learning/importing-data/#converting-sqlite-database-files

Tony Leung•7/26/23, 12:51 PM

Thanks.

Original message was deleted

Max (@rozenmd)•7/26/23, 1:58 PM

that was just execution

Max (@rozenmd)•7/26/23, 1:59 PM

we have yet to find a solution to beating the speed of light

micromashor•7/26/23, 3:07 PM

yeah that ones kinda pesky

Noel•7/27/23, 11:57 AM

is it possible to get the query output as csv in wrangler?

NNoel is it possible to get the query output as csv in wrangler?

Max (@rozenmd)•7/27/23, 1:12 PM

just JSON atm

Max (@rozenmd)•7/27/23, 1:16 PM

if you know jqjq you can convert JSON input to CSV output in your terminal, though

NNoel is it possible to get the query output as csv in wrangler?

Matt Silverlock•7/27/23, 2:52 PM

https://csvkit.readthedocs.io/en/latest/ is nice

Noel•7/27/23, 2:55 PM

thanks, looks like a good tool that i can use in the future

Noel•7/27/23, 2:56 PM

however this time i just ended up using a js snippet from so to convert the json in the browser console

Original message was deleted

Max (@rozenmd)•7/27/23, 3:47 PM

the fix for this should land in 3-4 hours

CiabbataConda•7/27/23, 5:47 PM

could someone clarify me some things about D1? Is it based on sqlite, and, if yes, where can I find some list with supported features? Does it have support for foreign keys? can it be used with something like drizzle orm? thank you.

benjamin•7/27/23, 6:10 PM

Check out the T4 stack: https://app.t4stack.com/ I am working with it now and using Drizzle with it. I struggle with what is available vs. not too, but FKs are supported. There isn't yet support for transactions.

T4 App

Tamagui, Solito, Expo & Next.js

Hi all, even though D1 is in alpha, I am considering using it for a new startup (hoping D1 would be

Similar Threads