Cloudflare Developers•2y ago

Check the encoding on the sql. Should be UTF-8

CCyb3r-Jak3 Check the encoding on the sql. Should be UTF-8

Mrxbox98•2/13/24, 8:25 PM

Tysm, this worked

SShyim Is it possible to disable FOREIGN KEY constraints? I just want to import my loca...

Matt Silverlock•2/13/24, 9:25 PM

PRAGMA defer_foreign_keys = true

PRAGMA defer_foreign_keys = true

draft docs: https://silverlock-d1-foreign-keys.cloudflare-docs-7ou.pages.dev/d1/learning/foreign-keys/#relax-foreign-key-constraints

Foreign keys · Cloudflare D1 docs

D1 supports defining and enforcing foreign key constraints across tables in a database.

Max (@rozenmd)•2/13/24, 10:01 PM

@geelen

Max (@rozenmd)•2/13/24, 10:01 PM

DDavid Renshaw ``` const db = env.DB; let stmt1 = db.prepare( "SELECT def, author...

Max (@rozenmd)•2/13/24, 10:01 PM

.run doesn't return results (any more - it was a bug that it did)

Max (@rozenmd)•2/13/24, 10:01 PM

.all does

DDavid Renshaw ah, https://developers.cloudflare.com/d1/build-databases/query-databases/#await-...

itsmatteomanf•2/13/24, 10:03 PM

i was about to link that to you... it's definitely not clear above :NotLikeThis:

LLuka Hey @Max (@rozenmd) , I underestimate the rate of growth of my database. I canno...

Max (@rozenmd)•2/13/24, 10:10 PM

.sqlite export is being specced out but is unlikely to arrive within the month, i would look at splitting the workload across multiple dbs in the meanwhile or using a query limit on nora's tool

DDavid Renshaw https://developers.cloudflare.com/d1/build-databases/query-databases/#return-obj...

Matt Silverlock•2/13/24, 10:55 PM

Fixing in a PR

Matt Silverlock•2/13/24, 10:56 PM

Changelog going out soon, but for those here:

D1's
```
.raw()
```
```
.raw()
```
,
```
.all()
```
```
.all()
```
and
```
.run()
```
```
.run()
```
query statement methods (https://developers.cloudflare.com/d1/build-databases/query-databases/#query-statement-methods) have been updated to reflect their intended behaviour and improving compatibility with ORMs.
```
.raw()
```
```
.raw()
```
now correctly returns results an array of arrays, allowing the correct handling of duplicate column names (such as when joining tables), as compared to
```
.all()
```
```
.all()
```
, which is unchanged and returns an array of objects. To include an array of column names in the results when using
```
.raw()
```
```
.raw()
```
, use
```
.raw({columnNames: true})
```
```
.raw({columnNames: true})
```
.
```
.run()
```
```
.run()
```
no longer incorrectly returns a
```
D1Result
```
```
D1Result
```
and instead returns a
```
D1ExecResult
```
```
D1ExecResult
```
(https://developers.cloudflare.com/d1/build-databases/query-databases/#return-object) as originally intended and documented.

This may be a breaking change for some applications that expected

.raw()

.raw()

to return an array of objects.

MMatt Silverlock Changelog going out soon, but for those here: * D1's `.raw()`, `.all()` and `.r...

kev-ac•2/14/24, 1:56 AM

It was indeed a breaking change for us, even if it was never intended to work that way. Replacing the .run() with .all() seemed to have done the trick for now. Back to sleep

Unsmart•2/14/24, 1:57 AM

That’s what a betas for tho

Jadugar_Jaggu•2/14/24, 4:05 AM

beeeetaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

ZZiga Zajc Multiple statements in a single query are not supported?

Unsmart•2/14/24, 4:19 AM

https://developers.cloudflare.com/d1/build-databases/query-databases/#batch-statements

Kkev-ac It was indeed a breaking change for us, even if it was never intended to work th...

conneo•2/14/24, 7:48 AM

Same for us. .all() seems to fix the problem

Kkev-ac It was indeed a breaking change for us, even if it was never intended to work th...

conneo•2/14/24, 7:50 AM

On top of that doc the .run() is mentioned as responding with results array, that's somewhat confusing. On the details section for .run() it's correctly mentioned that there are no results in response

sultan.xh•2/14/24, 7:54 AM

Is anyone having an issue with D1? It looks like it is failing to return results.

sultan.xh•2/14/24, 7:55 AM

A basic simple select query does not return any result array.

Kyrre•2/14/24, 7:57 AM

Same issue here @sultan.xh.

sultan.xh•2/14/24, 7:58 AM

Yes, the Return object is missing results.

Nehal Ali•2/14/24, 7:59 AM

@sultan.xh if you are using .run() it is now won't be returning any results

sultan.xh•2/14/24, 7:59 AM

What should I use then?

Nehal Ali•2/14/24, 7:59 AM

@sultan.xh .all() instead

sultan.xh•2/14/24, 8:00 AM

Okay, it is a small change, but it has a big impact. I need to modify everything now.

sultan.xh•2/14/24, 8:00 AM

Thanks!

UUnsmart That’s what a betas for tho 🤝

kev-ac•2/14/24, 8:42 AM

I never said that I was unaware of its beta state. Noticed the issue, changed it in code, be done with it

Max (@rozenmd)•2/14/24, 9:04 AM

@D1 Database PSA: if you are using

.run()

.run()

and expecting it to return results, you should be using

.all()

.all()

: d1-database

shahzaibkhalid•2/14/24, 9:20 AM

Does anyone know if Prisma works with D1?

Sshahzaibkhalid Does anyone know if Prisma works with D1?

bun•2/14/24, 9:24 AM

https://github.com/prisma/prisma/issues/13310 nope

GitHub

Support for Cloudflare's new SQLite database D1 · Issue #13310 · pr...

Cloudflare have just announced their first relational DB D1 which is based on SQLite. https://blog.cloudflare.com/introducing-d1/ Would be awesome if Prisma could support it one day..

Sshahzaibkhalid Does anyone know if Prisma works with D1?

Asher•2/14/24, 11:21 AM

Only DrizzleORM for now

MMatt Silverlock Changelog going out soon, but for those here: * D1's `.raw()`, `.all()` and `.r...

Matt Silverlock•2/14/24, 11:39 AM

Official change-log and updated documentation for breaking changes to

all()

all()

raw()

raw()

and

first()

first()

https://developers.cloudflare.com/d1/platform/changelog/#2024-02-13

Cloudflare Docs

Changelog · Cloudflare D1 docs

D1’s raw(), all() and run() query statement methods have been updated to reflect their intended behaviour and improve compatibility with ORMs …

Kkev-ac I never said that I was unaware of its beta state. Noticed the issue, changed it...

Unsmart•2/14/24, 12:37 PM

Sorry that comment wasn’t directed at you just the change

Ɽ

ⱤØ₥₳₦•2/14/24, 2:44 PM

How to predefine location for D1

ⱤⱤØ₥₳₦How to predefine location for D1

Matt Silverlock•2/14/24, 2:48 PM

https://developers.cloudflare.com/d1/configuration/data-location/

Cloudflare Docs

Data location · Cloudflare D1 docs

Learn how the location of data stored in D1 is determined, including where the leader is placed and how you optimize that location based on your …

Ian•2/14/24, 2:54 PM

will dynamic binding be part of GA release by April ?

MMax (@rozenmd).sqlite export is being specced out but is unlikely to arrive within the month, ...

Luka•2/14/24, 2:58 PM

Unfortunately I keep hitting the limits either memory/max execution time or sub requests. I opened ticket at cloudflare if they can lift the limits but pretty much it always errors out with no information. I really feel hopeless on that one other than manually transferring the rows.

If you would feel kind enough to look through and share any ideas on the issue, I'd really appreciate that!
https://github.com/nora-soderlund/cloudflare-d1-backups/issues/9

GitHub

Errors: Http 500 - CF 1101 // Http 503 - CF 1105 // Http 504 · Issu...

Hi again. I'm back at it once again trying to export a 450 MB-large database. My own worker uses Hono and I would constantly see the Inspector command exceeded memory limits errors. I've de...

MMatt Silverlock https://developers.cloudflare.com/d1/configuration/data-location/

Ɽ

ⱤØ₥₳₦•2/14/24, 3:13 PM

Dayum, now I'm legally blind

. Thanks for the resource

Check the encoding on the sql. Should be UTF-8

Similar Threads

Similar Threads

Similar Threads