Cloudflare Developers•3y ago

Not yet. We’ve shared a lot here already - it’s something we’re working on and will be part of/ahead

Not yet. We’ve shared a lot here already - it’s something we’re working on and will be part of/ahead of GA.

kian•12/19/23, 8:37 PM

D1 is SQLite, and doesn't really have the concept of users that you'd apply RLS to anyways.

kian•12/19/23, 8:45 PM

I'm not sure what you mean by that.

kian•12/19/23, 8:45 PM

You use the REST API or bind a Worker to the database.

Original message was deleted

Max (@rozenmd)•12/19/23, 9:17 PM

it's up to you to add application logic to show data based on authentication/authorization

Original message was deleted

Max (@rozenmd)•12/19/23, 9:19 PM

I recommend you go through the getting started guide to understand how it works: https://developers.cloudflare.com/d1/get-started/

Get started · Cloudflare D1 docs

This guide will instruct you through:

MMax (@rozenmd)You've pretty much identified all the sharp edges with working with multiple dat...

huw•12/19/23, 11:31 PM

(FYI for the discussion above this is how you PATCH extra bindings into a worker—cheers Max!)

mw10013•12/20/23, 1:38 AM

Is there a way to "reset" a database (ie. get it into the same state as if just created). This would be helpful with prototyping where I would like to reset the database and run the single migration I have that I'm editing. Currently, I'm deleting the database, creating another a new one with the same name, binding it to the pages app, updating the database id in the wrangler.toml, and finally applying the edited migration. Would be great to simply reset the database and then apply the edited migration. With local dev, I delete the .wrangler.wrangler directory. Longing for a way to reset databases in the cloud

Max (@rozenmd)•12/20/23, 9:53 AM

I just throw a DROP TABLE IF EXISTS...DROP TABLE IF EXISTS... at the start of my migrations

Cy•12/20/23, 11:07 AM

For anyone that’s used D1, what’s the performance look like?

Cy•12/20/23, 11:07 AM

I’m using turso and planetscale right now and I’m thinking about making the switch

CCy For anyone that’s used D1, what’s the performance look like?

JustinNoel•12/20/23, 1:17 PM

I was using Planetscale and switched to D1. much lower latency (improved about 50-100ms) for most areas I tested against.

Faster DB queries too but planetscale wAs pretty fast. Sorry, can't recall numbers.

Cy•12/20/23, 1:31 PM

Yeah I’m thinking latency will be the biggest thing given that I usually use pages

Cy•12/20/23, 1:32 PM

But I’m just worried about the query time tbh

CCy But I’m just worried about the query time tbh

Max (@rozenmd)•12/20/23, 1:34 PM

query time is fast with an index, getting data out rapidly is still a //TODO//TODO

NNico Hey, you've probably been asked this question many times, but I couldn't find an...

Chaika•12/20/23, 6:24 PM

D1 DBs are only accessible via bound workers or via the API/API Tokens you make. The only Workers that can access them are ones which are bound. IP Restrictions would be something you could do in the worker/firewall level

Chaika•12/20/23, 6:25 PM

It's not like they're normal SQL DBs that you can connect to externally, D1 is based on SQLite, no connection strings

Vy•12/20/23, 9:22 PM

@Nico What type of access controls are you interested in from a bound Worker itself?

Andrew Murphy•12/20/23, 10:55 PM

Is there a way for me to export my entire D1 to a file/something so I can put it into reporting tools like PowerBI etc?

Andrew Murphy•12/20/23, 10:57 PM

wrangler d1 backup create xxxwrangler d1 backup create xxx gives me the error Experimental DBs do not support backups yetExperimental DBs do not support backups yet

blakelockbrown•12/20/23, 11:09 PM

Is D1 storage limit really 2GB? How is anyone supposed to run a production system on this?

Bblakelockbrown Is D1 storage limit really 2GB? How is anyone supposed to run a production syste...

Cyb3r-Jak3•12/20/23, 11:12 PM

You’re not yet. It’s still beta

AAndrew Murphy Is there a way for me to export my entire D1 to a file/something so I can put it...

Cyb3r-Jak3•12/20/23, 11:13 PM

d1-database

Mmax Hi all, I'm wondering if someone can help me debug why my D1 latency is so high,...

mukhtharcm•12/21/23, 3:44 AM

did you got any solution?

kian•12/21/23, 3:50 AM

Your D1 database is located in a single location, so there are two things to look at.

1) Look at the returned metameta object from your query, it will include the duration that D1 actually took to execute your query.

2) Look at where your D1 database is located (wrangler d1 info <database_name>wrangler d1 info <database_name>) - if it's in a different region to you, and you're making multiple calls, it'll be pretty slow due to the network round-trip time.

Victor•12/21/23, 12:37 PM

Hi, guys, is there any docs to explain how many column types in d1?

VVictor Hi, guys, is there any docs to explain how many column types in d1?

GuillaumeLakano•12/21/23, 12:56 PM

D1 uses SQLite, so the documentation is here: https://www.sqlitetutorial.net/sqlite-data-types/

GGuillaumeLakano D1 uses SQLite, so the documentation is here: https://www.sqlitetutorial.net/sql...

Victor•12/21/23, 12:57 PM

Max (@rozenmd)•12/21/23, 1:11 PM

the official docs are decent too: https://www.sqlite.org/datatype3.html

Matt SilverlockOP•12/21/23, 1:45 PM

And https://developers.cloudflare.com/d1/platform/client-api/#type-conversion

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 …

rgb2hsl•12/21/23, 2:24 PM

Hi! I have pretty simple problem, but can't find a solution in docs.

If I run SELECT datetime('now', 'utc')SELECT datetime('now', 'utc') with and without --local--local — I'll get different results.

Remote gives me a proper UTC time, and local get's strange offset. Actually the offset is DOUBLED offset of my timezone from UTC.

How can I fix local D1 timezone?

UPD: I temporary fixed this by creating offset variable to offset all dates comes from and to DB by a set number of hours HAhaa

Spuckwaffel•12/21/23, 6:59 PM

hey there, is it possible connect ing thw worker with d1 db without using wranger and just the cloudflare website itself? the https://developers.cloudflare.com/d1/get-started/ only shows how to do it with wrangler and wrangler.toml, but i might be blind.

Get started · Cloudflare D1 docs

This guide will instruct you through: