Ah I see you have a thread open at https://canary.discord.com/channels/595317990191398933/1151930094

Ah I see you have a thread open at https://canary.discord.com/channels/595317990191398933/1151930094504390736/1151930094504390736. This definitely isn't D1 related, so please keep the discussion to that thread. Someone will reply to you if and when they can assist

JJames maven repo for what exactly? I'm not sure this is D1 related 🤔 Can you expand?

ReeachyZ_•9/14/23, 5:40 PM

I think I must have gone to the wrong channel. But basically I want to check whenever there is a DDoS attack (with the cloudflare api) block all traffic from the country of origin until the attack is stopped. Instead of doing this manually in the dashboard, I wanted to do it automatically.

JJames Ah I see you have a thread open at https://canary.discord.com/channels/595317990...

ReeachyZ_•9/14/23, 5:40 PM

Ok, thank you

dave•9/14/23, 6:24 PM

Is there an easy command I can do to dump everything from my local D1 database?

dave•9/14/23, 6:24 PM

like all tables, rows, etc

SSanju Has anyone successfully raised their D1 database limit here? If yes, what's the ...

Matt Silverlock•9/14/23, 7:37 PM

Number of databases? What are you looking for? We aren't raising storage limits one-off, but we can raise the # of databases.

Matt Silverlock•9/14/23, 7:59 PM

We've published some useful database-level commands in the docs: https://developers.cloudflare.com/d1/learning/database-commands/

Debug D1 · Cloudflare D1 docs

D1 supports a number of database-level commands that allow you to list tables, indexes, and inspect the schema for a given table or index.

Ccopper Was out of the loop, was there work on D1's write performance in the meantime? A...

Dahoom•9/15/23, 7:09 AM

compared to the older versions of d1?

Dahoom•9/15/23, 7:10 AM

personally i saw 2x-3x faster query speeds

walkersyed581•9/15/23, 7:10 AM

Hi guys, new dev here. I am using hono with Drizzle as ORM and d1 sqlite as database and having trouble with delete routes in production although they work just fine locally. I am getting the "D1_Error: not authorized" on all the routes that attempt to create a transaction and then delete a record from the DB using Drizzle. Need some help with this. It would be very much appreciated

Dahoom•9/15/23, 7:11 AM

check out the blog here

Dahoom•9/15/23, 7:11 AM

https://blog.cloudflare.com/d1-turning-it-up-to-11/

The Cloudflare Blog

D1: We turned it up to 11

We've been heads down iterating on D1, and we've just shipped a major new version that's substantially faster, more reliable, and introduces Time Travel: the ability to restore a D1 database to any point in time.

Dahoom•9/15/23, 7:12 AM

"We’ve also not yet started to optimize our overall write throughput, and so expect D1 to only get faster here."

Dahoom•9/15/23, 7:13 AM

go ahead and test it out yourself, now that you can bind d1 to a worker you can easily create a benchmark for write performance in a couple minutes

Dahoom•9/15/23, 7:15 AM

heard about it for the first time yesterday but other than seeing the pricing, no I have not tried it

Dahoom•9/15/23, 7:17 AM

did you try it?

Ccopper @WalkerSyed581 did you try at drizzle's issues and discussion on gh?

walkersyed581•9/15/23, 7:18 AM

Ah... No. Sorry. Looked into it now and it has something to do with drizzle transactions. My bad

Dahoom•9/15/23, 7:19 AM

hows the w/r speed?

Dahoom•9/15/23, 7:24 AM

I'm testing it out, thanks for the recommendation

Wwalkersyed581 Hi guys, new dev here. I am using hono with Drizzle as ORM and d1 sqlite as data...

Max (@rozenmd)•9/15/23, 7:59 AM

Remove the transaction - we're already doing that for you

Ccopper reads are very fast b/c of the free rpelication

Max (@rozenmd)•9/15/23, 7:59 AM

there's no replication yet

Max (@rozenmd)•9/15/23, 8:01 AM

Max (@rozenmd)•9/15/23, 8:05 AM

I personally don't know since I mainly work on D1's "frontend", but D1 isn't exactly pitched as a write-heavy db

Max (@rozenmd)•9/15/23, 8:06 AM

there's fun stuff we could be doing with queues to smooth-out the load though

EvanPiro•9/15/23, 2:36 PM

How would I handle updating a table that exists in D1? The following is failing:

ALTER TABLE transcript ADD COLUMN IF NOT EXISTS date_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

ALTER TABLE transcript ADD COLUMN IF NOT EXISTS date_created TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

dave•9/15/23, 4:35 PM

Does D1 optimize duplicate queries that are in the same .batch(...).batch(...)?

Original message was deleted

EvanPiro•9/15/23, 4:46 PM

I just found wrangler d1 migrationswrangler d1 migrations which is essentially what I was trying to do so I no longer need that query.

Ah I see you have a thread open at https://canary.discord.com/channels/595317990191398933/1151930094

Similar Threads