that would seem a bit dangerous - its a specific assumption that `undefined` would have any relation

that would seem a bit dangerous - its a specific assumption that

undefined

undefined

would have any relation to

null

null

. You would need to handle these specifically yourself.

Also please note,

||

||

||

|| operator works on falsy/truthy.

null

null

NaN

NaN

NaN

NaN,

""

""

and

undefined

undefined

would all end as

null

null

in your example above.

_tweak^proneOP•4/19/24, 9:17 AM

In other words, if the description is

""

""

or "0""0"

your SQL would save them as
```
null
```
```
null
```
.

__tweak^prone that would seem a bit dangerous - its a specific assumption that `undefined` wou...

Vikash•4/19/24, 9:19 AM

That's expected, as descriptiondescription is optional fields, so I need to insert

null

null

if no value provided.

Otherwise D1 throws an error

VVikash That's expected, as `description` is optional fields, so I need to insert `null`...

_tweak^proneOP•4/19/24, 9:19 AM

you misunderstand.

the string "0""0" is not "no value"

Vikash•4/19/24, 9:20 AM

I am using

||

||

on string type fields only

_tweak^proneOP•4/19/24, 9:20 AM

"0" == false"0" == false, therefore "0" || null"0" || null is

null

null

Vikash•4/19/24, 9:20 AM

on Boolean type, I am using like this campaign.is_enabled ? 1 : 0campaign.is_enabled ? 1 : 0

_tweak^proneOP•4/19/24, 9:21 AM

You should read up on truthy / falsy

Vikash•4/19/24, 9:21 AM

I will, thanks. Any quick way to change string types to null?

_tweak^proneOP•4/19/24, 9:21 AM

If "description" is just a zero ("0") as text, you will save "null" in the database.

VVikash I will, thanks. Any quick way to change string types to null?

_tweak^proneOP•4/19/24, 9:23 AM

campaign.description === undefined ? null : campaign.descriptioncampaign.description === undefined ? null : campaign.description

or make a wrapper function

function bindWrap( ...args)function bindWrap( ...args)

that does it for you

__tweak^prone `campaign.description === undefined ? null : campaign.description` or make a wr...

Vikash•4/19/24, 9:24 AM

Awesome, thanks.

luna•4/19/24, 9:26 AM

i want to take my remote db and use it locally, is there a wrangler command for this? i couldnt find anything in the docs.

Lluna i want to take my remote db and use it locally, is there a wrangler command for ...

_tweak^proneOP•4/19/24, 9:36 AM

add --remote and you can use the remote database in your dev env

__tweak^prone add --remote and you can use the remote database in your dev env

luna•4/19/24, 9:51 AM

what if im using next js?

Lluna what if im using next js? 🤔

_tweak^proneOP•4/19/24, 10:29 AM

here you go

https://community.cloudflare.com/t/nextjs-pages-application-with-d1-bindings/595958

arsengoian•4/19/24, 5:40 PM

Hi everyone. Strings are truncated of any whitespace characters while inserting or updating columns of any type (varchar, binary). Is this intended behaviour? How do I insert a string that ends with a space? I can run the same in an sqlite3 database and the space is preserved.

Hannes•4/19/24, 7:48 PM

Hi, when exporting a D1 Database with

wrangler d1 export

wrangler d1 export

, the SQL file cannot be imported again using wrangler d1 execute --file ...wrangler d1 execute --file ..., because in the sql the tables are being created in the wrong order. That results in logs of no such tableno such table error messages because CONSTRAINT FOREIGN KEYSCONSTRAINT FOREIGN KEYS come before the respective CREATE TABLECREATE TABLE...
Is that a bug?

Ggeelen can you send me the chunk of SQL that shows the statements in the wrong order?

Hannes•4/19/24, 8:58 PM

Sure, thanks for looking into this. I'll send you a DM. Or should I create a GitHub Issue?

__tweak^prone `campaign.description === undefined ? null : campaign.description` or make a wr...

森

森@VerseLink (RW)•4/20/24, 2:34 AM

wouldn't campaign.description ?? nullcampaign.description ?? null work the same but more concise and easy to read?

yellott•4/20/24, 6:02 AM

Hi there, is there any recommended workflow on D1 migration to reduce/eliminate downtime? Maybe something CF specific, wasn't able to find anything related in the docs.