Is there a way to programmatically create and manage D1 databases? Like for instance, could I have a

Is there a way to programmatically create and manage D1 databases? Like for instance, could I have a worker that creates a new database for a user using an api request?

JJason Hostetter Is there a way to programmatically create and manage D1 databases? Like for inst...

Matt Silverlock•4/2/23, 7:28 PM

Not yet! We want to get into beta before we publish the external API, which will allow you to do this (and also allow us to add Terraform support)

MMatt Silverlock Not yet! We want to get into beta before we publish the external API, which will...

Jason HostetterOP•4/2/23, 11:23 PM

Sounds good! Looking forward to it

hanpolo•4/3/23, 5:09 PM

I would like to experiment with d1 migrations in a CI/CD environment like GitHub but it seems my CLOUDFLARE_API_TOKEN does not have the right permissions. Any ideas how to configure the right permissions to be able run wrangler d1 migrations applywrangler d1 migrations apply?

Hhanpolo I would like to experiment with d1 migrations in a CI/CD environment like GitHub...

hanpolo•4/3/23, 5:12 PM

Actually, I think I found it .. there's D1:EDIT under accounts

Walshy•4/3/23, 7:52 PM

D1 support isn't in workers-rs yet, issue tracking: https://github.com/cloudflare/workers-rs/issues/221

SebastiaanYN•4/3/23, 9:56 PM

fwiw you can use this PR as your workers-rs version and use D1, or copy over the code for it https://github.com/cloudflare/workers-rs/pull/270

GitHub

feat: Added D1 Support by FlareLine · Pull Request #270 · cloudflar...

Summary
These changes add D1 support to the worker crate, resolving #221.
Due to the nature of local development with Rust workers, developing an easy process for locally debugging this integration...

Mmacron is it possible to use D1 in workers through dashboard? or I only should use wran...

Max (@rozenmd)•4/4/23, 6:55 AM

you can't use D1 with the dashboard Worker quick editor yet - just wrangler CLI

Max (@rozenmd)•4/4/23, 6:56 AM

but if you need to edit data, the basics (TEXT and INTEGER) work

Epailes•4/5/23, 11:08 AM

I saw we can request increases above 100MB limit, is that something easy to get or is it generally just ent+ until beta/launch?

EEpailes I saw we can request increases above 100MB limit, is that something easy to get ...

Max (@rozenmd)•4/5/23, 11:24 AM

It's more to work out what folks want to use a larger db for - I don't know if we'll be increasing the limit until beta

MMax (@rozenmd)It's more to work out what folks want to use a larger db for - I don't know if w...

Epailes•4/5/23, 2:56 PM

Ah okay, yeah any increase in DB size above 100MB can equally be handled by having multiple D1 instances, hopefully it'll be possible to access them using a string as an identifier rather than needing to manually bind them

SmallShen•4/8/23, 8:33 AM

Is it possible to dynamically get a d1 database(usecase for saas)?

Original message was deleted

Hello, I’m Allie!•4/8/23, 8:37 AM

Yes https://developers.cloudflare.com/d1/learning/backups/

Backups · Cloudflare D1 docs

D1 has built-in support for creating and restoring backups of your databases, including support for scheduled automatic backups and manual backup …

SSmallShen Is it possible to dynamically get a d1 database(usecase for saas)?

Hello, I’m Allie!•4/8/23, 8:37 AM

As a binding? No

Hello, I’m Allie!•4/8/23, 8:37 AM

As a call to the API, yes

HHello, I’m Allie!As a binding? No

SmallShen•4/8/23, 8:53 AM

like env.dbNamespace.get('db-id')env.dbNamespace.get('db-id')

SSmallShen like `env.dbNamespace.get('db-id')`

Hello, I’m Allie!•4/8/23, 8:55 AM

Yeah, you can’t do that

Atinux•4/8/23, 5:07 PM

I get around 200ms of latency when querying the database (living in France). Is the SQLite database right know hosted in US?

Atinux•4/8/23, 5:08 PM

From what I understand there is no replica yet right?

AAtinux I get around 200ms of latency when querying the database (living in France). Is ...

zegevlier•4/8/23, 7:15 PM

AFAIK the database is hosted wherever the DO behind it gets created, which is usually near to where the first request is made. Is the latency lower when you are requesting from the US?

AAtinux From what I understand there is no replica yet right?

zegevlier•4/8/23, 7:15 PM

Not yet!

TigersWay•4/9/23, 1:34 AM

Hi, Is some kind of REGEXPREGEXP extension already installed (and I did not yet succeed to call it), or will it be later?
Thanks

mrwind•4/9/23, 9:26 AM

is d1 support index by column?

Mmrwind is d1 support index by column?

Matt Silverlock•4/9/23, 12:34 PM

Yes: https://www.sqlitetutorial.net/sqlite-index/

SQLite Tutorialadmin

SQLite Index: An Essential Guide to SQLite Indexes

In this tutorial, you will learn how to utilize SQLite index to query data faster, speed up sort operation, and enforce unique constraints.

Jökull Sólberg•4/9/23, 5:13 PM

Is there a way to see where the D1 is hosted? I know replication is not yet switched on but I would love to get a sense of things. Also, is it possible to move the DB, perhaps by recreating it? Super excited about D1.

Jökull Sólberg•4/9/23, 5:16 PM

Also. Random observation, sqlite very powerful paradigm for user/org specific things. So if product is like Salesforce, each org could evolve schema with fields they want to use for their db. Opens door to amazing tooling! Not yet supported but interesting angle - dynamic bindings?

Cyb3r-Jak3•4/10/23, 12:41 PM

I thought there was

Original message was deleted

Cyb3r-Jak3•4/10/23, 12:43 PM

“Account:D1”

Jacob•4/10/23, 1:54 PM

I was using D1 for the first time in a while and came across a D1 error that was confusing:

env.PREPARE("SELECT ...").bind(...).run()

env.PREPARE("SELECT ...").bind(...).run()

This doesn't work because run()run() apparently isn't allowed for SELECTSELECT (but I forgot I needed to use all()all() or first()first()).
Unfortunately, all that's thrown is D1_ERRORD1_ERROR (with nothing in e.causee.cause.)

Are there some docs that help explain the JS API? Or maybe some docstrings could be added to the types to help explain when to use each method?

Jacob•4/10/23, 2:21 PM

That's true, deff could have been logging it wrong. Thanks!

JJacob I was using D1 for the first time in a while and came across a D1 error that was...

DaniFoldi•4/10/23, 2:31 PM

Types could also be converted into generics for D1PreparedStatementD1PreparedStatement to indicate what statement it was more precisely, something like https://tinyurl.com/d1-generic-types-ts-playground

TS Playground - An online editor for exploring TypeScript and JavaS...

The Playground lets you write TypeScript or JavaScript online in a safe and sharable way.

DDaniFoldi Types could also be converted into generics for `D1PreparedStatement` to indicat...

Matt Silverlock•4/10/23, 3:20 PM

cc @geelen

Original message was deleted

DaniFoldi•4/10/23, 7:33 PM

yeah there are definitely edge cases, but I think there are <10k possible combinations of statement types, so it might be doable - the playground is just an example for me to check if it's possible without regex types literals, so I only did some very basic tests

hanpolo•4/11/23, 5:33 AM

I'm experimenting with running D1 migrations off of Pages CI/CD using wrangler apply with an API token for D1. When I ran the command it applied the first script and then failed on the second script with Internal Error 7501. Does anyone know if there are limitations to doing this: e.g. it can only run one script at a time etc.

hanpolo•4/11/23, 5:36 AM

FYI: I ran the same scripts later from the terminal from my local development mac and everything ran smoothly with changes made to my D1 instance on Cloudflare: so I know that the scripts do not have bugs.

Is there a way to programmatically create and manage D1 databases? Like for instance, could I have a

Similar Threads

Similar Threads

Similar Threads