How can we export the sqlite backup file for our beta D1?

PPaul How can we export the sqlite backup file for our beta D1?

Cyb3r-Jak3•10/28/23, 3:32 PM

You can use https://github.com/nora-soderlund/cloudflare-d1-backups to backup your database and then download that. There is currently no built in way

Onik•10/28/23, 5:54 PM

Hey guys, has anyone tried to access their database using a client? or is it only via packages they provided or API?
Client being like HeidiSQL, or Visual Studio Code Database Extension

Dahoom•10/28/23, 6:13 PM

I think the only way to access it is through workers/cloudflare REST api

OOnik Hey guys, has anyone tried to access their database using a client? or is it onl...

Dahoom•10/28/23, 6:16 PM

You could create your own worker that routes your sql queries or you can use https://github.com/elithrar/http-api-d1-example (I have not used it for a while so I'm unsure if it still works)

Onik•10/28/23, 6:17 PM

sounds good, thanks

Kkian Here should be fine - in the interim, if you open your browser’s devtools, you’l...

Old Man Maker•10/28/23, 6:21 PM

That's really awesome

Rex•10/28/23, 7:21 PM

Is there a way to upload sql to d1?

Rex•10/28/23, 7:29 PM

or run sql

RRex or run sql

Dahoom•10/28/23, 7:30 PM

https://developers.cloudflare.com/workers/wrangler/commands/#execute

Commands - Wrangler · Cloudflare Workers docs

Create, develop, and deploy your Cloudflare Workers with Wrangler commands.

Rex•10/28/23, 7:31 PM

Thank you

EvanPiro•10/28/23, 7:32 PM

When running migrations that create temp tables, copy data, drop the original tables, and rename the new tables, how much memory do I have to perform this operation?

EvanPiro•10/28/23, 7:33 PM

For instance sqlite doesn't support adding a foreign key column to an existing table, so you need to create a new table and migrate.

DDahoom https://developers.cloudflare.com/workers/wrangler/commands/#execute

Rex•10/28/23, 8:04 PM

Trying to run commands read on page but it just says syntac error

Dahoom•10/28/23, 8:04 PM

that means your command is incorrect

Dahoom•10/28/23, 8:04 PM

use gippity to form your command

Dahoom•10/28/23, 8:05 PM

some people mistake the understandable mistake of using regular sql syntax with sqlite

Rex•10/28/23, 8:07 PM

whats the command to execute sql i made?

Dahoom•10/28/23, 8:08 PM

Rex•10/28/23, 8:08 PM

like how can i inject my sql into the databvase

Dahoom•10/28/23, 8:10 PM

Its been a while since i've done it but its something similar to

wrangler d1 execute <DATABASE_NAME> --command "SELECT * FROM table"

wrangler d1 execute <DATABASE_NAME> --command "SELECT * FROM table"

Rex•10/28/23, 8:11 PM

right

Rex•10/28/23, 8:11 PM

still having issues but its fine for now

kian•10/29/23, 11:02 AM

How have you checked that the database doesn’t update?

IdkWhatever69•10/29/23, 5:21 PM

hi guys

IdkWhatever69•10/29/23, 5:22 PM

hows the d1 latency?

Original message was deleted

IdkWhatever69•10/29/23, 7:44 PM

doesnt d1 automatically spawn replicas?

IdkWhatever69•10/29/23, 9:03 PM

does D1 also have the write constrains of sqlite? (max ~1-10k row writes/s)

VViper Is it possible to insert the data into a table and read it through the same func...

omar4289•10/30/23, 6:42 AM

add returning * just before ; in your insert

omar4289•10/30/23, 6:42 AM

insert into .. values .. returning *;

IdkWhatever69•10/30/23, 6:48 AM

does D1 also have the write constrains of sqlite? (i.e. max of 1-2k row writes/s)

kian•10/30/23, 7:04 AM

I imagine you're going to hit the constraints of D1/Durable Objects before hitting the constraints of SQLite.

IIdkWhatever69 does D1 also have the write constrains of sqlite? (i.e. max of 1-2k row writes/s...

Matt Silverlock•10/30/23, 10:02 AM

You can write (depending on the query complexity, tables, indexes) far more than 1-2k rows per second.

MMatt Silverlock You can write (depending on the query complexity, tables, indexes) far more than...

omar4289•10/30/23, 10:03 AM

Do we have exact metrics on how many are possible/how many was used to test the load of d1

Oomar4289 Do we have exact metrics on how many are possible/how many was used to test the ...

Matt Silverlock•10/30/23, 10:05 AM

No, because it deeply depends on query complexity, schema, etc. It’s not 1:1. You can write millions of rows per second in many, many cases.

MMatt Silverlock No, because it deeply depends on query complexity, schema, etc. It’s not 1:1. Yo...

omar4289•10/30/23, 10:06 AM

I know, but just wondering if you could share the results you have, even if it is for simple queries

omar4289•10/30/23, 10:07 AM

Currently, I am always using simple insert queries in my d1 and delegating complex queries to supabase

Sslagathor Right now I'm using DataGrip with https://github.com/isaac-mcfadyen/d1-jdbc-driv...

Isaac McFadyen•10/30/23, 12:04 PM

Sorry

Isaac McFadyen•10/30/23, 12:04 PM

I've had very little time to maintain it with school being so busy - I'll try to fix some of the outstanding issues if I get the chance sometime soon

JustinNoel•10/30/23, 12:25 PM

Thanks so much to @Isaac McFadyen | YYZ01 for his awesome d1-consoled1-console.

If you're not familiar with it, it lets you query your Cloudflare D1 database from your command line.

https://github.com/isaac-mcfadyen/d1-console

GitHub

GitHub - isaac-mcfadyen/d1-console: A full query console for Cloudf...

A full query console for Cloudflare's D1 database product. - GitHub - isaac-mcfadyen/d1-console: A full query console for Cloudflare's D1 database product.

VViper Like this? ```ts const { results } = await DB.prepare('INSERT INTO users (id, na...

omar4289•10/30/23, 12:43 PM

Should be, if all() does not work, then use run() instead

kian•10/30/23, 1:33 PM

JSONB was in the draft release log for 3.44.0 but isn't in that one, so I imagine it was pulled from that release.

Hearse•10/30/23, 1:54 PM

i am currently using mongodb to store user and their device data, is it a good idea to switch d1?

Dahoom•10/30/23, 1:55 PM

d1 is in beta and has a 2GB per database limit currently

Hearse•10/30/23, 1:55 PM

i am not familiar with sql databases so i am kind of on the fence.

How can we export the sqlite backup file for our beta D1?

Similar Threads

Similar Threads

Similar Threads