Cloudflare Developers•2y ago

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 exportwrangler 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 TABLE

CREATE 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.

oof2win2•4/20/24, 4:43 PM

add a cronjob and an expiry field, every cronjob execution just delete the expired ones

oof2win2•4/20/24, 4:43 PM

ideally with an index on the expired field

oof2win2•4/20/24, 4:43 PM

since you dont want to go over all sessions to delete expired ones

VVitamin Protein One question can I use cloudflare d1 with the django app ? The whole documenta...

Hello, I’m Allie!•4/20/24, 5:44 PM

You can, but we do always recommend using a Worker anyway

Hello, I’m Allie!•4/20/24, 5:45 PM

Create a small Worker that converts the incoming query(in whatever format you want) into a D1 query, then passes it in

Hello, I’m Allie!•4/20/24, 5:45 PM

The Cloudflare API is not a very performant way of accessing D1

oof2win2•4/20/24, 6:03 PM

i mean cf just dogfeeds everything and workers + DO is essentially everything

oof2win2•4/20/24, 6:03 PM

iirc D1 is also a DO instance with sqlite in it

oof2win2•4/20/24, 6:04 PM

you can implement everything from the ground up with do and workers

oof2win2•4/20/24, 6:04 PM

which is why its easy to build stuff with the basic building blocks; its sort of like asking why is lego made from bricks

VVitamin Protein I mean I really hate scalling up my SQL database as it's hard but for my fastapi...

Hello, I’m Allie!•4/20/24, 6:09 PM

If you are running a server in a single place, there isn’t really a big reason to use D1

Hello, I’m Allie!•4/20/24, 6:10 PM

Why not just use SQLite yourself?

Hello, I’m Allie!•4/20/24, 6:10 PM

Or Postgres

Hello, I’m Allie!•4/20/24, 6:10 PM

Or any other database

oof2win2•4/20/24, 6:19 PM

oh i didnt know what you are using kv as well

oof2win2•4/20/24, 6:20 PM

just delete the kv entry and d1 entry and create the new ones

oof2win2•4/20/24, 6:20 PM

or idk what you are asking

oof2win2•4/20/24, 6:32 PM

i mean d1 is also just sqlite

oof2win2•4/20/24, 6:32 PM

so it will run at the same speed

oof2win2•4/20/24, 6:33 PM

you should probably check out EXPLAIN QUERY PLAN and see if you are using the right indices

sophiedev•4/21/24, 3:07 AM

hello

sophiedev•4/21/24, 3:08 AM

Is anyone there? I need a litle help with D1 and wrangler

semaja2•4/21/24, 8:48 AM

I am not sure if I am missing anything, but when I run npx wrangler pages devnpx wrangler pages dev and it binds the D1 database, all the queries suggest it has no data, but if I deploy to CF it works perfectly fine

semaja2•4/21/24, 8:49 AM

Is it possible to bind to the remote db?

semaja2•4/21/24, 8:50 AM

dang

semaja2•4/21/24, 8:50 AM

can you do it with workers? or just a general limitation

semaja2•4/21/24, 8:52 AM

thanks, ill have to do some more digging, still not sure what the exact benefits of pages over workers is

Oom Can anyone explain me why is there so much difference of duration for result ret...

Hello, I’m Allie!•4/21/24, 11:31 AM

D1's query time is how long the DB spent processing your query. Drizzle's is based on that + the transit time from your Worker to the D1 instance and back

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

Similar Threads

Similar Threads

Similar Threads